PHPOffice / PhpSpreadsheet

Documentation/Examples/Calculations/Database/DSTDEVP.php

Indentation +10 added lines, -10 removed lines

@@ -33,17 +33,17 @@
 

 // Add some data

 $database = array( array( 'Tree',  'Height', 'Age', 'Yield', 'Profit' ),

-                   array( 'Apple',  18,       20,    14,      105.00  ),

-                   array( 'Pear',   12,       12,    10,       96.00  ),

-                   array( 'Cherry', 13,       14,     9,      105.00  ),

-                   array( 'Apple',  14,       15,    10,       75.00  ),

-                   array( 'Pear',    9,        8,     8,       76.80  ),

-                   array( 'Apple',   8,        9,     6,       45.00  ),

-                 );

+                    array( 'Apple',  18,       20,    14,      105.00  ),

+                    array( 'Pear',   12,       12,    10,       96.00  ),

+                    array( 'Cherry', 13,       14,     9,      105.00  ),

+                    array( 'Apple',  14,       15,    10,       75.00  ),

+                    array( 'Pear',    9,        8,     8,       76.80  ),

+                    array( 'Apple',   8,        9,     6,       45.00  ),

+                    );

 $criteria = array( array( 'Tree',      'Height', 'Age', 'Yield', 'Profit', 'Height' ),

-                   array( '="=Apple"', '>10',    NULL,  NULL,    NULL,     '<16'    ),

-                   array( '="=Pear"',  NULL,     NULL,  NULL,    NULL,     NULL     )

-                 );

+                    array( '="=Apple"', '>10',    NULL,  NULL,    NULL,     '<16'    ),

+                    array( '="=Pear"',  NULL,     NULL,  NULL,    NULL,     NULL     )

+                    );

 

 $worksheet->fromArray( $criteria, NULL, 'A1' );

 $worksheet->fromArray( $database, NULL, 'A4' );

Spacing +18 added lines, -18 removed lines

@@ -32,21 +32,21 @@ 
 $worksheet = $objPHPExcel->getActiveSheet();

 

 // Add some data

