PHPOffice / PhpSpreadsheet

src/PhpSpreadsheet/Style.php

Spacing +9 added lines, -9 removed lines

@@ -327,7 +327,7 @@ 
                                 $rangeStart[1] : $rangeEnd[1] - $yMax + $y;
 
                             // build range for region
-                            $range = $colStart.$rowStart.':'.$colEnd.$rowEnd;
+                            $range = $colStart . $rowStart . ':' . $colEnd . $rowEnd;
 
                             // retrieve relevant style array for region
                             $regionStyles = $pStyles;
@@ -630,14 +630,14 @@ 
         }
 
         return md5(
-            $this->fill->getHashCode().
-            $this->font->getHashCode().
-            $this->borders->getHashCode().
-            $this->alignment->getHashCode().
-            $this->numberFormat->getHashCode().
-            $hashConditionals.
-            $this->protection->getHashCode().
-            ($this->quotePrefix ? 't' : 'f').
+            $this->fill->getHashCode() .
+            $this->font->getHashCode() .
+            $this->borders->getHashCode() .
+            $this->alignment->getHashCode() .
+            $this->numberFormat->getHashCode() .
+            $hashConditionals .
+            $this->protection->getHashCode() .
+            ($this->quotePrefix ? 't' : 'f') .
             __CLASS__
         );
     }

src/PhpSpreadsheet/Writer/PDF.php

Spacing +2 added lines, -2 removed lines

@@ -61,10 +61,10 @@
         $includePath = str_replace('\\', '/', get_include_path());
         $rendererPath = str_replace('\\', '/', $pdfLibraryPath);
         if (strpos($rendererPath, $includePath) === false) {
-            set_include_path(get_include_path().PATH_SEPARATOR.$pdfLibraryPath);
+            set_include_path(get_include_path() . PATH_SEPARATOR . $pdfLibraryPath);
         }
 
-        $rendererName = '\\PhpOffice\\PhpSpreadsheet\\Writer\\PDF\\'.$pdfLibraryName;
+        $rendererName = '\\PhpOffice\\PhpSpreadsheet\\Writer\\PDF\\' . $pdfLibraryName;
         $this->renderer = new $rendererName($spreadsheet);
     }
 

src/PhpSpreadsheet/Writer/Xls.php

Spacing +4 added lines, -4 removed lines

@@ -214,14 +214,14 @@ 
         $this->documentSummaryInformation = $this->writeDocumentSummaryInformation();
         // initialize OLE Document Summary Information
         if (isset($this->documentSummaryInformation) && !empty($this->documentSummaryInformation)) {
-            $OLE_DocumentSummaryInformation = new \PhpOffice\PhpSpreadsheet\Shared\OLE\PPS\File(OLE::ascToUcs(chr(5).'DocumentSummaryInformation'));
+            $OLE_DocumentSummaryInformation = new \PhpOffice\PhpSpreadsheet\Shared\OLE\PPS\File(OLE::ascToUcs(chr(5) . 'DocumentSummaryInformation'));
             $OLE_DocumentSummaryInformation->append($this->documentSummaryInformation);
         }
 
         $this->summaryInformation = $this->writeSummaryInformation();
         // initialize OLE Summary Information
         if (isset($this->summaryInformation) && !empty($this->summaryInformation)) {
-            $OLE_SummaryInformation = new \PhpOffice\PhpSpreadsheet\Shared\OLE\PPS\File(OLE::ascToUcs(chr(5).'SummaryInformation'));
+            $OLE_SummaryInformation = new \PhpOffice\PhpSpreadsheet\Shared\OLE\PPS\File(OLE::ascToUcs(chr(5) . 'SummaryInformation'));
             $OLE_SummaryInformation->append($this->summaryInformation);
         }
 
@@ -367,7 +367,7 @@ 
                     // create an Drawing Object for the dropdown
                     $oDrawing = new BaseDrawing();
                     // get the coordinates of drawing
-                    $cDrawing = Cell::stringFromColumnIndex($iInc - 1).$rangeBounds[0][1];
+                    $cDrawing = Cell::stringFromColumnIndex($iInc - 1) . $rangeBounds[0][1];
                     $oDrawing->setCoordinates($cDrawing);
                     $oDrawing->setWorksheet($sheet);
 
@@ -666,7 +666,7 @@ 
         $dataProp .= pack('v', 0x000A);
         $dataProp .= pack('v', 0x0000);
         // value
