PHPOffice / PhpSpreadsheet

Documentation/Examples/Calculations/DateTime/TIMEVALUE.php

Indentation +15 added lines, -15 removed lines

@@ -33,18 +33,18 @@ 
 
 // Add some data
 $testDates = array(	'3:15',	'13:15',	'15:15:15',	'3:15 AM',	'3:15 PM',	'5PM',	'9:15AM',	'13:15AM'
-				  );
+                    );
 $testDateCount = count($testDates);
 
 for($row = 1; $row <= $testDateCount; ++$row) {
-	$worksheet->setCellValue('A'.$row, $testDates[$row-1]);
-	$worksheet->setCellValue('B'.$row, '=TIMEVALUE(A'.$row.')');
-	$worksheet->setCellValue('C'.$row, '=B'.$row);
+    $worksheet->setCellValue('A'.$row, $testDates[$row-1]);
+    $worksheet->setCellValue('B'.$row, '=TIMEVALUE(A'.$row.')');
+    $worksheet->setCellValue('C'.$row, '=B'.$row);
 }
 
 $worksheet->getStyle('C1:C'.$testDateCount)
-          ->getNumberFormat()
-          ->setFormatCode('hh:mm:ss');
+            ->getNumberFormat()
+            ->setFormatCode('hh:mm:ss');
 
 
 echo '<hr />';
@@ -60,13 +60,13 @@ 
 		<th>Formatted TimeStamp</th>
 	</tr>
 	<?php
-	for ($row = 1; $row <= $testDateCount; ++$row) {
-		echo '<tr>';
-		    echo '<td>' , $worksheet->getCell('A'.$row)->getFormattedValue() , '</td>';
-			echo '<td>' , $worksheet->getCell('B'.$row)->getValue() , '</td>';
-			echo '<td>' , $worksheet->getCell('B'.$row)->getFormattedValue() , '</td>';
-			echo '<td>' , $worksheet->getCell('C'.$row)->getFormattedValue() , '</td>';
-		echo '</tr>';
-	}
-	?>
+    for ($row = 1; $row <= $testDateCount; ++$row) {
+        echo '<tr>';
+            echo '<td>' , $worksheet->getCell('A'.$row)->getFormattedValue() , '</td>';
+            echo '<td>' , $worksheet->getCell('B'.$row)->getValue() , '</td>';
+            echo '<td>' , $worksheet->getCell('B'.$row)->getFormattedValue() , '</td>';
+            echo '<td>' , $worksheet->getCell('C'.$row)->getFormattedValue() , '</td>';
+        echo '</tr>';
+    }
+    ?>
 </table>
\ No newline at end of file

Spacing +10 added lines, -10 removed lines

@@ -32,17 +32,17 @@ 
 $worksheet = $objPHPExcel->getActiveSheet();
 
 // Add some data