-$database = array( array( 'Tree',  'Height', 'Age', 'Yield', 'Profit' ),

-                   array( 'Apple',  18,       20,    14,      105.00  ),

-                   array( 'Pear',   12,       12,    10,       96.00  ),

-                   array( 'Cherry', 13,       14,     9,      105.00  ),

-                   array( 'Apple',  14,       15,    10,       75.00  ),

-                   array( 'Pear',    9,        8,     8,       76.80  ),

-                   array( 'Apple',   8,        9,     6,       45.00  ),

+$database = array(array('Tree', 'Height', 'Age', 'Yield', 'Profit'),

+                   array('Apple', 18, 20, 14, 105.00),

+                   array('Pear', 12, 12, 10, 96.00),

+                   array('Cherry', 13, 14, 9, 105.00),

+                   array('Apple', 14, 15, 10, 75.00),

+                   array('Pear', 9, 8, 8, 76.80),

+                   array('Apple', 8, 9, 6, 45.00),

                  );

-$criteria = array( array( 'Tree',      'Height', 'Age', 'Yield', 'Profit', 'Height' ),

-                   array( '="=Apple"', '>10',    NULL,  NULL,    NULL,     '<16'    ),

-                   array( '="=Pear"',  NULL,     NULL,  NULL,    NULL,     NULL     )

+$criteria = array(array('Tree', 'Height', 'Age', 'Yield', 'Profit', 'Height'),

+                   array('="=Apple"', '>10', NULL, NULL, NULL, '<16'),

+                   array('="=Pear"', NULL, NULL, NULL, NULL, NULL)

                  );

 

-$worksheet->fromArray( $criteria, NULL, 'A1' );

-$worksheet->fromArray( $database, NULL, 'A4' );

+$worksheet->fromArray($criteria, NULL, 'A1');

+$worksheet->fromArray($database, NULL, 'A4');

 

 $worksheet->setCellValue('A12', 'The standard deviation in the yield of Apple and Pear trees');

 $worksheet->setCellValue('B12', '=DSTDEVP(A4:E10,"Yield",A1:A3)');

@@ -60,7 +60,7 @@ 
 

 echo '<h4>Database</h4>';

 

-$databaseData = $worksheet->rangeToArray('A4:E10',null,true,true,true);

+$databaseData = $worksheet->rangeToArray('A4:E10', null, true, true, true);

 var_dump($databaseData);

 

 

@@ -70,18 +70,18 @@ 
 // Test the formulae

 echo '<h4>Criteria</h4>';

 

-$criteriaData = $worksheet->rangeToArray('A1:A3',null,true,true,true);

+$criteriaData = $worksheet->rangeToArray('A1:A3', null, true, true, true);

 var_dump($criteriaData);

 

-echo $worksheet->getCell("A12")->getValue() .'<br />';

-echo 'DSTDEVP() Result is ' . $worksheet->getCell("B12")->getCalculatedValue() .'<br /><br />';

+echo $worksheet->getCell("A12")->getValue() . '<br />';

+echo 'DSTDEVP() Result is ' . $worksheet->getCell("B12")->getCalculatedValue() . '<br /><br />';

 

 echo '<h4>Criteria</h4>';

 

-$criteriaData = $worksheet->rangeToArray('A1:A3',null,true,true,true);

+$criteriaData = $worksheet->rangeToArray('A1:A3', null, true, true, true);

 var_dump($criteriaData);

 

-echo $worksheet->getCell("A13")->getValue() .'<br />';

+echo $worksheet->getCell("A13")->getValue() . '<br />';

 echo 'DSTDEVP() Result is ' . $worksheet->getCell("B13")->getCalculatedValue();

 

 

Documentation/Examples/Calculations/DateTime/DATEVALUE.php

Indentation +18 added lines, -18 removed lines

@@ -33,21 +33,21 @@ 
 
 // Add some data
 $testDates = array(	'26 March 2012',	'29 Feb 2012',	'April 1, 2012',	'25/12/2012',
-					'2012-Oct-31',		'5th November',	'January 1st',		'April 2012',
-					'17-03',			'03-2012',		'29 Feb 2011',		'03-05-07',
-					'03-MAY-07',		'03-13-07',
-				  );
+                    '2012-Oct-31',		'5th November',	'January 1st',		'April 2012',
+                    '17-03',			'03-2012',		'29 Feb 2011',		'03-05-07',
+                    '03-MAY-07',		'03-13-07',
+                    );
 $testDateCount = count($testDates);
 
 for($row = 1; $row <= $testDateCount; ++$row) {
-	$worksheet->setCellValue('A'.$row, $testDates[$row-1]);
-	$worksheet->setCellValue('B'.$row, '=DATEVALUE(A'.$row.')');
-	$worksheet->setCellValue('C'.$row, '=B'.$row);
+    $worksheet->setCellValue('A'.$row, $testDates[$row-1]);
+    $worksheet->setCellValue('B'.$row, '=DATEVALUE(A'.$row.')');
+    $worksheet->setCellValue('C'.$row, '=B'.$row);
 }
 
 $worksheet->getStyle('C1:C'.$testDateCount)
-          ->getNumberFormat()
-          ->setFormatCode('yyyy-mmm-dd');
+            ->getNumberFormat()
+            ->setFormatCode('yyyy-mmm-dd');
 
 
 echo '<hr />';
@@ -64,13 +64,13 @@ 
 		<th>Formatted DateStamp</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 +13 added lines, -13 removed lines

@@ -32,20 +32,20 @@ 
 $worksheet = $objPHPExcel->getActiveSheet();
 
 // Add some data
-$testDates = array(	'26 March 2012',	'29 Feb 2012',	'April 1, 2012',	'25/12/2012',
-					'2012-Oct-31',		'5th November',	'January 1st',		'April 2012',
-					'17-03',			'03-2012',		'29 Feb 2011',		'03-05-07',
-					'03-MAY-07',		'03-13-07',
+$testDates = array('26 March 2012', '29 Feb 2012', 'April 1, 2012', '25/12/2012',
+					'2012-Oct-31', '5th November', 'January 1st', 'April 2012',
+					'17-03', '03-2012', '29 Feb 2011', '03-05-07',
+					'03-MAY-07', '03-13-07',
 				  );
 $testDateCount = count($testDates);
 
-for($row = 1; $row <= $testDateCount; ++$row) {
-	$worksheet->setCellValue('A'.$row, $testDates[$row-1]);
-	$worksheet->setCellValue('B'.$row, '=DATEVALUE(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, '=DATEVALUE(A' . $row . ')');
+	$worksheet->setCellValue('C' . $row, '=B' . $row);
 }
 
-$worksheet->getStyle('C1:C'.$testDateCount)
+$worksheet->getStyle('C1:C' . $testDateCount)
           ->getNumberFormat()
           ->setFormatCode('yyyy-mmm-dd');
 
@@ -66,10 +66,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/Calculations/DateTime/DATE.php

Indentation +20 added lines, -20 removed lines

@@ -33,22 +33,22 @@ 
 
 // Add some data
 $testDates = array(	array(2012,3,26),	array(2012,2,29),	array(2012,4,1),	array(2012,12,25),
-					array(2012,10,31),	array(2012,11,5),	array(2012,1,1),	array(2012,3,17),
-					array(2011,2,29),	array(7,5,3),		array(2012,13,1),	array(2012,11,45),
-					array(2012,0,0),	array(2012,1,0),	array(2012,0,1),
-					array(2012,-2,2),	array(2012,2,-2),	array(2012,-2,-2),
-				  );
+                    array(2012,10,31),	array(2012,11,5),	array(2012,1,1),	array(2012,3,17),
+                    array(2011,2,29),	array(7,5,3),		array(2012,13,1),	array(2012,11,45),
+                    array(2012,0,0),	array(2012,1,0),	array(2012,0,1),
+                    array(2012,-2,2),	array(2012,2,-2),	array(2012,-2,-2),
+                    );
 $testDateCount = count($testDates);
 
 $worksheet->fromArray($testDates,NULL,'A1',true);
 
 for ($row = 1; $row <= $testDateCount; ++$row) {
-	$worksheet->setCellValue('D'.$row, '=DATE(A'.$row.',B'.$row.',C'.$row.')');
-	$worksheet->setCellValue('E'.$row, '=D'.$row);
+    $worksheet->setCellValue('D'.$row, '=DATE(A'.$row.',B'.$row.',C'.$row.')');
+    $worksheet->setCellValue('E'.$row, '=D'.$row);
 }
 $worksheet->getStyle('E1:E'.$testDateCount)
-          ->getNumberFormat()
-          ->setFormatCode('yyyy-mmm-dd');
+            ->getNumberFormat()
+            ->setFormatCode('yyyy-mmm-dd');
 
 
 echo '<hr />';
@@ -69,15 +69,15 @@ 
 		<th>Day</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)->getFormattedValue() , '</td>';
-			echo '<td>' , $worksheet->getCell('C'.$row)->getFormattedValue() , '</td>';
-			echo '<td>' , $worksheet->getCell('D'.$row)->getValue() , '</td>';
-			echo '<td>' , $worksheet->getCell('D'.$row)->getFormattedValue() , '</td>';
-			echo '<td>' , $worksheet->getCell('E'.$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)->getFormattedValue() , '</td>';
+            echo '<td>' , $worksheet->getCell('C'.$row)->getFormattedValue() , '</td>';
+            echo '<td>' , $worksheet->getCell('D'.$row)->getValue() , '</td>';
+            echo '<td>' , $worksheet->getCell('D'.$row)->getFormattedValue() , '</td>';
+            echo '<td>' , $worksheet->getCell('E'.$row)->getFormattedValue() , '</td>';
+        echo '</tr>';
+    }
+    ?>
 </table>
