PHPOffice / PhpSpreadsheet

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();

src/PhpSpreadsheet/Writer/HTML.php

Spacing +122 added lines, -122 removed lines

@@ -357,46 +357,46 @@ 
 
         // Construct HTML
         $properties = $this->spreadsheet->getProperties();
-        $html = '<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">'.PHP_EOL;
-        $html .= '<!-- Generated by Spreadsheet - https://github.com/PHPOffice/Spreadsheet -->'.PHP_EOL;
-        $html .= '<html>'.PHP_EOL;
-        $html .= '  <head>'.PHP_EOL;
-        $html .= '      <meta http-equiv="Content-Type" content="text/html; charset=utf-8">'.PHP_EOL;
+        $html = '<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">' . PHP_EOL;
+        $html .= '<!-- Generated by Spreadsheet - https://github.com/PHPOffice/Spreadsheet -->' . PHP_EOL;
+        $html .= '<html>' . PHP_EOL;
+        $html .= '  <head>' . PHP_EOL;
+        $html .= '      <meta http-equiv="Content-Type" content="text/html; charset=utf-8">' . PHP_EOL;
         if ($properties->getTitle() > '') {
-            $html .= '      <title>'.htmlspecialchars($properties->getTitle()).'</title>'.PHP_EOL;
+            $html .= '      <title>' . htmlspecialchars($properties->getTitle()) . '</title>' . PHP_EOL;
         }
         if ($properties->getCreator() > '') {
-            $html .= '      <meta name="author" content="'.htmlspecialchars($properties->getCreator()).'" />'.PHP_EOL;
+            $html .= '      <meta name="author" content="' . htmlspecialchars($properties->getCreator()) . '" />' . PHP_EOL;
         }
         if ($properties->getTitle() > '') {
-            $html .= '      <meta name="title" content="'.htmlspecialchars($properties->getTitle()).'" />'.PHP_EOL;
+            $html .= '      <meta name="title" content="' . htmlspecialchars($properties->getTitle()) . '" />' . PHP_EOL;
         }
         if ($properties->getDescription() > '') {
-            $html .= '      <meta name="description" content="'.htmlspecialchars($properties->getDescription()).'" />'.PHP_EOL;
+            $html .= '      <meta name="description" content="' . htmlspecialchars($properties->getDescription()) . '" />' . PHP_EOL;
         }
         if ($properties->getSubject() > '') {
-            $html .= '      <meta name="subject" content="'.htmlspecialchars($properties->getSubject()).'" />'.PHP_EOL;
+            $html .= '      <meta name="subject" content="' . htmlspecialchars($properties->getSubject()) . '" />' . PHP_EOL;
         }
         if ($properties->getKeywords() > '') {
-            $html .= '      <meta name="keywords" content="'.htmlspecialchars($properties->getKeywords()).'" />'.PHP_EOL;
+            $html .= '      <meta name="keywords" content="' . htmlspecialchars($properties->getKeywords()) . '" />' . PHP_EOL;
         }
         if ($properties->getCategory() > '') {
-            $html .= '      <meta name="category" content="'.htmlspecialchars($properties->getCategory()).'" />'.PHP_EOL;
+            $html .= '      <meta name="category" content="' . htmlspecialchars($properties->getCategory()) . '" />' . PHP_EOL;
         }
         if ($properties->getCompany() > '') {
-            $html .= '      <meta name="company" content="'.htmlspecialchars($properties->getCompany()).'" />'.PHP_EOL;
+            $html .= '      <meta name="company" content="' . htmlspecialchars($properties->getCompany()) . '" />' . PHP_EOL;
         }
         if ($properties->getManager() > '') {
-            $html .= '      <meta name="manager" content="'.htmlspecialchars($properties->getManager()).'" />'.PHP_EOL;
+            $html .= '      <meta name="manager" content="' . htmlspecialchars($properties->getManager()) . '" />' . PHP_EOL;
         }
 
         if ($pIncludeStyles) {
             $html .= $this->generateStyles(true);
         }
 
-        $html .= '  </head>'.PHP_EOL;
-        $html .= ''.PHP_EOL;
-        $html .= '  <body>'.PHP_EOL;
+        $html .= '  </head>' . PHP_EOL;
+        $html .= '' . PHP_EOL;
+        $html .= '  <body>' . PHP_EOL;
 
         return $html;
     }