-        $dataProp .= 'Worksheet'.chr(0);
+        $dataProp .= 'Worksheet' . chr(0);
 
         $dataSection[] = [
             'summary' => ['pack' => 'V', 'data' => 0x0D],

src/PhpSpreadsheet/Writer/CSV.php

Spacing +4 added lines, -4 removed lines

@@ -131,7 +131,7 @@ 
         }
         if ($this->includeSeparatorLine) {
             // Write the separator line if required
-            fwrite($fileHandle, 'sep='.$this->getDelimiter().$this->lineEnding);
+            fwrite($fileHandle, 'sep=' . $this->getDelimiter() . $this->lineEnding);
         }
 
         //    Identify the range that we need to extract from the worksheet
@@ -141,7 +141,7 @@ 
         // Write rows to file
         for ($row = 1; $row <= $maxRow; ++$row) {
             // Convert the row to an array...
-            $cellsArray = $sheet->rangeToArray('A'.$row.':'.$maxCol.$row, '', $this->preCalculateFormulas);
+            $cellsArray = $sheet->rangeToArray('A' . $row . ':' . $maxCol . $row, '', $this->preCalculateFormulas);
             // ... and write to the file
             $this->writeLine($fileHandle, $cellsArray[0]);
         }
@@ -344,7 +344,7 @@ 
 
             foreach ($pValues as $element) {
                 // Escape enclosures
-                $element = str_replace($this->enclosure, $this->enclosure.$this->enclosure, $element);
+                $element = str_replace($this->enclosure, $this->enclosure . $this->enclosure, $element);
 
                 // Add delimiter
                 if ($writeDelimiter) {
@@ -354,7 +354,7 @@ 
                 }
 
                 // Add enclosed string
-                $line .= $this->enclosure.$element.$this->enclosure;
+                $line .= $this->enclosure . $element . $this->enclosure;
             }
 
             // Add line ending

src/PhpSpreadsheet/Writer/Ods/Content.php

Spacing +1 added lines, -1 removed lines

@@ -212,7 +212,7 @@
                     } catch (Exception $e) {
                         $formula_value = $cell->getValue();
                     }
-                    $objWriter->writeAttribute('table:formula', 'of:'.$cell->getValue());
+                    $objWriter->writeAttribute('table:formula', 'of:' . $cell->getValue());
                     if (is_numeric($formula_value)) {
                         $objWriter->writeAttribute('office:value-type', 'float');
                     } else {

src/PhpSpreadsheet/Writer/Xlsx.php

Spacing +16 added lines, -16 removed lines

@@ -238,7 +238,7 @@ 
             // Try opening the ZIP file
             if ($objZip->open($pFilename, $zipOverWrite) !== true) {
                 if ($objZip->open($pFilename, $zipCreate) !== true) {
-                    throw new \PhpOffice\PhpSpreadsheet\Writer\WriteException('Could not open '.$pFilename.' for writing.');
+                    throw new \PhpOffice\PhpSpreadsheet\Writer\WriteException('Could not open ' . $pFilename . ' for writing.');
                 }
             }
 
@@ -264,13 +264,13 @@ 
                 $tmpRibbonTarget = $this->spreadSheet->getRibbonXMLData('target');
                 $objZip->addFromString($tmpRibbonTarget, $this->spreadSheet->getRibbonXMLData('data'));
                 if ($this->spreadSheet->hasRibbonBinObjects()) {
-                    $tmpRootPath = dirname($tmpRibbonTarget).'/';
+                    $tmpRootPath = dirname($tmpRibbonTarget) . '/';
                     $ribbonBinObjects = $this->spreadSheet->getRibbonBinObjects('data'); //the files to write
                     foreach ($ribbonBinObjects as $aPath => $aContent) {
-                        $objZip->addFromString($tmpRootPath.$aPath, $aContent);
+                        $objZip->addFromString($tmpRootPath . $aPath, $aContent);
                     }
                     //the rels for files
-                    $objZip->addFromString($tmpRootPath.'_rels/'.basename($tmpRibbonTarget).'.rels', $this->getWriterPart('RelsRibbonObjects')->writeRibbonRelationships($this->spreadSheet));
+                    $objZip->addFromString($tmpRootPath . '_rels/' . basename($tmpRibbonTarget) . '.rels', $this->getWriterPart('RelsRibbonObjects')->writeRibbonRelationships($this->spreadSheet));
                 }
             }
 