\ No newline at end of file

Spacing +15 added lines, -15 removed lines

@@ -32,21 +32,21 @@ 
 $worksheet = $objPHPExcel->getActiveSheet();
 
 // Add some data
-$testDates = array(	array(2012,3,26),	array(2012,2,29),	array(2012,4,1),	array(2012,12,25),
-					array(2012,10,31),	array(2012,11,5),	array(2012,1,1),	array(2012,3,17),
-					array(2011,2,29),	array(7,5,3),		array(2012,13,1),	array(2012,11,45),
-					array(2012,0,0),	array(2012,1,0),	array(2012,0,1),
-					array(2012,-2,2),	array(2012,2,-2),	array(2012,-2,-2),
+$testDates = array(array(2012, 3, 26), array(2012, 2, 29), array(2012, 4, 1), array(2012, 12, 25),
+					array(2012, 10, 31), array(2012, 11, 5), array(2012, 1, 1), array(2012, 3, 17),
+					array(2011, 2, 29), array(7, 5, 3), array(2012, 13, 1), array(2012, 11, 45),
+					array(2012, 0, 0), array(2012, 1, 0), array(2012, 0, 1),
+					array(2012, -2, 2), array(2012, 2, -2), array(2012, -2, -2),
 				  );
 $testDateCount = count($testDates);
 
-$worksheet->fromArray($testDates,NULL,'A1',true);
+$worksheet->fromArray($testDates, NULL, 'A1', true);
 
 for ($row = 1; $row <= $testDateCount; ++$row) {
-	$worksheet->setCellValue('D'.$row, '=DATE(A'.$row.',B'.$row.',C'.$row.')');
-	$worksheet->setCellValue('E'.$row, '=D'.$row);
+	$worksheet->setCellValue('D' . $row, '=DATE(A' . $row . ',B' . $row . ',C' . $row . ')');
+	$worksheet->setCellValue('E' . $row, '=D' . $row);
 }
-$worksheet->getStyle('E1:E'.$testDateCount)
+$worksheet->getStyle('E1:E' . $testDateCount)
           ->getNumberFormat()
           ->setFormatCode('yyyy-mmm-dd');
 
@@ -71,12 +71,12 @@ 
 	<?php
 	for ($row = 1; $row <= $testDateCount; ++$row) {
 		echo '<tr>';
-		    echo '<td>' , $worksheet->getCell('A'.$row)->getFormattedValue() , '</td>';
-			echo '<td>' , $worksheet->getCell('B'.$row)->getFormattedValue() , '</td>';
-			echo '<td>' , $worksheet->getCell('C'.$row)->getFormattedValue() , '</td>';
-			echo '<td>' , $worksheet->getCell('D'.$row)->getValue() , '</td>';
-			echo '<td>' , $worksheet->getCell('D'.$row)->getFormattedValue() , '</td>';
-			echo '<td>' , $worksheet->getCell('E'.$row)->getFormattedValue() , '</td>';
+		    echo '<td>', $worksheet->getCell('A' . $row)->getFormattedValue(), '</td>';
+			echo '<td>', $worksheet->getCell('B' . $row)->getFormattedValue(), '</td>';
+			echo '<td>', $worksheet->getCell('C' . $row)->getFormattedValue(), '</td>';
+			echo '<td>', $worksheet->getCell('D' . $row)->getValue(), '</td>';
+			echo '<td>', $worksheet->getCell('D' . $row)->getFormattedValue(), '</td>';
+			echo '<td>', $worksheet->getCell('E' . $row)->getFormattedValue(), '</td>';
 		echo '</tr>';
 	}
 	?>

Documentation/Examples/Calculations/DateTime/TIME.php

Indentation +18 added lines, -18 removed lines

@@ -33,20 +33,20 @@ 
 
 // Add some data
 $testDates = array(	array(3,15),		array(13,15),	array(15,15,15),	array(3,15,30),
-					array(15,15,15),	array(5),		array(9,15,0),		array(9,15,-1),
-					array(13,-14,-15),	array(0,0,-1)
-				  );
+                    array(15,15,15),	array(5),		array(9,15,0),		array(9,15,-1),
+                    array(13,-14,-15),	array(0,0,-1)
+                    );
 $testDateCount = count($testDates);
 
 $worksheet->fromArray($testDates,NULL,'A1',true);
 
 for ($row = 1; $row <= $testDateCount; ++$row) {
-	$worksheet->setCellValue('D'.$row, '=TIME(A'.$row.',B'.$row.',C'.$row.')');
-	$worksheet->setCellValue('E'.$row, '=D'.$row);
+    $worksheet->setCellValue('D'.$row, '=TIME(A'.$row.',B'.$row.',C'.$row.')');
+    $worksheet->setCellValue('E'.$row, '=D'.$row);
 }
 $worksheet->getStyle('E1:E'.$testDateCount)