@@ -467,13 +467,13 @@ 
             while ($row++ < $rowMax) {
                 // <thead> ?
                 if ($row == $theadStart) {
-                    $html .= '        <thead>'.PHP_EOL;
+                    $html .= '        <thead>' . PHP_EOL;
                     $cellType = 'th';
                 }
 
                 // <tbody> ?
                 if ($row == $tbodyStart) {
-                    $html .= '        <tbody>'.PHP_EOL;
+                    $html .= '        <tbody>' . PHP_EOL;
                     $cellType = 'td';
                 }
 
@@ -486,7 +486,7 @@ 
                     while ($column++ < $dimension[1][0]) {
                         // Cell exists?
                         if ($sheet->cellExistsByColumnAndRow($column, $row)) {
-                            $rowData[$column] = \PhpOffice\PhpSpreadsheet\Cell::stringFromColumnIndex($column).$row;
+                            $rowData[$column] = \PhpOffice\PhpSpreadsheet\Cell::stringFromColumnIndex($column) . $row;
                         } else {
                             $rowData[$column] = '';
                         }
@@ -496,13 +496,13 @@ 
 
                 // </thead> ?
                 if ($row == $theadEnd) {
-                    $html .= '        </thead>'.PHP_EOL;
+                    $html .= '        </thead>' . PHP_EOL;
                 }
             }
             $html .= $this->extendRowsForChartsAndImages($sheet, $row);
 
             // Close table body.
-            $html .= '        </tbody>'.PHP_EOL;
+            $html .= '        </tbody>' . PHP_EOL;
 
             // Write table footer
             $html .= $this->generateTableFooter();
@@ -551,14 +551,14 @@ 
             // Loop all sheets
             $sheetId = 0;
 
-            $html .= '<ul class="navigation">'.PHP_EOL;
+            $html .= '<ul class="navigation">' . PHP_EOL;
 
             foreach ($sheets as $sheet) {
-                $html .= '  <li class="sheet'.$sheetId.'"><a href="#sheet'.$sheetId.'">'.$sheet->getTitle().'</a></li>'.PHP_EOL;
+                $html .= '  <li class="sheet' . $sheetId . '"><a href="#sheet' . $sheetId . '">' . $sheet->getTitle() . '</a></li>' . PHP_EOL;
                 ++$sheetId;
             }
 
-            $html .= '</ul>'.PHP_EOL;
+            $html .= '</ul>' . PHP_EOL;
         }
 
         return $html;
@@ -602,9 +602,9 @@ 
             $html .= '<tr>';
             for ($col = 'A'; $col != $colMax; ++$col) {
                 $html .= '<td>';
-                $html .= $this->writeImageInCell($pSheet, $col.$row);
+                $html .= $this->writeImageInCell($pSheet, $col . $row);
                 if ($this->includeCharts) {
-                    $html .= $this->writeChartInCell($pSheet, $col.$row);
+                    $html .= $this->writeChartInCell($pSheet, $col . $row);
                 }
                 $html .= '</td>';
             }
@@ -642,7 +642,7 @@ 
                     }
 
                     // Prepend images root
-                    $filename = $this->getImagesRoot().$filename;
+                    $filename = $this->getImagesRoot() . $filename;
 
                     // Strip off eventual '.'
                     if (substr($filename, 0, 1) == '.' && substr($filename, 0, 2) != './') {
@@ -663,17 +663,17 @@ 
                             // base64 encode the binary data, then break it
                             // into chunks according to RFC 2045 semantics
                             $base64 = chunk_split(base64_encode($picture));
-                            $imageData = 'data:'.$imageDetails['mime'].';base64,'.$base64;
+                            $imageData = 'data:' . $imageDetails['mime'] . ';base64,' . $base64;
                         } else {
                             $imageData = $filename;
                         }
                     }
 
                     $html .= '<div style="position: relative;">';
-                    $html .= '<img style="position: absolute; z-index: 1; left: '.
-                        $drawing->getOffsetX().'px; top: '.$drawing->getOffsetY().'px; width: '.
-                        $drawing->getWidth().'px; height: '.$drawing->getHeight().'px;" src="'.
-                        $imageData.'" border="0" />';
+                    $html .= '<img style="position: absolute; z-index: 1; left: ' .
+                        $drawing->getOffsetX() . 'px; top: ' . $drawing->getOffsetY() . 'px; width: ' .
+                        $drawing->getWidth() . 'px; height: ' . $drawing->getHeight() . 'px;" src="' .
+                        $imageData . '" border="0" />';
                     $html .= '</div>';
                 }
             } elseif ($drawing instanceof \PhpOffice\PhpSpreadsheet\Worksheet\MemoryDrawing) {
@@ -685,13 +685,13 @@ 
                 $contents = ob_get_contents(); //  Instead, output above is saved to $contents
                 ob_end_clean(); //  End the output buffer.
 
-                $dataUri = 'data:image/jpeg;base64,'.base64_encode($contents);
+                $dataUri = 'data:image/jpeg;base64,' . base64_encode($contents);
 
                 //  Because of the nature of tables, width is more important than height.
                 //  max-width: 100% ensures that image doesnt overflow containing cell
                 //  width: X sets width of supplied image.
                 //  As a result, images bigger than cell will be contained and images smaller will not get stretched
-                $html .= '<img src="'.$dataUri.'" style="max-width:100%;width:'.$drawing->getWidth().'px;" />';
+                $html .= '<img src="' . $dataUri . '" style="max-width:100%;width:' . $drawing->getWidth() . 'px;" />';
             }
         }
 
