PHPOffice / PhpSpreadsheet

docs/Examples/Reader/exampleReader08.php

Spacing +4 added lines, -4 removed lines

@@ -31,18 +31,18 @@
 $inputFileName = './sampleData/example1.xls';
 $sheetnames = ['Data Sheet #1', 'Data Sheet #3'];
 
-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 />';
 $reader = IOFactory::createReader($inputFileType);
-echo 'Loading Sheet',((count($sheetnames) == 1) ? '' : 's'),' "',implode('" and "', $sheetnames),'" only<br />';
+echo 'Loading Sheet', ((count($sheetnames) == 1) ? '' : 's'), ' "', implode('" and "', $sheetnames), '" only<br />';
 $reader->setLoadSheetsOnly($sheetnames);
 $spreadsheet = $reader->load($inputFileName);
 
 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 $sheetIndex,' -> ',$loadedSheetName,'<br />';
+    echo $sheetIndex, ' -> ', $loadedSheetName, '<br />';
 }
 
 ?>

docs/Examples/Reader/exampleReader18.php

Spacing +1 added lines, -1 removed lines

@@ -30,7 +30,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 />';
 
 $reader = IOFactory::createReader($inputFileType);
 $worksheetNames = $reader->listWorksheetNames($inputFileName);

docs/Examples/Reader/exampleReader05.php

Spacing +1 added lines, -1 removed lines

@@ -30,7 +30,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 />';
 $reader = IOFactory::createReader($inputFileType);
 echo 'Turning Formatting off for Load<br />';
 $reader->setReadDataOnly(true);

docs/Examples/Reader/exampleReader06.php

Spacing +1 added lines, -1 removed lines

@@ -30,7 +30,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 />';
 $reader = IOFactory::createReader($inputFileType);
 echo 'Loading all WorkSheets<br />';
 $reader->setLoadAllSheets();

docs/Examples/Reader/exampleReader10.php

Spacing +2 added lines, -2 removed lines

@@ -60,9 +60,9 @@
 
 $filterSubset = new MyReadFilter(9, 15, range('G', 'K'));
 
-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 />';
 $reader = IOFactory::createReader($inputFileType);
-echo 'Loading Sheet "',$sheetname,'" only<br />';
+echo 'Loading Sheet "', $sheetname, '" only<br />';
 $reader->setLoadSheetsOnly($sheetname);
 echo 'Loading Sheet using configurable filter<br />';
 $reader->setReadFilter($filterSubset);

docs/Examples/Reader/exampleReader12.php

Spacing +1 added lines, -1 removed lines

@@ -57,7 +57,7 @@
     }
 }
 
-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 />';
 /*  Create a new Reader of the type defined in $inputFileType  **/
 $reader = IOFactory::createReader($inputFileType);
 

docs/Examples/Reader/exampleReader16.php

Spacing +1 added lines, -1 removed lines

@@ -25,7 +25,7 @@
 require_once __DIR__ . '/../../../src/Bootstrap.php';
 
 $inputFileName = './sampleData/example_1.xls';
-echo 'Loading file ',pathinfo($inputFileName, PATHINFO_BASENAME),' using IOFactory to identify the format<br />';
+echo 'Loading file ', pathinfo($inputFileName, PATHINFO_BASENAME), ' using IOFactory to identify the format<br />';
 try {
     $spreadsheet = IOFactory::load($inputFileName);
 } catch (InvalidArgumentException $e) {

docs/Examples/Reader/exampleReader02.php

Spacing +1 added lines, -1 removed lines

@@ -25,7 +25,7 @@
 
 $inputFileName = './sampleData/example1.xls';
 
-echo 'Loading file ',pathinfo($inputFileName, PATHINFO_BASENAME),' using \PhpOffice\PhpSpreadsheet\Reader\Xls<br />';
+echo 'Loading file ', pathinfo($inputFileName, PATHINFO_BASENAME), ' using \PhpOffice\PhpSpreadsheet\Reader\Xls<br />';
 $reader = new Xls();
 //	$reader = new \PhpOffice\PhpSpreadsheet\Reader\Xlsx();
 //	$reader = new \PhpOffice\PhpSpreadsheet\Reader\Xml();

src/PhpSpreadsheet/Reader/Xlsx.php

Spacing +6 added lines, -6 removed lines

@@ -1358,15 +1358,15 @@ 
                                         Settings::getLibXmlLoaderOptions()
                                     );
 
-                                    if($vmlCommentsFile !== FALSE) {
+                                    if ($vmlCommentsFile !== FALSE) {
                                         $vmlCommentsFile->registerXPathNamespace('v', 'urn:schemas-microsoft-com:vml');
                                         $shapes = $vmlCommentsFile->xpath('//v:shape');
                                         foreach ($shapes as $shape) {
                                             $shape->registerXPathNamespace('v', 'urn:schemas-microsoft-com:vml');
 
                                             if (isset($shape['style'])) {
-                                                $style = (string)$shape['style'];
-                                                $fillColor = strtoupper(substr((string)$shape['fillcolor'], 1));
+                                                $style = (string) $shape['style'];
+                                                $fillColor = strtoupper(substr((string) $shape['fillcolor'], 1));
                                                 $column = null;
                                                 $row = null;
 
@@ -1374,7 +1374,7 @@ 
                                                 if (is_array($clientData) && !empty($clientData)) {
                                                     $clientData = $clientData[0];
 
-                                                    if (isset($clientData['ObjectType']) && (string)$clientData['ObjectType'] == 'Note') {
+                                                    if (isset($clientData['ObjectType']) && (string) $clientData['ObjectType'] == 'Note') {
                                                         $temp = $clientData->xpath('.//x:Row');
                                                         if (is_array($temp)) {
                                                             $row = $temp[0];
@@ -1389,7 +1389,7 @@ 
 
                                                 if (($column !== null) && ($row !== null)) {
                                                     // Set comment properties
-                                                    $comment = $docSheet->getCommentByColumnAndRow((string)$column, $row + 1);
+                                                    $comment = $docSheet->getCommentByColumnAndRow((string) $column, $row + 1);
                                                     $comment->getFillColor()->setRGB($fillColor);
 
                                                     // Parse style
@@ -1417,7 +1417,7 @@ 
                                             }
                                         }
                                     } else {
-                                        error_log('Invalid VML Comment XML File '.$fileWorksheet.'/'.$relPath);
+                                        error_log('Invalid VML Comment XML File ' . $fileWorksheet . '/' . $relPath);
                                     }
                                 }