PHPOffice / PhpSpreadsheet

docs/Examples/Reader/exampleReader05.php

Spacing +1 added lines, -1 removed lines

@@ -32,7 +32,7 @@
 //	$inputFileType = 'Gnumeric';
 $inputFileName = './sampleData/example1.xls';
 
-echo 'Loading file ',pathinfo($inputFileName, PATHINFO_BASENAME),' using IOFactory with a defined reader type of ',$inputFileType,'<br />';
+echo 'Loading file ', pathinfo($inputFileName, PATHINFO_BASENAME), ' using IOFactory with a defined reader type of ', $inputFileType, '<br />';
 $objReader = PHPExcel_IOFactory::createReader($inputFileType);
 echo 'Turning Formatting off for Load<br />';
 $objReader->setReadDataOnly(true);

docs/Examples/Reader/exampleReader17.php

Spacing +3 added lines, -3 removed lines

@@ -32,16 +32,16 @@
 //	$inputFileType = 'Gnumeric';
 $inputFileName = './sampleData/example1.xls';
 
-echo 'Loading file ',pathinfo($inputFileName, PATHINFO_BASENAME),' using IOFactory with a defined reader type of ',$inputFileType,'<br />';
+echo 'Loading file ', pathinfo($inputFileName, PATHINFO_BASENAME), ' using IOFactory with a defined reader type of ', $inputFileType, '<br />';
 $objReader = PHPExcel_IOFactory::createReader($inputFileType);
 
 /*  Read the list of Worksheet Names from the Workbook file  **/
 echo 'Read the list of Worksheets in the WorkBook<br />';
 $worksheetNames = $objReader->listWorksheetNames($inputFileName);
 
-echo 'There are ',count($worksheetNames),' worksheet',((count($worksheetNames) == 1) ? '' : 's'),' in the workbook<br /><br />';
+echo 'There are ', count($worksheetNames), ' worksheet', ((count($worksheetNames) == 1) ? '' : 's'), ' in the workbook<br /><br />';
 foreach ($worksheetNames as $worksheetName) {
-    echo $worksheetName,'<br />';
+    echo $worksheetName, '<br />';
 }
 
 ?>

docs/Examples/Calculations/index.php

Spacing +2 added lines, -2 removed lines

@@ -34,10 +34,10 @@
             $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 > '') &&
                 (pathinfo($exampleType, PATHINFO_BASENAME) != 'Calculations')) {
-                echo $h2Text,'<br />';
+                echo $h2Text, '<br />';
             }
         }
     }

docs/Examples/Calculations/DateTime/TIMEVALUE.php

Indentation +3 added lines, -3 removed lines

@@ -31,7 +31,7 @@ 
 
 // Add some data
 $testDates = ['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) {
@@ -41,8 +41,8 @@ 
 }
 
 $worksheet->getStyle('C1:C' . $testDateCount)
-          ->getNumberFormat()
-          ->setFormatCode('hh:mm:ss');
+            ->getNumberFormat()
+            ->setFormatCode('hh:mm:ss');
 
 echo '<hr />';
 

Spacing +1 added lines, -1 removed lines

@@ -30,7 +30,7 @@
 $worksheet = $spreadsheet->getActiveSheet();
 
 // Add some data
-$testDates = ['3:15',    '13:15',    '15:15:15',    '3:15 AM',    '3:15 PM',    '5PM',    '9:15AM',    '13:15AM',
+$testDates = ['3:15', '13:15', '15:15:15', '3:15 AM', '3:15 PM', '5PM', '9:15AM', '13:15AM',
                   ];
 $testDateCount = count($testDates);
 

docs/Examples/Calculations/DateTime/DATE.php

Indentation +3 added lines, -3 removed lines

@@ -35,7 +35,7 @@ 
                     [2011, 2, 29],    [7, 5, 3],        [2012, 13, 1],    [2012, 11, 45],
                     [2012, 0, 0],    [2012, 1, 0],    [2012, 0, 1],
                     [2012, -2, 2],    [2012, 2, -2],    [2012, -2, -2],
-                  ];
+                    ];
 $testDateCount = count($testDates);
 
 $worksheet->fromArray($testDates, null, 'A1', true);
@@ -45,8 +45,8 @@ 
     $worksheet->setCellValue('E' . $row, '=D' . $row);
 }
 $worksheet->getStyle('E1:E' . $testDateCount)
-          ->getNumberFormat()
-          ->setFormatCode('yyyy-mmm-dd');
+            ->getNumberFormat()
+            ->setFormatCode('yyyy-mmm-dd');
 
 echo '<hr />';
 

Spacing +5 added lines, -5 removed lines