@@ -718,7 +718,7 @@ 
             if ($chart instanceof \PhpOffice\PhpSpreadsheet\Chart) {
                 $chartCoordinates = $chart->getTopLeftPosition();
                 if ($chartCoordinates['cell'] == $coordinates) {
-                    $chartFileName = \PhpOffice\PhpSpreadsheet\Shared\File::sysGetTempDir().'/'.uniqid().'.png';
+                    $chartFileName = \PhpOffice\PhpSpreadsheet\Shared\File::sysGetTempDir() . '/' . uniqid() . '.png';
                     if (!$chart->render($chartFileName)) {
                         return;
                     }
@@ -731,10 +731,10 @@ 
                         // base64 encode the binary data, then break it
                         // into chunks according to RFC 2045 semantics
                         $base64 = chunk_split(base64_encode($picture));
-                        $imageData = 'data:'.$imageDetails['mime'].';base64,'.$base64;
+                        $imageData = 'data:' . $imageDetails['mime'] . ';base64,' . $base64;
 
                         $html .= '<div style="position: relative;">';
-                        $html .= '<img style="position: absolute; z-index: 1; left: '.$chartCoordinates['xOffset'].'px; top: '.$chartCoordinates['yOffset'].'px; width: '.$imageDetails[0].'px; height: '.$imageDetails[1].'px;" src="'.$imageData.'" border="0" />'.PHP_EOL;
+                        $html .= '<img style="position: absolute; z-index: 1; left: ' . $chartCoordinates['xOffset'] . 'px; top: ' . $chartCoordinates['yOffset'] . 'px; width: ' . $imageDetails[0] . 'px; height: ' . $imageDetails[1] . 'px;" src="' . $imageData . '" border="0" />' . PHP_EOL;
                         $html .= '</div>';
 
                         unlink($chartFileName);
@@ -771,20 +771,20 @@ 
 
         // Start styles
         if ($generateSurroundingHTML) {
-            $html .= '    <style type="text/css">'.PHP_EOL;
-            $html .= '      html { '.$this->assembleCSS($css['html']).' }'.PHP_EOL;
+            $html .= '    <style type="text/css">' . PHP_EOL;
+            $html .= '      html { ' . $this->assembleCSS($css['html']) . ' }' . PHP_EOL;
         }
 
         // Write all other styles
         foreach ($css as $styleName => $styleDefinition) {
             if ($styleName != 'html') {
-                $html .= '      '.$styleName.' { '.$this->assembleCSS($styleDefinition).' }'.PHP_EOL;
+                $html .= '      ' . $styleName . ' { ' . $this->assembleCSS($styleDefinition) . ' }' . PHP_EOL;
             }
         }
 
         // End styles
         if ($generateSurroundingHTML) {
-            $html .= '    </style>'.PHP_EOL;
+            $html .= '    </style>' . PHP_EOL;
         }
 
         // Return
@@ -858,8 +858,8 @@ 
 
         // Calculate cell style hashes
         foreach ($this->spreadsheet->getCellXfCollection() as $index => $style) {
-            $css['td.style'.$index] = $this->createCSSStyle($style);
-            $css['th.style'.$index] = $this->createCSSStyle($style);
+            $css['td.style' . $index] = $this->createCSSStyle($style);
+            $css['th.style' . $index] = $this->createCSSStyle($style);
         }
 
         // Fetch sheets
@@ -884,7 +884,7 @@ 
             $column = -1;
             while ($column++ < $highestColumnIndex) {
                 $this->columnWidths[$sheetIndex][$column] = 42; // approximation
-                $css['table.sheet'.$sheetIndex.' col.col'.$column]['width'] = '42pt';
+                $css['table.sheet' . $sheetIndex . ' col.col' . $column]['width'] = '42pt';
             }
 
             // col elements, loop through columnDimensions and set width
@@ -893,11 +893,11 @@ 
                     $width = \PhpOffice\PhpSpreadsheet\Shared\Drawing::pixelsToPoints($width);
                     $column = \PhpOffice\PhpSpreadsheet\Cell::columnIndexFromString($columnDimension->getColumnIndex()) - 1;
                     $this->columnWidths[$sheetIndex][$column] = $width;
-                    $css['table.sheet'.$sheetIndex.' col.col'.$column]['width'] = $width.'pt';
+                    $css['table.sheet' . $sheetIndex . ' col.col' . $column]['width'] = $width . 'pt';
 
                     if ($columnDimension->getVisible() === false) {
-                        $css['table.sheet'.$sheetIndex.' col.col'.$column]['visibility'] = 'collapse';
-                        $css['table.sheet'.$sheetIndex.' col.col'.$column]['*display'] = 'none'; // target IE6+7
+                        $css['table.sheet' . $sheetIndex . ' col.col' . $column]['visibility'] = 'collapse';
+                        $css['table.sheet' . $sheetIndex . ' col.col' . $column]['*display'] = 'none'; // target IE6+7
                     }
                 }
             }
@@ -906,17 +906,17 @@ 
             $rowDimension = $sheet->getDefaultRowDimension();
 
             // table.sheetN tr { }
-            $css['table.sheet'.$sheetIndex.' tr'] = [];
+            $css['table.sheet' . $sheetIndex . ' tr'] = [];
 
             if ($rowDimension->getRowHeight() == -1) {
                 $pt_height = Font::getDefaultRowHeightByFont($this->spreadsheet->getDefaultStyle()->getFont());
             } else {
                 $pt_height = $rowDimension->getRowHeight();
             }
-            $css['table.sheet'.$sheetIndex.' tr']['height'] = $pt_height.'pt';
+            $css['table.sheet' . $sheetIndex . ' tr']['height'] = $pt_height . 'pt';
             if ($rowDimension->getVisible() === false) {
-                $css['table.sheet'.$sheetIndex.' tr']['display'] = 'none';
-                $css['table.sheet'.$sheetIndex.' tr']['visibility'] = 'hidden';
+                $css['table.sheet' . $sheetIndex . ' tr']['display'] = 'none';
+                $css['table.sheet' . $sheetIndex . ' tr']['visibility'] = 'hidden';
             }
 
             // Calculate row heights
