PHPOffice / PhpSpreadsheet

src/PhpSpreadsheet/Writer/Xlsx.php

Indentation +2 added lines, -2 removed lines

@@ -140,8 +140,8 @@
         }
 
         $hashTablesArray = ['stylesConditionalHashTable', 'fillHashTable', 'fontHashTable',
-                                  'bordersHashTable', 'numFmtHashTable', 'drawingHashTable',
-                                  'styleHashTable',
+                                    'bordersHashTable', 'numFmtHashTable', 'drawingHashTable',
+                                    'styleHashTable',
                                 ];
 
         // Set HashTable variables

src/PhpSpreadsheet/Writer/Xls/Worksheet.php

Indentation +8 added lines, -8 removed lines

@@ -1147,14 +1147,14 @@
 
         // Pack the main data stream
         $data = pack('vvvv', $row1, $row2, $col1, $col2) .
-                          $unknown1 .
-                          $link_type .
-                          $unknown2 .
-                          $up_count .
-                          $dir_short_len .
-                          $dir_short .
-                          $unknown3 .
-                          $stream_len; /*.
+                            $unknown1 .
+                            $link_type .
+                            $unknown2 .
+                            $up_count .
+                            $dir_short_len .
+                            $dir_short .
+                            $unknown3 .
+                            $stream_len; /*.
                           $dir_long_len .
                           $unknown4     .
                           $dir_long     .

docs/Examples/Calculations/DateTime/TIME.php

Indentation +3 added lines, -3 removed lines

@@ -33,7 +33,7 @@ 
 $testDates = [[3, 15],        [13, 15],    [15, 15, 15],    [3, 15, 30],
                     [15, 15, 15],    [5],        [9, 15, 0],        [9, 15, -1],
                     [13, -14, -15],    [0, 0, -1],
-                  ];
+                    ];
 $testDateCount = count($testDates);
 
 $worksheet->fromArray($testDates, null, 'A1', true);
@@ -43,8 +43,8 @@ 
     $worksheet->setCellValue('E' . $row, '=D' . $row);
 }
 $worksheet->getStyle('E1:E' . $testDateCount)
-          ->getNumberFormat()
-          ->setFormatCode('hh:mm:ss');
+            ->getNumberFormat()
+            ->setFormatCode('hh:mm:ss');
 
 echo '<hr />';
 

Spacing +3 added lines, -3 removed lines

@@ -30,9 +30,9 @@
 $worksheet = $spreadsheet->getActiveSheet();
 
 // Add some data
-$testDates = [[3, 15],        [13, 15],    [15, 15, 15],    [3, 15, 30],
-                    [15, 15, 15],    [5],        [9, 15, 0],        [9, 15, -1],
-                    [13, -14, -15],    [0, 0, -1],
+$testDates = [[3, 15], [13, 15], [15, 15, 15], [3, 15, 30],
+                    [15, 15, 15], [5], [9, 15, 0], [9, 15, -1],
+                    [13, -14, -15], [0, 0, -1],
                   ];
 $testDateCount = count($testDates);
 

docs/Examples/Calculations/DateTime/DATEVALUE.php

Indentation +3 added lines, -3 removed lines

@@ -34,7 +34,7 @@ 
                     '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) {
@@ -44,8 +44,8 @@ 
 }
 
 $worksheet->getStyle('C1:C' . $testDateCount)
-          ->getNumberFormat()
-          ->setFormatCode('yyyy-mmm-dd');
+            ->getNumberFormat()
+            ->setFormatCode('yyyy-mmm-dd');
 
 echo '<hr />';
 

Spacing +4 added lines, -4 removed lines

@@ -30,10 +30,10 @@
 $worksheet = $spreadsheet->getActiveSheet();
 
 // Add some data
-$testDates = ['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 = ['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);
 

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/Reading WorkBook Data/exampleWorkBookReader03.php

Spacing +1 added lines, -1 removed lines

@@ -41,7 +41,7 @@
 echo '<b>Custom Properties: </b><br />';
 /*  Loop through the list of custom properties  **/
 foreach ($customPropertyList as $customPropertyName) {
-    echo '<b>',$customPropertyName,': </b>';
+    echo '<b>', $customPropertyName, ': </b>';
     /*  Retrieve the property value  **/
     $propertyValue = $spreadsheet->getProperties()->getCustomPropertyValue($customPropertyName);
     /*  Retrieve the property type  **/

docs/Examples/Reader/exampleReader13.php

Spacing +2 added lines, -2 removed lines

@@ -30,11 +30,11 @@
 
 $reader = \PhpOffice\PhpSpreadsheet\IOFactory::createReader($inputFileType);
 $inputFileName = array_shift($inputFileNames);
-echo 'Loading file ',pathinfo($inputFileName, PATHINFO_BASENAME),' into WorkSheet #1 using IOFactory with a defined reader type of ',$inputFileType,'<br />';
+echo 'Loading file ', pathinfo($inputFileName, PATHINFO_BASENAME), ' into WorkSheet #1 using IOFactory with a defined reader type of ', $inputFileType, '<br />';
 $spreadsheet = $reader->load($inputFileName);
 $spreadsheet->getActiveSheet()->setTitle(pathinfo($inputFileName, PATHINFO_BASENAME));
 foreach ($inputFileNames as $sheet => $inputFileName) {
-    echo 'Loading file ',pathinfo($inputFileName, PATHINFO_BASENAME),' into WorkSheet #',($sheet + 2),' using IOFactory with a defined reader type of ',$inputFileType,'<br />';
+    echo 'Loading file ', pathinfo($inputFileName, PATHINFO_BASENAME), ' into WorkSheet #', ($sheet + 2), ' using IOFactory with a defined reader type of ', $inputFileType, '<br />';
     $reader->setSheetIndex($sheet + 1);
     $reader->loadIntoExisting($inputFileName, $spreadsheet);
     $spreadsheet->getActiveSheet()->setTitle(pathinfo($inputFileName, PATHINFO_BASENAME));

docs/Examples/Reader/exampleReader15.php

Spacing +3 added lines, -3 removed lines

@@ -26,17 +26,17 @@
 $inputFileName = './sampleData/example1.tsv';
 
 $reader = \PhpOffice\PhpSpreadsheet\IOFactory::createReader($inputFileType);
-echo 'Loading file ',pathinfo($inputFileName, PATHINFO_BASENAME),' into WorkSheet #1 using IOFactory with a defined reader type of ',$inputFileType,'<br />';
+echo 'Loading file ', pathinfo($inputFileName, PATHINFO_BASENAME), ' into WorkSheet #1 using IOFactory with a defined reader type of ', $inputFileType, '<br />';
 $reader->setDelimiter("\t");
 $spreadsheet = $reader->load($inputFileName);
 $spreadsheet->getActiveSheet()->setTitle(pathinfo($inputFileName, PATHINFO_BASENAME));
 
 echo '<hr />';
 
-echo $spreadsheet->getSheetCount(),' worksheet',(($spreadsheet->getSheetCount() == 1) ? '' : 's'),' loaded<br /><br />';
+echo $spreadsheet->getSheetCount(), ' worksheet', (($spreadsheet->getSheetCount() == 1) ? '' : 's'), ' loaded<br /><br />';
 $loadedSheetNames = $spreadsheet->getSheetNames();
 foreach ($loadedSheetNames as $sheetIndex => $loadedSheetName) {
-    echo '<b>Worksheet #',$sheetIndex,' -> ',$loadedSheetName,' (Formatted)</b><br />';
+    echo '<b>Worksheet #', $sheetIndex, ' -> ', $loadedSheetName, ' (Formatted)</b><br />';
     $spreadsheet->setActiveSheetIndexByName($loadedSheetName);
     $sheetData = $spreadsheet->getActiveSheet()->toArray(null, true, true, true);
     var_dump($sheetData);