@@ -30,11 +30,11 @@
 $worksheet = $spreadsheet->getActiveSheet();
 
 // Add some data
-$testDates = [[2012, 3, 26],    [2012, 2, 29],    [2012, 4, 1],    [2012, 12, 25],
-                    [2012, 10, 31],    [2012, 11, 5],    [2012, 1, 1],    [2012, 3, 17],
-                    [2011, 2, 29],    [7, 5, 3],        [2012, 13, 1],    [2012, 11, 45],
-                    [2012, 0, 0],    [2012, 1, 0],    [2012, 0, 1],
-                    [2012, -2, 2],    [2012, 2, -2],    [2012, -2, -2],
+$testDates = [[2012, 3, 26], [2012, 2, 29], [2012, 4, 1], [2012, 12, 25],
+                    [2012, 10, 31], [2012, 11, 5], [2012, 1, 1], [2012, 3, 17],
+                    [2011, 2, 29], [7, 5, 3], [2012, 13, 1], [2012, 11, 45],
+                    [2012, 0, 0], [2012, 1, 0], [2012, 0, 1],
+                    [2012, -2, 2], [2012, 2, -2], [2012, -2, -2],
                   ];
 $testDateCount = count($testDates);
 

docs/Examples/Calculations/Database/DSTDEVP.php

Indentation +10 added lines, -10 removed lines

@@ -31,17 +31,17 @@
 
 // Add some data
 $database = [['Tree',  'Height', 'Age', 'Yield', 'Profit'],
-                   ['Apple',  18,       20,    14,      105.00],
-                   ['Pear',   12,       12,    10,       96.00],
-                   ['Cherry', 13,       14,     9,      105.00],
-                   ['Apple',  14,       15,    10,       75.00],
-                   ['Pear',    9,        8,     8,       76.80],
-                   ['Apple',   8,        9,     6,       45.00],
-                 ];
+                    ['Apple',  18,       20,    14,      105.00],
+                    ['Pear',   12,       12,    10,       96.00],
+                    ['Cherry', 13,       14,     9,      105.00],
+                    ['Apple',  14,       15,    10,       75.00],
+                    ['Pear',    9,        8,     8,       76.80],
+                    ['Apple',   8,        9,     6,       45.00],
+                    ];
 $criteria = [['Tree',      'Height', 'Age', 'Yield', 'Profit', 'Height'],
-                   ['="=Apple"', '>10',    null,  null,    null,     '<16'],
-                   ['="=Pear"',  null,     null,  null,    null,     null],
-                 ];
+                    ['="=Apple"', '>10',    null,  null,    null,     '<16'],
+                    ['="=Pear"',  null,     null,  null,    null,     null],
+                    ];
 
 $worksheet->fromArray($criteria, null, 'A1');
 $worksheet->fromArray($database, null, 'A4');

Spacing +10 added lines, -10 removed lines

@@ -30,17 +30,17 @@
 $worksheet = $objPHPExcel->getActiveSheet();
 
 // Add some data
-$database = [['Tree',  'Height', 'Age', 'Yield', 'Profit'],
-                   ['Apple',  18,       20,    14,      105.00],
-                   ['Pear',   12,       12,    10,       96.00],
-                   ['Cherry', 13,       14,     9,      105.00],
-                   ['Apple',  14,       15,    10,       75.00],
-                   ['Pear',    9,        8,     8,       76.80],
-                   ['Apple',   8,        9,     6,       45.00],
+$database = [['Tree', 'Height', 'Age', 'Yield', 'Profit'],
+                   ['Apple', 18, 20, 14, 105.00],
+                   ['Pear', 12, 12, 10, 96.00],
+                   ['Cherry', 13, 14, 9, 105.00],
+                   ['Apple', 14, 15, 10, 75.00],
+                   ['Pear', 9, 8, 8, 76.80],
+                   ['Apple', 8, 9, 6, 45.00],
                  ];
-$criteria = [['Tree',      'Height', 'Age', 'Yield', 'Profit', 'Height'],
-                   ['="=Apple"', '>10',    null,  null,    null,     '<16'],
-                   ['="=Pear"',  null,     null,  null,    null,     null],
+$criteria = [['Tree', 'Height', 'Age', 'Yield', 'Profit', 'Height'],
+                   ['="=Apple"', '>10', null, null, null, '<16'],
+                   ['="=Pear"', null, null, null, null, null],
                  ];
 
 $worksheet->fromArray($criteria, null, 'A1');

docs/Examples/Calculations/Database/DGET.php

Indentation +10 added lines, -10 removed lines

@@ -31,17 +31,17 @@
 
 // Add some data
 $database = [['Tree',  'Height', 'Age', 'Yield', 'Profit'],
-                   ['Apple',  18,       20,    14,      105.00],
-                   ['Pear',   12,       12,    10,       96.00],
-                   ['Cherry', 13,       14,     9,      105.00],
-                   ['Apple',  14,       15,    10,       75.00],
-                   ['Pear',    9,        8,     8,       76.80],
-                   ['Apple',   8,        9,     6,       45.00],
-                 ];
+                    ['Apple',  18,       20,    14,      105.00],
+                    ['Pear',   12,       12,    10,       96.00],
+                    ['Cherry', 13,       14,     9,      105.00],
+                    ['Apple',  14,       15,    10,       75.00],
+                    ['Pear',    9,        8,     8,       76.80],
+                    ['Apple',   8,        9,     6,       45.00],
+                    ];
 $criteria = [['Tree',      'Height', 'Age', 'Yield', 'Profit', 'Height'],
-                   ['="=Apple"', '>10',    null,  null,    null,     '<16'],
-                   ['="=Pear"',  null,     null,  null,    null,     null],
-                 ];
+                    ['="=Apple"', '>10',    null,  null,    null,     '<16'],
+                    ['="=Pear"',  null,     null,  null,    null,     null],
+                    ];
 
 $worksheet->fromArray($criteria, null, 'A1');
 $worksheet->fromArray($database, null, 'A4');