-$testDates = array(	'3:15',	'13:15',	'15:15:15',	'3:15 AM',	'3:15 PM',	'5PM',	'9:15AM',	'13:15AM'
+$testDates = array('3:15', '13:15', '15:15:15', '3:15 AM', '3:15 PM', '5PM', '9:15AM', '13:15AM'
 				  );
 $testDateCount = count($testDates);
 
-for($row = 1; $row <= $testDateCount; ++$row) {
-	$worksheet->setCellValue('A'.$row, $testDates[$row-1]);
-	$worksheet->setCellValue('B'.$row, '=TIMEVALUE(A'.$row.')');
-	$worksheet->setCellValue('C'.$row, '=B'.$row);
+for ($row = 1; $row <= $testDateCount; ++$row) {
+	$worksheet->setCellValue('A' . $row, $testDates[$row - 1]);
+	$worksheet->setCellValue('B' . $row, '=TIMEVALUE(A' . $row . ')');
+	$worksheet->setCellValue('C' . $row, '=B' . $row);
 }
 
-$worksheet->getStyle('C1:C'.$testDateCount)
+$worksheet->getStyle('C1:C' . $testDateCount)
           ->getNumberFormat()
           ->setFormatCode('hh:mm:ss');
 
@@ -62,10 +62,10 @@ 
 	<?php
 	for ($row = 1; $row <= $testDateCount; ++$row) {
 		echo '<tr>';
-		    echo '<td>' , $worksheet->getCell('A'.$row)->getFormattedValue() , '</td>';
-			echo '<td>' , $worksheet->getCell('B'.$row)->getValue() , '</td>';
-			echo '<td>' , $worksheet->getCell('B'.$row)->getFormattedValue() , '</td>';
-			echo '<td>' , $worksheet->getCell('C'.$row)->getFormattedValue() , '</td>';
+		    echo '<td>', $worksheet->getCell('A' . $row)->getFormattedValue(), '</td>';
+			echo '<td>', $worksheet->getCell('B' . $row)->getValue(), '</td>';
+			echo '<td>', $worksheet->getCell('B' . $row)->getFormattedValue(), '</td>';
+			echo '<td>', $worksheet->getCell('C' . $row)->getFormattedValue(), '</td>';
 		echo '</tr>';
 	}
 	?>

Documentation/Examples/Reading WorkBook Data/exampleWorkBookReader01.php

Spacing +15 added lines, -15 removed lines

@@ -39,53 +39,53 @@
 
 /**  Read the document's creator property  **/
 $creator = $objPHPExcel->getProperties()->getCreator();
-echo '<b>Document Creator: </b>',$creator,'<br />';
+echo '<b>Document Creator: </b>', $creator, '<br />';
 
 /**  Read the Date when the workbook was created (as a PHP timestamp value)  **/
 $creationDatestamp = $objPHPExcel->getProperties()->getCreated();
 /**  Format the date and time using the standard PHP date() function  **/
-$creationDate = date('l, d<\s\up>S</\s\up> F Y',$creationDatestamp);
-$creationTime = date('g:i A',$creationDatestamp);
-echo '<b>Created On: </b>',$creationDate,' at ',$creationTime,'<br />';
+$creationDate = date('l, d<\s\up>S</\s\up> F Y', $creationDatestamp);
+$creationTime = date('g:i A', $creationDatestamp);
+echo '<b>Created On: </b>', $creationDate, ' at ', $creationTime, '<br />';
 
 /**  Read the name of the last person to modify this workbook  **/
 $modifiedBy = $objPHPExcel->getProperties()->getLastModifiedBy();
-echo '<b>Last Modified By: </b>',$modifiedBy,'<br />';
+echo '<b>Last Modified By: </b>', $modifiedBy, '<br />';
 
 /**  Read the Date when the workbook was last modified (as a PHP timestamp value)  **/
 $modifiedDatestamp = $objPHPExcel->getProperties()->getModified();
 /**  Format the date and time using the standard PHP date() function  **/
-$modifiedDate = date('l, d<\s\up>S</\s\up> F Y',$modifiedDatestamp);
-$modifiedTime = date('g:i A',$modifiedDatestamp);
-echo '<b>Last Modified On: </b>',$modifiedDate,' at ',$modifiedTime,'<br />';
+$modifiedDate = date('l, d<\s\up>S</\s\up> F Y', $modifiedDatestamp);
+$modifiedTime = date('g:i A', $modifiedDatestamp);
+echo '<b>Last Modified On: </b>', $modifiedDate, ' at ', $modifiedTime, '<br />';
 
 /**  Read the workbook title property  **/
 $workbookTitle = $objPHPExcel->getProperties()->getTitle();
-echo '<b>Title: </b>',$workbookTitle,'<br />';
+echo '<b>Title: </b>', $workbookTitle, '<br />';
 
 /**  Read the workbook description property  **/
 $description = $objPHPExcel->getProperties()->getDescription();
-echo '<b>Description: </b>',$description,'<br />';
+echo '<b>Description: </b>', $description, '<br />';
 
 /**  Read the workbook subject property  **/
 $subject = $objPHPExcel->getProperties()->getSubject();
-echo '<b>Subject: </b>',$subject,'<br />';
+echo '<b>Subject: </b>', $subject, '<br />';
 
 /**  Read the workbook keywords property  **/
 $keywords = $objPHPExcel->getProperties()->getKeywords();
-echo '<b>Keywords: </b>',$keywords,'<br />';
+echo '<b>Keywords: </b>', $keywords, '<br />';
 
 /**  Read the workbook category property  **/
 $category = $objPHPExcel->getProperties()->getCategory();
-echo '<b>Category: </b>',$category,'<br />';
+echo '<b>Category: </b>', $category, '<br />';
 
 /**  Read the workbook company property  **/
 $company = $objPHPExcel->getProperties()->getCompany();
-echo '<b>Company: </b>',$company,'<br />';
+echo '<b>Company: </b>', $company, '<br />';
 
 /**  Read the workbook manager property  **/
 $manager = $objPHPExcel->getProperties()->getManager();
-echo '<b>Manager: </b>',$manager,'<br />';
+echo '<b>Manager: </b>', $manager, '<br />';
 
 
 ?>

Documentation/Examples/Reading WorkBook Data/exampleWorkBookReader04.php

Indentation +1 added lines, -1 removed lines

@@ -46,7 +46,7 @@
 /**  Use the PHPExcel object's getSheetNames() method to get an array listing the names/titles of the WorkSheets in the WorkBook  */
 $sheetNames = $objPHPExcel->getSheetNames();
 foreach($sheetNames as $sheetIndex => $sheetName) {
-	echo 'WorkSheet #',$sheetIndex,' is named "',$sheetName,'"<br />';
+    echo 'WorkSheet #',$sheetIndex,' is named "',$sheetName,'"<br />';
 }
 
 

Spacing +3 added lines, -3 removed lines

@@ -40,13 +40,13 @@
 echo 'Reading the number of Worksheets in the WorkBook<br />';
 /**  Use the PHPExcel object's getSheetCount() method to get a count of the number of WorkSheets in the WorkBook  */
 $sheetCount = $objPHPExcel->getSheetCount();
-echo 'There ',(($sheetCount == 1) ? 'is' : 'are'),' ',$sheetCount,' WorkSheet',(($sheetCount == 1) ? '' : 's'),' in the WorkBook<br /><br />';
+echo 'There ', (($sheetCount == 1) ? 'is' : 'are'), ' ', $sheetCount, ' WorkSheet', (($sheetCount == 1) ? '' : 's'), ' in the WorkBook<br /><br />';
 
 echo 'Reading the names of Worksheets in the WorkBook<br />';
 /**  Use the PHPExcel object's getSheetNames() method to get an array listing the names/titles of the WorkSheets in the WorkBook  */
 $sheetNames = $objPHPExcel->getSheetNames();
-foreach($sheetNames as $sheetIndex => $sheetName) {
-	echo 'WorkSheet #',$sheetIndex,' is named "',$sheetName,'"<br />';
+foreach ($sheetNames as $sheetIndex => $sheetName) {
+	echo 'WorkSheet #', $sheetIndex, ' is named "', $sheetName, '"<br />';
 }
 
 

Documentation/Examples/Reading WorkBook Data/exampleWorkBookReader02.php

Indentation +1 added lines, -1 removed lines

@@ -42,7 +42,7 @@
 
 echo '<b>Custom Property names: </b><br />';
 foreach($customPropertyList as $customPropertyName) {
-	echo $customPropertyName,'<br />';
+    echo $customPropertyName,'<br />';
 }
 
 

Spacing +2 added lines, -2 removed lines

@@ -41,8 +41,8 @@
 $customPropertyList = $objPHPExcel->getProperties()->getCustomProperties();
 
 echo '<b>Custom Property names: </b><br />';
-foreach($customPropertyList as $customPropertyName) {
-	echo $customPropertyName,'<br />';
+foreach ($customPropertyList as $customPropertyName) {
+	echo $customPropertyName, '<br />';
 }
 
 

Documentation/Examples/Reading WorkBook Data/exampleWorkBookReader03.php

Indentation +28 added lines, -28 removed lines

@@ -43,34 +43,34 @@
 echo '<b>Custom Properties: </b><br />';
 /**  Loop through the list of custom properties  **/
 foreach($customPropertyList as $customPropertyName) {
-	echo '<b>',$customPropertyName,': </b>';
-	/**  Retrieve the property value  **/
-	$propertyValue = $objPHPExcel->getProperties()->getCustomPropertyValue($customPropertyName);
-	/**  Retrieve the property type  **/
-	$propertyType = $objPHPExcel->getProperties()->getCustomPropertyType($customPropertyName);
-
-	/**  Manipulate properties as appropriate for display purposes  **/
-	switch($propertyType) {
-		case 'i' :	//	integer
-			$propertyType = 'integer number';
-			break;
-		case 'f' :	//	float
-			$propertyType = 'floating point number';
-			break;
-		case 's' :	//	string
-			$propertyType = 'string';
-			break;
-		case 'd' :	//	date
-			$propertyValue = date('l, d<\s\up>S</\s\up> F Y g:i A',$propertyValue);
-			$propertyType = 'date';
-			break;
-		case 'b' :	//	boolean
-			$propertyValue = ($propertyValue) ? 'TRUE' : 'FALSE';
-			$propertyType = 'boolean';
-			break;
-	}
-
-	echo $propertyValue,' (',$propertyType,')<br />';
+    echo '<b>',$customPropertyName,': </b>';
+    /**  Retrieve the property value  **/
+    $propertyValue = $objPHPExcel->getProperties()->getCustomPropertyValue($customPropertyName);
+    /**  Retrieve the property type  **/
+    $propertyType = $objPHPExcel->getProperties()->getCustomPropertyType($customPropertyName);
+
+    /**  Manipulate properties as appropriate for display purposes  **/
+    switch($propertyType) {
+        case 'i' :	//	integer
+            $propertyType = 'integer number';
+            break;
+        case 'f' :	//	float
+            $propertyType = 'floating point number';
+            break;
+        case 's' :	//	string
+            $propertyType = 'string';
+            break;
+        case 'd' :	//	date
+            $propertyValue = date('l, d<\s\up>S</\s\up> F Y g:i A',$propertyValue);
+            $propertyType = 'date';
+            break;
+        case 'b' :	//	boolean
+            $propertyValue = ($propertyValue) ? 'TRUE' : 'FALSE';
+            $propertyType = 'boolean';
+            break;
+    }
+
+    echo $propertyValue,' (',$propertyType,')<br />';
 }
 
 

Spacing +5 added lines, -5 removed lines

@@ -42,15 +42,15 @@ 
 
 echo '<b>Custom Properties: </b><br />';
 /**  Loop through the list of custom properties  **/
-foreach($customPropertyList as $customPropertyName) {
-	echo '<b>',$customPropertyName,': </b>';
+foreach ($customPropertyList as $customPropertyName) {
+	echo '<b>', $customPropertyName, ': </b>';
 	/**  Retrieve the property value  **/
 	$propertyValue = $objPHPExcel->getProperties()->getCustomPropertyValue($customPropertyName);
 	/**  Retrieve the property type  **/
 	$propertyType = $objPHPExcel->getProperties()->getCustomPropertyType($customPropertyName);
 
 	/**  Manipulate properties as appropriate for display purposes  **/
-	switch($propertyType) {
+	switch ($propertyType) {
 		case 'i' :	//	integer
 			$propertyType = 'integer number';
 			break;
@@ -61,7 +61,7 @@ 
 			$propertyType = 'string';
 			break;
 		case 'd' :	//	date
-			$propertyValue = date('l, d<\s\up>S</\s\up> F Y g:i A',$propertyValue);
+			$propertyValue = date('l, d<\s\up>S</\s\up> F Y g:i A', $propertyValue);
 			$propertyType = 'date';
 			break;
 		case 'b' :	//	boolean
@@ -70,7 +70,7 @@ 
 			break;
 	}
 
-	echo $propertyValue,' (',$propertyType,')<br />';
+	echo $propertyValue, ' (', $propertyType, ')<br />';
 }
 
 

Documentation/Examples/Reader/exampleReader18.php

Indentation +1 added lines, -1 removed lines

@@ -41,7 +41,7 @@
 echo '<h3>Worksheet Names</h3>';
 echo '<ol>';
 foreach ($worksheetNames as $worksheetName) {
-	echo '<li>', $worksheetName, '</li>';
+    echo '<li>', $worksheetName, '</li>';
 }
 echo '</ol>';
 

Spacing +1 added lines, -1 removed lines

@@ -33,7 +33,7 @@
 //	$inputFileType = 'Gnumeric';
 $inputFileName = './sampleData/example1.xls';
 
-echo 'Loading file ',pathinfo($inputFileName,PATHINFO_BASENAME),' information using IOFactory with a defined reader type of ',$inputFileType,'<br />';
+echo 'Loading file ', pathinfo($inputFileName, PATHINFO_BASENAME), ' information using IOFactory with a defined reader type of ', $inputFileType, '<br />';
 
 $objReader = PHPExcel_IOFactory::createReader($inputFileType);
 $worksheetData = $objReader->listWorksheetInfo($inputFileName);

Documentation/Examples/Reader/exampleReader19.php

Indentation +4 added lines, -4 removed lines

@@ -41,10 +41,10 @@
 echo '<h3>Worksheet Information</h3>';
 echo '<ol>';
 foreach ($worksheetData as $worksheet) {
-	echo '<li>', $worksheet['worksheetName'], '<br />';
-	echo 'Rows: ', $worksheet['totalRows'], ' Columns: ', $worksheet['totalColumns'], '<br />';
-	echo 'Cell Range: A1:', $worksheet['lastColumnLetter'], $worksheet['totalRows'];
-	echo '</li>';
+    echo '<li>', $worksheet['worksheetName'], '<br />';
+    echo 'Rows: ', $worksheet['totalRows'], ' Columns: ', $worksheet['totalColumns'], '<br />';
+    echo 'Cell Range: A1:', $worksheet['lastColumnLetter'], $worksheet['totalRows'];
+    echo '</li>';
 }
 echo '</ol>';
 

Spacing +1 added lines, -1 removed lines

@@ -33,7 +33,7 @@
 //	$inputFileType = 'Gnumeric';
 $inputFileName = './sampleData/example1.xls';
 
-echo 'Loading file ',pathinfo($inputFileName,PATHINFO_BASENAME),' information using IOFactory with a defined reader type of ',$inputFileType,'<br />';
+echo 'Loading file ', pathinfo($inputFileName, PATHINFO_BASENAME), ' information using IOFactory with a defined reader type of ', $inputFileType, '<br />';
 
 $objReader = PHPExcel_IOFactory::createReader($inputFileType);
 $worksheetData = $objReader->listWorksheetInfo($inputFileName);

src/PhpSpreadsheet/Worksheet/RowDimension.php

Doc Comments +1 added lines, -1 removed lines

@@ -101,7 +101,7 @@
     /**
      * Set Row Height
      *
-     * @param float $pValue
+     * @param integer $pValue
      * @return RowDimension
      */
     public function setRowHeight($pValue = -1)

src/PhpSpreadsheet/Shared/OLE.php

Spacing +1 added lines, -1 removed lines

@@ -266,7 +266,7 @@
     public function _readPpsWks($blockId)
     {
         $fh = $this->getStream($blockId);
-        for ($pos = 0;; $pos += 128) {
+        for ($pos = 0; ; $pos += 128) {
             fseek($fh, $pos, SEEK_SET);
             $nameUtf16 = fread($fh, 64);
             $nameLength = self::_readInt2($fh);