@@ -924,17 +924,17 @@ 
                 $row = $rowDimension->getRowIndex() - 1;
 
                 // table.sheetN tr.rowYYYYYY { }
-                $css['table.sheet'.$sheetIndex.' tr.row'.$row] = [];
+                $css['table.sheet' . $sheetIndex . ' tr.row' . $row] = [];
 
                 if ($rowDimension->getRowHeight() == -1) {
                     $pt_height = Font::getDefaultRowHeightByFont($this->spreadsheet->getDefaultStyle()->getFont());
                 } else {
                     $pt_height = $rowDimension->getRowHeight();
                 }
-                $css['table.sheet'.$sheetIndex.' tr.row'.$row]['height'] = $pt_height.'pt';
+                $css['table.sheet' . $sheetIndex . ' tr.row' . $row]['height'] = $pt_height . 'pt';
                 if ($rowDimension->getVisible() === false) {
-                    $css['table.sheet'.$sheetIndex.' tr.row'.$row]['display'] = 'none';
-                    $css['table.sheet'.$sheetIndex.' tr.row'.$row]['visibility'] = 'hidden';
+                    $css['table.sheet' . $sheetIndex . ' tr.row' . $row]['display'] = 'none';
+                    $css['table.sheet' . $sheetIndex . ' tr.row' . $row]['visibility'] = 'hidden';
                 }
             }
         }
@@ -989,7 +989,7 @@ 
         if ($textAlign = $this->mapHAlign($pStyle->getHorizontal())) {
             $css['text-align'] = $textAlign;
             if (in_array($textAlign, ['left', 'right'])) {
-                $css['padding-'.$textAlign] = (string) ((int) $pStyle->getIndent() * 9).'px';
+                $css['padding-' . $textAlign] = (string) ((int) $pStyle->getIndent() * 9) . 'px';
             }
         }
 
@@ -1023,9 +1023,9 @@ 
             $css['font-style'] = 'italic';
         }
 
-        $css['color'] = '#'.$pStyle->getColor()->getRGB();
-        $css['font-family'] = '\''.$pStyle->getName().'\'';
-        $css['font-size'] = $pStyle->getSize().'pt';
+        $css['color'] = '#' . $pStyle->getColor()->getRGB();
+        $css['font-family'] = '\'' . $pStyle->getName() . '\'';
+        $css['font-size'] = $pStyle->getSize() . 'pt';
 
         return $css;
     }
@@ -1062,7 +1062,7 @@ 
     {
         //    Create CSS - add !important to non-none border styles for merged cells
         $borderStyle = $this->mapBorderStyle($pStyle->getBorderStyle());
-        $css = $borderStyle.' #'.$pStyle->getColor()->getRGB().(($borderStyle == 'none') ? '' : ' !important');
+        $css = $borderStyle . ' #' . $pStyle->getColor()->getRGB() . (($borderStyle == 'none') ? '' : ' !important');
 
         return $css;
     }
@@ -1081,7 +1081,7 @@ 
 
         // Create CSS
         $value = $pStyle->getFillType() == \PhpOffice\PhpSpreadsheet\Style\Fill::FILL_NONE ?
-            'white' : '#'.$pStyle->getStartColor()->getRGB();
+            'white' : '#' . $pStyle->getStartColor()->getRGB();
         $css['background-color'] = $value;
 
         return $css;
@@ -1094,8 +1094,8 @@ 
     {
         // Construct HTML
         $html = '';
-        $html .= '  </body>'.PHP_EOL;
-        $html .= '</html>'.PHP_EOL;
+        $html .= '  </body>' . PHP_EOL;
+        $html .= '</html>' . PHP_EOL;
 
         return $html;
     }
@@ -1119,15 +1119,15 @@ 
 
         if (!$this->useInlineCss) {
             $gridlines = $pSheet->getShowGridlines() ? ' gridlines' : '';
-            $html .= '    <table border="0" cellpadding="0" cellspacing="0" id="sheet'.$sheetIndex.'" class="sheet'.$sheetIndex.$gridlines.'">'.PHP_EOL;
+            $html .= '    <table border="0" cellpadding="0" cellspacing="0" id="sheet' . $sheetIndex . '" class="sheet' . $sheetIndex . $gridlines . '">' . PHP_EOL;
         } else {
             $style = isset($this->cssStyles['table']) ?
                 $this->assembleCSS($this->cssStyles['table']) : '';
 
             if ($this->isPdf && $pSheet->getShowGridlines()) {
-                $html .= '    <table border="1" cellpadding="1" id="sheet'.$sheetIndex.'" cellspacing="1" style="'.$style.'">'.PHP_EOL;
+                $html .= '    <table border="1" cellpadding="1" id="sheet' . $sheetIndex . '" cellspacing="1" style="' . $style . '">' . PHP_EOL;
             } else {
-                $html .= '    <table border="0" cellpadding="1" id="sheet'.$sheetIndex.'" cellspacing="0" style="'.$style.'">'.PHP_EOL;
+                $html .= '    <table border="0" cellpadding="1" id="sheet' . $sheetIndex . '" cellspacing="0" style="' . $style . '">' . PHP_EOL;
             }
         }
 