Spacing +10 added lines, -10 removed lines

@@ -30,17 +30,17 @@
 $worksheet = $objPHPExcel->getActiveSheet();
 
 // Add some data
-$database = [['Tree',  'Height', 'Age', 'Yield', 'Profit'],
-                   ['Apple',  18,       20,    14,      105.00],
-                   ['Pear',   12,       12,    10,       96.00],
-                   ['Cherry', 13,       14,     9,      105.00],
-                   ['Apple',  14,       15,    10,       75.00],
-                   ['Pear',    9,        8,     8,       76.80],
-                   ['Apple',   8,        9,     6,       45.00],
+$database = [['Tree', 'Height', 'Age', 'Yield', 'Profit'],
+                   ['Apple', 18, 20, 14, 105.00],
+                   ['Pear', 12, 12, 10, 96.00],
+                   ['Cherry', 13, 14, 9, 105.00],
+                   ['Apple', 14, 15, 10, 75.00],
+                   ['Pear', 9, 8, 8, 76.80],
+                   ['Apple', 8, 9, 6, 45.00],
                  ];
-$criteria = [['Tree',      'Height', 'Age', 'Yield', 'Profit', 'Height'],
-                   ['="=Apple"', '>10',    null,  null,    null,     '<16'],
-                   ['="=Pear"',  null,     null,  null,    null,     null],
+$criteria = [['Tree', 'Height', 'Age', 'Yield', 'Profit', 'Height'],
+                   ['="=Apple"', '>10', null, null, null, '<16'],
+                   ['="=Pear"', null, null, null, null, null],
                  ];
 
 $worksheet->fromArray($criteria, null, 'A1');

docs/Examples/Calculations/Database/DMIN.php

Indentation +10 added lines, -10 removed lines

@@ -31,17 +31,17 @@
 
 // Add some data
 $database = [['Tree',  'Height', 'Age', 'Yield', 'Profit'],
-                   ['Apple',  18,       20,    14,      105.00],
-                   ['Pear',   12,       12,    10,       96.00],
-                   ['Cherry', 13,       14,     9,      105.00],
-                   ['Apple',  14,       15,    10,       75.00],
-                   ['Pear',    9,        8,     8,       76.80],
-                   ['Apple',   8,        9,     6,       45.00],
-                 ];
+                    ['Apple',  18,       20,    14,      105.00],
+                    ['Pear',   12,       12,    10,       96.00],
+                    ['Cherry', 13,       14,     9,      105.00],
+                    ['Apple',  14,       15,    10,       75.00],
+                    ['Pear',    9,        8,     8,       76.80],
+                    ['Apple',   8,        9,     6,       45.00],
+                    ];
 $criteria = [['Tree',      'Height', 'Age', 'Yield', 'Profit', 'Height'],
-                   ['="=Apple"', '>10',    null,  null,    null,     '<16'],
-                   ['="=Pear"',  null,     null,  null,    null,     null],
-                 ];
+                    ['="=Apple"', '>10',    null,  null,    null,     '<16'],
+                    ['="=Pear"',  null,     null,  null,    null,     null],
+                    ];
 
 $worksheet->fromArray($criteria, null, 'A1');
 $worksheet->fromArray($database, null, 'A4');

Spacing +10 added lines, -10 removed lines

@@ -30,17 +30,17 @@
 $worksheet = $objPHPExcel->getActiveSheet();
 
 // Add some data