@@ -301,12 +301,12 @@ 
             $chartCount = 0;
             // Add worksheets
             for ($i = 0; $i < $this->spreadSheet->getSheetCount(); ++$i) {
-                $objZip->addFromString('xl/worksheets/sheet'.($i + 1).'.xml', $this->getWriterPart('Worksheet')->writeWorksheet($this->spreadSheet->getSheet($i), $this->stringTable, $this->includeCharts));
+                $objZip->addFromString('xl/worksheets/sheet' . ($i + 1) . '.xml', $this->getWriterPart('Worksheet')->writeWorksheet($this->spreadSheet->getSheet($i), $this->stringTable, $this->includeCharts));
                 if ($this->includeCharts) {
                     $charts = $this->spreadSheet->getSheet($i)->getChartCollection();
                     if (count($charts) > 0) {
                         foreach ($charts as $chart) {
-                            $objZip->addFromString('xl/charts/chart'.($chartCount + 1).'.xml', $this->getWriterPart('Chart')->writeChart($chart, $this->preCalculateFormulas));
+                            $objZip->addFromString('xl/charts/chart' . ($chartCount + 1) . '.xml', $this->getWriterPart('Chart')->writeChart($chart, $this->preCalculateFormulas));
                             ++$chartCount;
                         }
                     }
@@ -317,7 +317,7 @@ 
             // Add worksheet relationships (drawings, ...)
             for ($i = 0; $i < $this->spreadSheet->getSheetCount(); ++$i) {
                 // Add relationships
-                $objZip->addFromString('xl/worksheets/_rels/sheet'.($i + 1).'.xml.rels', $this->getWriterPart('Rels')->writeWorksheetRelationships($this->spreadSheet->getSheet($i), ($i + 1), $this->includeCharts));
+                $objZip->addFromString('xl/worksheets/_rels/sheet' . ($i + 1) . '.xml.rels', $this->getWriterPart('Rels')->writeWorksheetRelationships($this->spreadSheet->getSheet($i), ($i + 1), $this->includeCharts));
 
                 $drawings = $this->spreadSheet->getSheet($i)->getDrawingCollection();
                 $drawingCount = count($drawings);
@@ -328,32 +328,32 @@ 
                 // Add drawing and image relationship parts
                 if (($drawingCount > 0) || ($chartCount > 0)) {
                     // Drawing relationships
-                    $objZip->addFromString('xl/drawings/_rels/drawing'.($i + 1).'.xml.rels', $this->getWriterPart('Rels')->writeDrawingRelationships($this->spreadSheet->getSheet($i), $chartRef1, $this->includeCharts));
+                    $objZip->addFromString('xl/drawings/_rels/drawing' . ($i + 1) . '.xml.rels', $this->getWriterPart('Rels')->writeDrawingRelationships($this->spreadSheet->getSheet($i), $chartRef1, $this->includeCharts));
 
                     // Drawings
-                    $objZip->addFromString('xl/drawings/drawing'.($i + 1).'.xml', $this->getWriterPart('Drawing')->writeDrawings($this->spreadSheet->getSheet($i), $chartRef2, $this->includeCharts));
+                    $objZip->addFromString('xl/drawings/drawing' . ($i + 1) . '.xml', $this->getWriterPart('Drawing')->writeDrawings($this->spreadSheet->getSheet($i), $chartRef2, $this->includeCharts));
                 }
 
                 // Add comment relationship parts
                 if (count($this->spreadSheet->getSheet($i)->getComments()) > 0) {
                     // VML Comments
-                    $objZip->addFromString('xl/drawings/vmlDrawing'.($i + 1).'.vml', $this->getWriterPart('Comments')->writeVMLComments($this->spreadSheet->getSheet($i)));
+                    $objZip->addFromString('xl/drawings/vmlDrawing' . ($i + 1) . '.vml', $this->getWriterPart('Comments')->writeVMLComments($this->spreadSheet->getSheet($i)));
 
                     // Comments
-                    $objZip->addFromString('xl/comments'.($i + 1).'.xml', $this->getWriterPart('Comments')->writeComments($this->spreadSheet->getSheet($i)));
+                    $objZip->addFromString('xl/comments' . ($i + 1) . '.xml', $this->getWriterPart('Comments')->writeComments($this->spreadSheet->getSheet($i)));
                 }
 
                 // Add header/footer relationship parts
                 if (count($this->spreadSheet->getSheet($i)->getHeaderFooter()->getImages()) > 0) {
                     // VML Drawings
-                    $objZip->addFromString('xl/drawings/vmlDrawingHF'.($i + 1).'.vml', $this->getWriterPart('Drawing')->writeVMLHeaderFooterImages($this->spreadSheet->getSheet($i)));
+                    $objZip->addFromString('xl/drawings/vmlDrawingHF' . ($i + 1) . '.vml', $this->getWriterPart('Drawing')->writeVMLHeaderFooterImages($this->spreadSheet->getSheet($i)));
 
                     // VML Drawing relationships
-                    $objZip->addFromString('xl/drawings/_rels/vmlDrawingHF'.($i + 1).'.vml.rels', $this->getWriterPart('Rels')->writeHeaderFooterDrawingRelationships($this->spreadSheet->getSheet($i)));
+                    $objZip->addFromString('xl/drawings/_rels/vmlDrawingHF' . ($i + 1) . '.vml.rels', $this->getWriterPart('Rels')->writeHeaderFooterDrawingRelationships($this->spreadSheet->getSheet($i)));
 
                     // Media
                     foreach ($this->spreadSheet->getSheet($i)->getHeaderFooter()->getImages() as $image) {
-                        $objZip->addFromString('xl/media/'.$image->getIndexedFilename(), file_get_contents($image->getPath()));
+                        $objZip->addFromString('xl/media/' . $image->getIndexedFilename(), file_get_contents($image->getPath()));
                     }
                 }
             }
@@ -377,7 +377,7 @@ 
                         $imageContents = file_get_contents($imagePath);
                     }
 
-                    $objZip->addFromString('xl/media/'.str_replace(' ', '_', $this->getDrawingHashTable()->getByIndex($i)->getIndexedFilename()), $imageContents);
+                    $objZip->addFromString('xl/media/' . str_replace(' ', '_', $this->getDrawingHashTable()->getByIndex($i)->getIndexedFilename()), $imageContents);
                 } elseif ($this->getDrawingHashTable()->getByIndex($i) instanceof MemoryDrawing) {
                     ob_start();
                     call_user_func(
@@ -387,7 +387,7 @@ 
                     $imageContents = ob_get_contents();
                     ob_end_clean();
 
-                    $objZip->addFromString('xl/media/'.str_replace(' ', '_', $this->getDrawingHashTable()->getByIndex($i)->getIndexedFilename()), $imageContents);
+                    $objZip->addFromString('xl/media/' . str_replace(' ', '_', $this->getDrawingHashTable()->getByIndex($i)->getIndexedFilename()), $imageContents);
                 }
             }
 