-          ->getNumberFormat()
-          ->setFormatCode('hh:mm:ss');
+            ->getNumberFormat()
+            ->setFormatCode('hh:mm:ss');
 
 
 echo '<hr />';
@@ -67,15 +67,15 @@ 
 		<th>Second</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)->getFormattedValue() , '</td>';
-			echo '<td>' , $worksheet->getCell('C'.$row)->getFormattedValue() , '</td>';
-			echo '<td>' , $worksheet->getCell('D'.$row)->getValue() , '</td>';
-			echo '<td>' , $worksheet->getCell('D'.$row)->getFormattedValue() , '</td>';
-			echo '<td>' , $worksheet->getCell('E'.$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)->getFormattedValue() , '</td>';
+            echo '<td>' , $worksheet->getCell('C'.$row)->getFormattedValue() , '</td>';
+            echo '<td>' , $worksheet->getCell('D'.$row)->getValue() , '</td>';
+            echo '<td>' , $worksheet->getCell('D'.$row)->getFormattedValue() , '</td>';
+            echo '<td>' , $worksheet->getCell('E'.$row)->getFormattedValue() , '</td>';
+        echo '</tr>';
+    }
+    ?>
 </table>
\ No newline at end of file

Spacing +13 added lines, -13 removed lines

@@ -32,19 +32,19 @@ 
 $worksheet = $objPHPExcel->getActiveSheet();
 
 // Add some data