@@ -1137,11 +1137,11 @@ 
         while ($i++ < $highestColumnIndex) {
             if (!$this->isPdf) {
                 if (!$this->useInlineCss) {
-                    $html .= '        <col class="col'.$i.'">'.PHP_EOL;
+                    $html .= '        <col class="col' . $i . '">' . PHP_EOL;
                 } else {
-                    $style = isset($this->cssStyles['table.sheet'.$sheetIndex.' col.col'.$i]) ?
-                        $this->assembleCSS($this->cssStyles['table.sheet'.$sheetIndex.' col.col'.$i]) : '';
-                    $html .= '        <col style="'.$style.'">'.PHP_EOL;
+                    $style = isset($this->cssStyles['table.sheet' . $sheetIndex . ' col.col' . $i]) ?
+                        $this->assembleCSS($this->cssStyles['table.sheet' . $sheetIndex . ' col.col' . $i]) : '';
+                    $html .= '        <col style="' . $style . '">' . PHP_EOL;
                 }
             }
         }
@@ -1156,7 +1156,7 @@ 
      */
     private function generateTableFooter()
     {
-        $html = '    </table>'.PHP_EOL;
+        $html = '    </table>' . PHP_EOL;
 
         return $html;
     }
@@ -1186,7 +1186,7 @@ 
                 $breaks = $pSheet->getBreaks();
 
                 // check if a break is needed before this row