src/PhpSpreadsheet/Writer/PDF/TcPDF.php

Spacing +3 added lines, -3 removed lines

@@ -38,7 +38,7 @@ 
         parent::__construct($spreadsheet);
 
         /*  Require tcPDF library */
-        $pdfRendererClassFile = \PhpOffice\PhpSpreadsheet\Settings::getPdfRendererPath().'/tcpdf.php';
+        $pdfRendererClassFile = \PhpOffice\PhpSpreadsheet\Settings::getPdfRendererPath() . '/tcpdf.php';
         if (file_exists($pdfRendererClassFile)) {
             $k_path_url = \PhpOffice\PhpSpreadsheet\Settings::getPdfRendererPath();
             require_once $pdfRendererClassFile;
@@ -104,8 +104,8 @@ 
         //  Set the appropriate font
         $pdf->SetFont($this->getFont());
         $pdf->writeHTML(
-            $this->generateHTMLHeader(false).
-            $this->generateSheetData().
+            $this->generateHTMLHeader(false) .
+            $this->generateSheetData() .
             $this->generateHTMLFooter()
         );
 

src/PhpSpreadsheet/Writer/PDF/MPDF.php

Spacing +3 added lines, -3 removed lines

@@ -38,7 +38,7 @@ 
         parent::__construct($spreadsheet);
 
         /*  Require mPDF library */
-        $pdfRendererClassFile = \PhpOffice\PhpSpreadsheet\Settings::getPdfRendererPath().'/mpdf.php';
+        $pdfRendererClassFile = \PhpOffice\PhpSpreadsheet\Settings::getPdfRendererPath() . '/mpdf.php';
         if (file_exists($pdfRendererClassFile)) {
             require_once $pdfRendererClassFile;
         } else {
@@ -106,8 +106,8 @@ 
         $pdf->SetCreator($this->spreadsheet->getProperties()->getCreator());
 
         $pdf->WriteHTML(
-            $this->generateHTMLHeader(false).
-            $this->generateSheetData().
+            $this->generateHTMLHeader(false) .
+            $this->generateSheetData() .
             $this->generateHTMLFooter()
         );
 

src/PhpSpreadsheet/Writer/PDF/DomPDF.php

Spacing +3 added lines, -3 removed lines

@@ -38,7 +38,7 @@ 
         parent::__construct($spreadsheet);
 
         /*  Require DomPDF library */
-        $pdfRendererClassFile = \PhpOffice\PhpSpreadsheet\Settings::getPdfRendererPath().'/dompdf_config.inc.php';
+        $pdfRendererClassFile = \PhpOffice\PhpSpreadsheet\Settings::getPdfRendererPath() . '/dompdf_config.inc.php';
         if (file_exists($pdfRendererClassFile)) {
             require_once $pdfRendererClassFile;
         } else {
@@ -95,8 +95,8 @@ 
         $pdf->set_paper(strtolower($paperSize), $orientation);
 
         $pdf->load_html(
-            $this->generateHTMLHeader(false).
-            $this->generateSheetData().
+            $this->generateHTMLHeader(false) .
+            $this->generateSheetData() .
             $this->generateHTMLFooter()
         );
         $pdf->render();