-$database = [['Tree',  'Height', 'Age', 'Yield', 'Profit'],
-                   ['Apple',  18,       20,    14,      105.00],
-                   ['Pear',   12,       12,    10,       96.00],
-                   ['Cherry', 13,       14,     9,      105.00],
-                   ['Apple',  14,       15,    10,       75.00],
-                   ['Pear',    9,        8,     8,       76.80],
-                   ['Apple',   8,        9,     6,       45.00],
+$database = [['Tree', 'Height', 'Age', 'Yield', 'Profit'],
+                   ['Apple', 18, 20, 14, 105.00],
+                   ['Pear', 12, 12, 10, 96.00],
+                   ['Cherry', 13, 14, 9, 105.00],
+                   ['Apple', 14, 15, 10, 75.00],
+                   ['Pear', 9, 8, 8, 76.80],
+                   ['Apple', 8, 9, 6, 45.00],
                  ];
-$criteria = [['Tree',      'Height', 'Age', 'Yield', 'Profit', 'Height'],
-                   ['="=Apple"', '>10',    null,  null,    null,     '<16'],
-                   ['="=Pear"',  null,     null,  null,    null,     null],
+$criteria = [['Tree', 'Height', 'Age', 'Yield', 'Profit', 'Height'],
+                   ['="=Apple"', '>10', null, null, null, '<16'],
+                   ['="=Pear"', null, null, null, null, null],
                  ];
 
 $worksheet->fromArray($criteria, null, 'A1');

docs/Examples/Calculations/Database/DVARP.php

Indentation +10 added lines, -10 removed lines

@@ -31,17 +31,17 @@
 
 // Add some data
 $database = [['Tree',  'Height', 'Age', 'Yield', 'Profit'],
-                   ['Apple',  18,       20,    14,      105.00],
-                   ['Pear',   12,       12,    10,       96.00],
-                   ['Cherry', 13,       14,     9,      105.00],
-                   ['Apple',  14,       15,    10,       75.00],
-                   ['Pear',    9,        8,     8,       76.80],
-                   ['Apple',   8,        9,     6,       45.00],
-                 ];
+                    ['Apple',  18,       20,    14,      105.00],
+                    ['Pear',   12,       12,    10,       96.00],
+                    ['Cherry', 13,       14,     9,      105.00],
+                    ['Apple',  14,       15,    10,       75.00],
+                    ['Pear',    9,        8,     8,       76.80],
+                    ['Apple',   8,        9,     6,       45.00],
+                    ];
 $criteria = [['Tree',      'Height', 'Age', 'Yield', 'Profit', 'Height'],
-                   ['="=Apple"', '>10',    null,  null,    null,     '<16'],
-                   ['="=Pear"',  null,     null,  null,    null,     null],
-                 ];
+                    ['="=Apple"', '>10',    null,  null,    null,     '<16'],
+                    ['="=Pear"',  null,     null,  null,    null,     null],
+                    ];
 
 $worksheet->fromArray($criteria, null, 'A1');
 $worksheet->fromArray($database, null, 'A4');

Spacing +10 added lines, -10 removed lines

@@ -30,17 +30,17 @@
 $worksheet = $objPHPExcel->getActiveSheet();
 
 // Add some data
-$database = [['Tree',  'Height', 'Age', 'Yield', 'Profit'],
-                   ['Apple',  18,       20,    14,      105.00],
-                   ['Pear',   12,       12,    10,       96.00],
-                   ['Cherry', 13,       14,     9,      105.00],
-                   ['Apple',  14,       15,    10,       75.00],
-                   ['Pear',    9,        8,     8,       76.80],
-                   ['Apple',   8,        9,     6,       45.00],
+$database = [['Tree', 'Height', 'Age', 'Yield', 'Profit'],
+                   ['Apple', 18, 20, 14, 105.00],
+                   ['Pear', 12, 12, 10, 96.00],
+                   ['Cherry', 13, 14, 9, 105.00],
+                   ['Apple', 14, 15, 10, 75.00],
+                   ['Pear', 9, 8, 8, 76.80],
+                   ['Apple', 8, 9, 6, 45.00],
                  ];
-$criteria = [['Tree',      'Height', 'Age', 'Yield', 'Profit', 'Height'],
-                   ['="=Apple"', '>10',    null,  null,    null,     '<16'],
-                   ['="=Pear"',  null,     null,  null,    null,     null],
+$criteria = [['Tree', 'Height', 'Age', 'Yield', 'Profit', 'Height'],
+                   ['="=Apple"', '>10', null, null, null, '<16'],
+                   ['="=Pear"', null, null, null, null, null],
                  ];
 
 $worksheet->fromArray($criteria, null, 'A1');