-                if (isset($breaks['A'.$pRow])) {
+                if (isset($breaks['A' . $pRow])) {
                     // close table: </table>
                     $html .= $this->generateTableFooter();
 
@@ -1200,31 +1200,31 @@ 
 
             // Write row start
             if (!$this->useInlineCss) {
-                $html .= '          <tr class="row'.$pRow.'">'.PHP_EOL;
+                $html .= '          <tr class="row' . $pRow . '">' . PHP_EOL;
             } else {
-                $style = isset($this->cssStyles['table.sheet'.$sheetIndex.' tr.row'.$pRow])
-                    ? $this->assembleCSS($this->cssStyles['table.sheet'.$sheetIndex.' tr.row'.$pRow]) : '';
+                $style = isset($this->cssStyles['table.sheet' . $sheetIndex . ' tr.row' . $pRow])
+                    ? $this->assembleCSS($this->cssStyles['table.sheet' . $sheetIndex . ' tr.row' . $pRow]) : '';
 
-                $html .= '          <tr style="'.$style.'">'.PHP_EOL;
+                $html .= '          <tr style="' . $style . '">' . PHP_EOL;
             }
 
             // Write cells
             $colNum = 0;
             foreach ($pValues as $cellAddress) {
                 $cell = ($cellAddress > '') ? $pSheet->getCell($cellAddress) : '';
-                $coordinate = \PhpOffice\PhpSpreadsheet\Cell::stringFromColumnIndex($colNum).($pRow + 1);
+                $coordinate = \PhpOffice\PhpSpreadsheet\Cell::stringFromColumnIndex($colNum) . ($pRow + 1);
                 if (!$this->useInlineCss) {
                     $cssClass = '';
-                    $cssClass = 'column'.$colNum;
+                    $cssClass = 'column' . $colNum;
                 } else {
                     $cssClass = [];
                     if ($cellType == 'th') {
-                        if (isset($this->cssStyles['table.sheet'.$sheetIndex.' th.column'.$colNum])) {
-                            $this->cssStyles['table.sheet'.$sheetIndex.' th.column'.$colNum];
+                        if (isset($this->cssStyles['table.sheet' . $sheetIndex . ' th.column' . $colNum])) {
+                            $this->cssStyles['table.sheet' . $sheetIndex . ' th.column' . $colNum];
                         }
                     } else {
-                        if (isset($this->cssStyles['table.sheet'.$sheetIndex.' td.column'.$colNum])) {
-                            $this->cssStyles['table.sheet'.$sheetIndex.' td.column'.$colNum];
+                        if (isset($this->cssStyles['table.sheet' . $sheetIndex . ' td.column' . $colNum])) {
+                            $this->cssStyles['table.sheet' . $sheetIndex . ' td.column' . $colNum];
                         }
                     }
                 }
@@ -1247,7 +1247,7 @@ 
                         foreach ($elements as $element) {
                             // Rich text start?
                             if ($element instanceof \PhpOffice\PhpSpreadsheet\RichText\Run) {
-                                $cellData .= '<span style="'.$this->assembleCSS($this->createCSSStyleFont($element->getFont())).'">';
+                                $cellData .= '<span style="' . $this->assembleCSS($this->createCSSStyleFont($element->getFont())) . '">';
 
                                 if ($element->getFont()->getSuperScript()) {
                                     $cellData .= '<sup>';
@@ -1286,9 +1286,9 @@ 
                         }
                         $cellData = htmlspecialchars($cellData);
                         if ($pSheet->getParent()->getCellXfByIndex($cell->getXfIndex())->getFont()->getSuperScript()) {
-                            $cellData = '<sup>'.$cellData.'</sup>';
+                            $cellData = '<sup>' . $cellData . '</sup>';
                         } elseif ($pSheet->getParent()->getCellXfByIndex($cell->getXfIndex())->getFont()->getSubScript()) {
-                            $cellData = '<sub>'.$cellData.'</sub>';
+                            $cellData = '<sub>' . $cellData . '</sub>';
                         }
                     }
 
@@ -1301,31 +1301,31 @@ 
 
                     // Extend CSS class?
                     if (!$this->useInlineCss) {
-                        $cssClass .= ' style'.$cell->getXfIndex();
-                        $cssClass .= ' '.$cell->getDataType();
+                        $cssClass .= ' style' . $cell->getXfIndex();
+                        $cssClass .= ' ' . $cell->getDataType();
                     } else {
                         if ($cellType == 'th') {
-                            if (isset($this->cssStyles['th.style'.$cell->getXfIndex()])) {
-                                $cssClass = array_merge($cssClass, $this->cssStyles['th.style'.$cell->getXfIndex()]);
+                            if (isset($this->cssStyles['th.style' . $cell->getXfIndex()])) {
+                                $cssClass = array_merge($cssClass, $this->cssStyles['th.style' . $cell->getXfIndex()]);
                             }
                         } else {
-                            if (isset($this->cssStyles['td.style'.$cell->getXfIndex()])) {
-                                $cssClass = array_merge($cssClass, $this->cssStyles['td.style'.$cell->getXfIndex()]);
+                            if (isset($this->cssStyles['td.style' . $cell->getXfIndex()])) {
+                                $cssClass = array_merge($cssClass, $this->cssStyles['td.style' . $cell->getXfIndex()]);
                             }
                         }
 
                         // General horizontal alignment: Actual horizontal alignment depends on dataType
                         $sharedStyle = $pSheet->getParent()->getCellXfByIndex($cell->getXfIndex());
                         if ($sharedStyle->getAlignment()->getHorizontal() == \PhpOffice\PhpSpreadsheet\Style\Alignment::HORIZONTAL_GENERAL
-                            && isset($this->cssStyles['.'.$cell->getDataType()]['text-align'])) {
-                            $cssClass['text-align'] = $this->cssStyles['.'.$cell->getDataType()]['text-align'];
+                            && isset($this->cssStyles['.' . $cell->getDataType()]['text-align'])) {
+                            $cssClass['text-align'] = $this->cssStyles['.' . $cell->getDataType()]['text-align'];
                         }
                     }
                 }
 
                 // Hyperlink?
                 if ($pSheet->hyperlinkExists($coordinate) && !$pSheet->getHyperlink($coordinate)->isInternal()) {
-                    $cellData = '<a href="'.htmlspecialchars($pSheet->getHyperlink($coordinate)->getUrl()).'" title="'.htmlspecialchars($pSheet->getHyperlink($coordinate)->getTooltip()).'">'.$cellData.'</a>';
+                    $cellData = '<a href="' . htmlspecialchars($pSheet->getHyperlink($coordinate)->getUrl()) . '" title="' . htmlspecialchars($pSheet->getHyperlink($coordinate)->getTooltip()) . '">' . $cellData . '</a>';
                 }
 
                 // Should the cell be written or is it swallowed by a rowspan or colspan?
@@ -1342,18 +1342,18 @@ 
 
                     //    Also apply style from last cell in merge to fix borders -
                     //        relies on !important for non-none border declarations in createCSSStyleBorder
-                    $endCellCoord = \PhpOffice\PhpSpreadsheet\Cell::stringFromColumnIndex($colNum + $colSpan - 1).($pRow + $rowSpan);
+                    $endCellCoord = \PhpOffice\PhpSpreadsheet\Cell::stringFromColumnIndex($colNum + $colSpan - 1) . ($pRow + $rowSpan);
                     if (!$this->useInlineCss) {
-                        $cssClass .= ' style'.$pSheet->getCell($endCellCoord)->getXfIndex();
+                        $cssClass .= ' style' . $pSheet->getCell($endCellCoord)->getXfIndex();
                     }
                 }
 
                 // Write
                 if ($writeCell) {
                     // Column start
-                    $html .= '            <'.$cellType;
+                    $html .= '            <' . $cellType;
                     if (!$this->useInlineCss) {
-                        $html .= ' class="'.$cssClass.'"';
+                        $html .= ' class="' . $cssClass . '"';
                     } else {
                         //** Necessary redundant code for the sake of \PhpOffice\PhpSpreadsheet\Writer\PDF **
                         // We must explicitly write the width of the <td> element because TCPDF
@@ -1366,23 +1366,23 @@ 
                                 $width += $this->columnWidths[$sheetIndex][$i];
                             }
                         }
-                        $cssClass['width'] = $width.'pt';
+                        $cssClass['width'] = $width . 'pt';
 
                         // We must also explicitly write the height of the <td> element because TCPDF
                         // does not recognize e.g. <tr style="height:50pt">
-                        if (isset($this->cssStyles['table.sheet'.$sheetIndex.' tr.row'.$pRow]['height'])) {
-                            $height = $this->cssStyles['table.sheet'.$sheetIndex.' tr.row'.$pRow]['height'];
+                        if (isset($this->cssStyles['table.sheet' . $sheetIndex . ' tr.row' . $pRow]['height'])) {
+                            $height = $this->cssStyles['table.sheet' . $sheetIndex . ' tr.row' . $pRow]['height'];
                             $cssClass['height'] = $height;
                         }
                         //** end of redundant code **
 
-                        $html .= ' style="'.$this->assembleCSS($cssClass).'"';
+                        $html .= ' style="' . $this->assembleCSS($cssClass) . '"';
                     }
                     if ($colSpan > 1) {
-                        $html .= ' colspan="'.$colSpan.'"';
+                        $html .= ' colspan="' . $colSpan . '"';
                     }
                     if ($rowSpan > 1) {
-                        $html .= ' rowspan="'.$rowSpan.'"';
+                        $html .= ' rowspan="' . $rowSpan . '"';
                     }
                     $html .= '>';
 
@@ -1398,7 +1398,7 @@ 
                     $html .= $cellData;
 
                     // Column end
-                    $html .= '</'.$cellType.'>'.PHP_EOL;
+                    $html .= '</' . $cellType . '>' . PHP_EOL;
                 }
 
                 // Next column
@@ -1406,7 +1406,7 @@ 
             }
 
             // Write row end
-            $html .= '          </tr>'.PHP_EOL;
+            $html .= '          </tr>' . PHP_EOL;
 
             // Return
             return $html;
@@ -1426,7 +1426,7 @@ 
     {
         $pairs = [];
         foreach ($pValue as $property => $value) {
-            $pairs[] = $property.':'.$value;
+            $pairs[] = $property . ':' . $value;
         }
         $string = implode('; ', $pairs);
 
@@ -1531,7 +1531,7 @@ 
 
         // color span tag
         if ($color !== null) {
-            $value = '<span style="color:'.$color.'">'.$value.'</span>';
+            $value = '<span style="color:' . $color . '">' . $value . '</span>';
         }
 
         return $value;
@@ -1632,22 +1632,22 @@ 
         $htmlPage = '@page { ';
         $htmlBody = 'body { ';
 
-        $left = StringHelper::formatNumber($pSheet->getPageMargins()->getLeft()).'in; ';
-        $htmlPage .= 'margin-left: '.$left;
-        $htmlBody .= 'margin-left: '.$left;
-        $right = StringHelper::formatNumber($pSheet->getPageMargins()->getRight()).'in; ';
-        $htmlPage .= 'margin-right: '.$right;
-        $htmlBody .= 'margin-right: '.$right;
-        $top = StringHelper::formatNumber($pSheet->getPageMargins()->getTop()).'in; ';
-        $htmlPage .= 'margin-top: '.$top;
-        $htmlBody .= 'margin-top: '.$top;
-        $bottom = StringHelper::formatNumber($pSheet->getPageMargins()->getBottom()).'in; ';
-        $htmlPage .= 'margin-bottom: '.$bottom;
-        $htmlBody .= 'margin-bottom: '.$bottom;
+        $left = StringHelper::formatNumber($pSheet->getPageMargins()->getLeft()) . 'in; ';
+        $htmlPage .= 'margin-left: ' . $left;
+        $htmlBody .= 'margin-left: ' . $left;
+        $right = StringHelper::formatNumber($pSheet->getPageMargins()->getRight()) . 'in; ';
+        $htmlPage .= 'margin-right: ' . $right;
+        $htmlBody .= 'margin-right: ' . $right;
+        $top = StringHelper::formatNumber($pSheet->getPageMargins()->getTop()) . 'in; ';
+        $htmlPage .= 'margin-top: ' . $top;
+        $htmlBody .= 'margin-top: ' . $top;
+        $bottom = StringHelper::formatNumber($pSheet->getPageMargins()->getBottom()) . 'in; ';
+        $htmlPage .= 'margin-bottom: ' . $bottom;
+        $htmlBody .= 'margin-bottom: ' . $bottom;
 
         $htmlPage .= "}\n";
         $htmlBody .= "}\n";
 
-        return "<style>\n".$htmlPage.$htmlBody."</style>\n";
+        return "<style>\n" . $htmlPage . $htmlBody . "</style>\n";
     }
 }

src/PhpSpreadsheet/Writer/Xls/Workbook.php

Spacing +24 added lines, -24 removed lines

@@ -657,7 +657,7 @@ 
                 // Create absolute coordinate
                 $range = \PhpOffice\PhpSpreadsheet\Cell::splitRange($namedRange->getRange());
                 for ($i = 0; $i < count($range); ++$i) {
-                    $range[$i][0] = '\''.str_replace("'", "''", $namedRange->getWorksheet()->getTitle()).'\'!'.\PhpOffice\PhpSpreadsheet\Cell::absoluteCoordinate($range[$i][0]);
+                    $range[$i][0] = '\'' . str_replace("'", "''", $namedRange->getWorksheet()->getTitle()) . '\'!' . \PhpOffice\PhpSpreadsheet\Cell::absoluteCoordinate($range[$i][0]);
                     if (isset($range[$i][1])) {
                         $range[$i][1] = \PhpOffice\PhpSpreadsheet\Cell::absoluteCoordinate($range[$i][1]);
                     }
@@ -671,7 +671,7 @@ 
 
                     // make sure tRef3d is of type tRef3dR (0x3A)
                     if (isset($formulaData{0}) and ($formulaData{0} == "\x7A" or $formulaData{0} == "\x5A")) {
-                        $formulaData = "\x3A".substr($formulaData, 1);
+                        $formulaData = "\x3A" . substr($formulaData, 1);
                     }
 
                     if ($namedRange->getLocalOnly()) {
@@ -819,12 +819,12 @@ 
 
         // combine the parts
         $data = pack('vCCvvvCCCC', $options, 0, $nlen, $sz, 0, $sheetIndex, 0, 0, 0, 0)
-            .$name.$formulaData;
+            .$name . $formulaData;
         $length = strlen($data);
 
         $header = pack('vv', $record, $length);
 
-        return $header.$data;
+        return $header . $data;
     }
 
     /**
@@ -859,12 +859,12 @@ 
 
         // combine the parts
         $data = pack('vCCvvvCCCCC', $options, 0, 1, $sz, 0, $sheetIndex, 0, 0, 0, 0, 0)
-            .$name.$extra;
+            .$name . $extra;
         $length = strlen($data);
 
         $header = pack('vv', $record, $length);
 
-        return $header.$data;
+        return $header . $data;
     }
 
     /**
@@ -879,7 +879,7 @@ 
         $header = pack('vv', $record, $length);
         $data = pack('v', $cv);
 
-        $this->append($header.$data);
+        $this->append($header . $data);
     }
 
     /**
@@ -908,7 +908,7 @@ 
 
         $header = pack('vv', $record, $length);
         $data = pack('vvvvvvvvv', $xWn, $yWn, $dxWn, $dyWn, $grbit, $itabCur, $itabFirst, $ctabsel, $wTabRatio);
-        $this->append($header.$data);
+        $this->append($header . $data);
     }
 
     /**
@@ -948,7 +948,7 @@ 
 
         $length = strlen($data);
         $header = pack('vv', $record, $length);
-        $this->append($header.$data);
+        $this->append($header . $data);
     }
 
     /**
@@ -962,7 +962,7 @@ 
         $header = pack('vv', $record, $length);
         $data = pack('vv', $this->spreadsheet->getSheetCount(), 0x0401);
 
-        return $this->writeData($header.$data);
+        return $this->writeData($header . $data);
     }
 
     /**
@@ -982,7 +982,7 @@ 
             $data .= $this->parser->references[$i];
         }
 
-        return $this->writeData($header.$data);
+        return $this->writeData($header . $data);
     }
 
     /**
@@ -999,7 +999,7 @@ 
 
         $header = pack('vv', $record, $length);
         $data = pack('vCC', $ixfe, $BuiltIn, $iLevel);
-        $this->append($header.$data);
+        $this->append($header . $data);
     }
 
     /**
@@ -1016,8 +1016,8 @@ 
         $length = 2 + strlen($numberFormatString); // Number of bytes to follow
 
         $header = pack('vv', $record, $length);
-        $data = pack('v', $ifmt).$numberFormatString;
-        $this->append($header.$data);
+        $data = pack('v', $ifmt) . $numberFormatString;
+        $this->append($header . $data);
     }
 
     /**
@@ -1034,7 +1034,7 @@ 
 
         $header = pack('vv', $record, $length);
         $data = pack('v', $f1904);
-        $this->append($header.$data);
+        $this->append($header . $data);
     }
 
     /**
@@ -1056,7 +1056,7 @@ 
 
         $header = pack('vv', $record, $length);
         $data = pack('v', $cxals);
-        $this->append($header.$data);
+        $this->append($header . $data);
     }
 
     /**
@@ -1078,7 +1078,7 @@ 
 
         $header = pack('vv', $record, $length);
         $data = pack('CC', $cch, $rgch);
-        $this->append($header.$data.$sheetname);
+        $this->append($header . $data . $sheetname);
     }
 
     /**
@@ -1140,7 +1140,7 @@ 
         $data .= pack('v', $rowmax);
         $data .= pack('C', $colmin);
         $data .= pack('C', $colmax);
-        $this->append($header.$data);
+        $this->append($header . $data);
     }
 
     /**
@@ -1223,7 +1223,7 @@ 
         $data .= pack('C', 0xff);
         // End of data
         $data .= pack('C', 0x10);
-        $this->append($header.$data);
+        $this->append($header . $data);
     }
 
     /**
@@ -1240,7 +1240,7 @@ 
         /* using the same country code always for simplicity */
         $data = pack('vv', $this->countryCode, $this->countryCode);
 
-        return $this->writeData($header.$data);
+        return $this->writeData($header . $data);
     }
 
     /**
@@ -1258,7 +1258,7 @@ 
         // by inspection of real Excel files, MS Office Excel 2007 writes this
         $data = pack('VV', 0x000001C1, 0x00001E667);
 
-        return $this->writeData($header.$data);
+        return $this->writeData($header . $data);
     }
 
     /**
@@ -1281,7 +1281,7 @@ 
         }
 
         $header = pack('vvv', $record, $length, $ccv);
-        $this->append($header.$data);
+        $this->append($header . $data);
     }
 
     /**
@@ -1401,7 +1401,7 @@ 
             $record = ($i == 0) ? 0x00FC : 0x003C;
 
             $header = pack('vv', $record, strlen($recordData));
-            $data = $header.$recordData;
+            $data = $header . $recordData;
 
             $chunk .= $this->writeData($data);
         }
@@ -1423,7 +1423,7 @@ 
             $length = strlen($data);
             $header = pack('vv', $record, $length);
 
-            return $this->writeData($header.$data);
+            return $this->writeData($header . $data);
         } else {
             return '';
         }