-$testDates = array(	array(3,15),		array(13,15),	array(15,15,15),	array(3,15,30),
-					array(15,15,15),	array(5),		array(9,15,0),		array(9,15,-1),
-					array(13,-14,-15),	array(0,0,-1)
+$testDates = array(array(3, 15), array(13, 15), array(15, 15, 15), array(3, 15, 30),
+					array(15, 15, 15), array(5), array(9, 15, 0), array(9, 15, -1),
+					array(13, -14, -15), array(0, 0, -1)
 				  );
 $testDateCount = count($testDates);
 
-$worksheet->fromArray($testDates,NULL,'A1',true);
+$worksheet->fromArray($testDates, NULL, 'A1', true);
 
 for ($row = 1; $row <= $testDateCount; ++$row) {
-	$worksheet->setCellValue('D'.$row, '=TIME(A'.$row.',B'.$row.',C'.$row.')');
-	$worksheet->setCellValue('E'.$row, '=D'.$row);
+	$worksheet->setCellValue('D' . $row, '=TIME(A' . $row . ',B' . $row . ',C' . $row . ')');
+	$worksheet->setCellValue('E' . $row, '=D' . $row);
 }
-$worksheet->getStyle('E1:E'.$testDateCount)
+$worksheet->getStyle('E1:E' . $testDateCount)
           ->getNumberFormat()
           ->setFormatCode('hh:mm:ss');
 
@@ -69,12 +69,12 @@ 
 	<?php
 	for ($row = 1; $row <= $testDateCount; ++$row) {
 		echo '<tr>';
-		    echo '<td>' , $worksheet->getCell('A'.$row)->getFormattedValue() , '</td>';
-			echo '<td>' , $worksheet->getCell('B'.$row)->getFormattedValue() , '</td>';
-			echo '<td>' , $worksheet->getCell('C'.$row)->getFormattedValue() , '</td>';
-			echo '<td>' , $worksheet->getCell('D'.$row)->getValue() , '</td>';
-			echo '<td>' , $worksheet->getCell('D'.$row)->getFormattedValue() , '</td>';
-			echo '<td>' , $worksheet->getCell('E'.$row)->getFormattedValue() , '</td>';
+		    echo '<td>', $worksheet->getCell('A' . $row)->getFormattedValue(), '</td>';
+			echo '<td>', $worksheet->getCell('B' . $row)->getFormattedValue(), '</td>';
+			echo '<td>', $worksheet->getCell('C' . $row)->getFormattedValue(), '</td>';
+			echo '<td>', $worksheet->getCell('D' . $row)->getValue(), '</td>';
+			echo '<td>', $worksheet->getCell('D' . $row)->getFormattedValue(), '</td>';
+			echo '<td>', $worksheet->getCell('E' . $row)->getFormattedValue(), '</td>';
 		echo '</tr>';
 	}
 	?>

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/Calculations/index.php

Indentation +15 added lines, -15 removed lines

@@ -23,27 +23,27 @@
 

 foreach($exampleTypeList as $exampleType) {

 

-	echo '<h2>' . pathinfo($exampleType,PATHINFO_BASENAME) . ' Function Examples</h2>';

+    echo '<h2>' . pathinfo($exampleType,PATHINFO_BASENAME) . ' Function Examples</h2>';

 

-	$exampleList = glob('./'.$exampleType.'/*.php');

+    $exampleList = glob('./'.$exampleType.'/*.php');

 

-	foreach($exampleList as $exampleFile) {

-		$fileData = file_get_contents($exampleFile);

+    foreach($exampleList as $exampleFile) {

+        $fileData = file_get_contents($exampleFile);

 

-		$h1Pattern = '#<h1>(.*?)</h1>#';

-		$h2Pattern = '#<h2>(.*?)</h2>#';

+        $h1Pattern = '#<h1>(.*?)</h1>#';

+        $h2Pattern = '#<h2>(.*?)</h2>#';

 

-		if (preg_match($h1Pattern, $fileData, $out)) {

-			$h1Text = $out[1];

-			$h2Text = (preg_match($h2Pattern, $fileData, $out)) ? $out[1] : '';

+        if (preg_match($h1Pattern, $fileData, $out)) {

+            $h1Text = $out[1];

+            $h2Text = (preg_match($h2Pattern, $fileData, $out)) ? $out[1] : '';

 

-			echo '<a href="',$exampleFile,'">',$h1Text,'</a><br />';

-			if ($h2Text > '') {

-				echo $h2Text,'<br />';

-			}

-		}

+            echo '<a href="',$exampleFile,'">',$h1Text,'</a><br />';

+            if ($h2Text > '') {

+                echo $h2Text,'<br />';

+            }

+        }

 

-	}

+    }

 }

 

 ?>

Spacing +7 added lines, -7 removed lines

@@ -19,15 +19,15 @@ 
 

 echo '<h1>PHPExcel Calculation Function Examples</h1>';

 

-$exampleTypeList = glob('./*',GLOB_ONLYDIR);

+$exampleTypeList = glob('./*', GLOB_ONLYDIR);

 

-foreach($exampleTypeList as $exampleType) {

+foreach ($exampleTypeList as $exampleType) {

 

-	echo '<h2>' . pathinfo($exampleType,PATHINFO_BASENAME) . ' Function Examples</h2>';

+	echo '<h2>' . pathinfo($exampleType, PATHINFO_BASENAME) . ' Function Examples</h2>';

 

-	$exampleList = glob('./'.$exampleType.'/*.php');

+	$exampleList = glob('./' . $exampleType . '/*.php');

 

-	foreach($exampleList as $exampleFile) {

+	foreach ($exampleList as $exampleFile) {

 		$fileData = file_get_contents($exampleFile);

 

 		$h1Pattern = '#<h1>(.*?)</h1>#';

@@ -37,9 +37,9 @@ 
 			$h1Text = $out[1];

 			$h2Text = (preg_match($h2Pattern, $fileData, $out)) ? $out[1] : '';

 

-			echo '<a href="',$exampleFile,'">',$h1Text,'</a><br />';

+			echo '<a href="', $exampleFile, '">', $h1Text, '</a><br />';

 			if ($h2Text > '') {

-				echo $h2Text,'<br />';

+				echo $h2Text, '<br />';

 			}

 		}

 

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 />';
 }