viliy / xlsx-writer

src/Writer/Sheet.php

Spacing +41 added lines, -41 removed lines

@@ -64,35 +64,35 @@ 
         $file = $this->getFileWriter();
 
         if (!is_scalar($value) || '' === $value) { //objects, array, empty
-            $file->write('<c r="'.$cellName.'" s="'.$cellStyleIdx.'"/>');
+            $file->write('<c r="' . $cellName . '" s="' . $cellStyleIdx . '"/>');
         } elseif (is_string($value) && '=' == $value[0]) {
             // Support Formula
             if ('n_function' === $numFormatType) {
-                $file->write('<c r="'.$cellName.'" s="'.$cellStyleIdx.'" t="s"><f>'.
+                $file->write('<c r="' . $cellName . '" s="' . $cellStyleIdx . '" t="s"><f>' .
                     str_replace('{n}', $rowNumber + 1, substr(Support::xmlSpecialChars($value), 1))
                     .'</f></c>');
             } else {
-                $file->write('<c r="'.$cellName.'" s="'.$cellStyleIdx.'" t="s"><f>'.Support::xmlSpecialChars($value).'</f></c>');
+                $file->write('<c r="' . $cellName . '" s="' . $cellStyleIdx . '" t="s"><f>' . Support::xmlSpecialChars($value) . '</f></c>');
             }
         } else {
             switch ($numFormatType) {
                 case 'n_date':
-                    $file->write('<c r="'.$cellName.'" s="'.$cellStyleIdx.'" t="n"><v>'.
-                        intval(Support::convertDateTime($value)).'</v></c>');
+                    $file->write('<c r="' . $cellName . '" s="' . $cellStyleIdx . '" t="n"><v>' .
+                        intval(Support::convertDateTime($value)) . '</v></c>');
 
                     break;
                 case 'n_datetime':
-                    $file->write('<c r="'.$cellName.'" s="'.$cellStyleIdx.'" t="n"><v>'.
-                        Support::convertDateTime($value).'</v></c>');
+                    $file->write('<c r="' . $cellName . '" s="' . $cellStyleIdx . '" t="n"><v>' .
+                        Support::convertDateTime($value) . '</v></c>');
 
                     break;
                 case 'n_numeric':
-                    $file->write('<c r="'.$cellName.'" s="'.$cellStyleIdx.'" t="n"><v>'.
-                        Support::xmlSpecialChars($value).'</v></c>'); //int,float,currency
+                    $file->write('<c r="' . $cellName . '" s="' . $cellStyleIdx . '" t="n"><v>' .
+                        Support::xmlSpecialChars($value) . '</v></c>'); //int,float,currency
                     break;
                 case 'n_string':
-                    $file->write('<c r="'.$cellName.'" s="'.$cellStyleIdx.'" t="inlineStr"><is><t>'.
-                        Support::xmlSpecialChars($value).'</t></is></c>');
+                    $file->write('<c r="' . $cellName . '" s="' . $cellStyleIdx . '" t="inlineStr"><is><t>' .
+                        Support::xmlSpecialChars($value) . '</t></is></c>');
 
                     break;
                 case 'n_auto':
@@ -100,13 +100,13 @@ 
                     if (!is_string($value) || '0' == $value || ('0' != $value[0] && ctype_digit($value)) || preg_match("/^\-?(0|[1-9][0-9]*)(\.[0-9]+)?$/", $value)
                     ) { //int,float,currency
                         $file->write(
-                            '<c r="'.$cellName.'" s="'.$cellStyleIdx.'" t="n"><v>'.
-                            Support::xmlSpecialChars($value).'</v></c>'
+                            '<c r="' . $cellName . '" s="' . $cellStyleIdx . '" t="n"><v>' .
+                            Support::xmlSpecialChars($value) . '</v></c>'
                         );
                     } else { //implied: ($cell_format=='string')
                         $file->write(
-                            '<c r="'.$cellName.'" s="'.$cellStyleIdx.'" t="inlineStr"><is><t>'.
-                            Support::xmlSpecialChars($value).'</t></is></c>'
+                            '<c r="' . $cellName . '" s="' . $cellStyleIdx . '" t="inlineStr"><is><t>' .
+                            Support::xmlSpecialChars($value) . '</t></is></c>'
                         );
                     }
 
@@ -124,14 +124,14 @@ 
         $writer = $this->getFileWriter();
         $tabSelected = $isTabSelected ? 'true' : 'false';
         $maxCell = Support::xlsCell(Builder::EXCEL_2007_MAX_ROW, Builder::EXCEL_2007_MAX_COL); //XFE1048577
-        $writer->write('<?xml version="1.0" encoding="UTF-8" standalone="yes"?>'."\n");
+        $writer->write('<?xml version="1.0" encoding="UTF-8" standalone="yes"?>' . "\n");
         $writer->write(
             <<<'EOF'
 <worksheet xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main" xmlns:r="http://schemas.openxmlformats.org/officeDocument/2006/relationships"><sheetPr filterMode="false"><pageSetUpPr fitToPage="false"/></sheetPr>
 EOF
         );
         $this->maxCellTagStart = $this->fileWriter->ftell();
-        $writer->write('<dimension ref="A1:'.$maxCell.'"/>');
+        $writer->write('<dimension ref="A1:' . $maxCell . '"/>');
         $this->maxCellTagEnd = $this->fileWriter->ftell();
         $writer->write('<sheetViews>');
         $writer->write(
@@ -153,15 +153,15 @@ 
         if (!empty($colWidths)) {
             foreach ($colWidths as $colWidth) {
                 $writer->write(
-                    '<col collapsed="false" hidden="false" max="'.($i + 1).'" min="'.($i + 1).
-                    '" style="0" customWidth="true" width="'.floatval($colWidth).'"/>'
+                    '<col collapsed="false" hidden="false" max="' . ($i + 1) . '" min="' . ($i + 1) .
+                    '" style="0" customWidth="true" width="' . floatval($colWidth) . '"/>'
                 );
                 ++$i;
             }
         }
         $writer->write(
-            '<col collapsed="false" hidden="false" max="1024" min="'.($i + 1).
-            '" style="0" customWidth="false" width="11.5"/>'.'</cols><sheetData>'
+            '<col collapsed="false" hidden="false" max="1024" min="' . ($i + 1) .
+            '" style="0" customWidth="false" width="11.5"/>' . '</cols><sheetData>'
         );
     }
 
@@ -172,7 +172,7 @@ 
         if (!empty($this->mergeCells)) {
             $this->fileWriter->write('<mergeCells>');
             foreach ($this->mergeCells as $range) {
-                $this->fileWriter->write('<mergeCell ref="'.$range.'"/>');
+                $this->fileWriter->write('<mergeCell ref="' . $range . '"/>');
             }
             $this->fileWriter->write('</mergeCells>');
         }
@@ -180,7 +180,7 @@ 
         $maxCell = Support::xlsCell($this->rowCount - 1, count($this->columns) - 1);
 
         if ($this->autoFilter) {
-            $this->fileWriter->write('<autoFilter ref="A1:'.$maxCell.'"/>');
+            $this->fileWriter->write('<autoFilter ref="A1:' . $maxCell . '"/>');
         }
 
         $this->fileWriter->write('<printOptions headings="false" gridLines="false" gridLinesSet="true" horizontalCentered="false" verticalCentered="false"/>');
@@ -192,10 +192,10 @@ 
         $this->fileWriter->write('</headerFooter>');
         $this->fileWriter->write('</worksheet>');
 
-        $maxCellTag = '<dimension ref="A1:'.$maxCell.'"/>';
+        $maxCellTag = '<dimension ref="A1:' . $maxCell . '"/>';
         $paddingLength = $this->maxCellTagEnd - $this->maxCellTagStart - strlen($maxCellTag);
         $this->fileWriter->fseek($this->maxCellTagStart);
-        $this->fileWriter->write($maxCellTag.str_repeat(' ', $paddingLength));
+        $this->fileWriter->write($maxCellTag . str_repeat(' ', $paddingLength));
         $this->fileWriter->close();
         $this->finalized = true;
     }
@@ -204,14 +204,14 @@ 
     {
         $writer = $this->getFileWriter();
         $writer->write(
-            '<pane ySplit="'.$this->freezeRows.'" xSplit="'.$this->freezeColumns.
-            '" topLeftCell="'.Support::xlsCell($this->freezeRows, $this->freezeColumns).
-            '" activePane="bottomRight" state="frozen"/>'.'<selection activeCell="'.Support::xlsCell($this->freezeRows, 0).
-            '" activeCellId="0" pane="topRight" sqref="'.Support::xlsCell($this->freezeRows, 0).'"/>'.
-            '<selection activeCell="'.Support::xlsCell(0, $this->freezeColumns).
-            '" activeCellId="0" pane="bottomLeft" sqref="'.Support::xlsCell(0, $this->freezeColumns).'"/>'.
-            '<selection activeCell="'.Support::xlsCell($this->freezeRows, $this->freezeColumns).
-            '" activeCellId="0" pane="bottomRight" sqref="'.Support::xlsCell($this->freezeRows, $this->freezeColumns).'"/>'
+            '<pane ySplit="' . $this->freezeRows . '" xSplit="' . $this->freezeColumns .
+            '" topLeftCell="' . Support::xlsCell($this->freezeRows, $this->freezeColumns) .
+            '" activePane="bottomRight" state="frozen"/>' . '<selection activeCell="' . Support::xlsCell($this->freezeRows, 0) .
+            '" activeCellId="0" pane="topRight" sqref="' . Support::xlsCell($this->freezeRows, 0) . '"/>' .
+            '<selection activeCell="' . Support::xlsCell(0, $this->freezeColumns) .
+            '" activeCellId="0" pane="bottomLeft" sqref="' . Support::xlsCell(0, $this->freezeColumns) . '"/>' .
+            '<selection activeCell="' . Support::xlsCell($this->freezeRows, $this->freezeColumns) .
+            '" activeCellId="0" pane="bottomRight" sqref="' . Support::xlsCell($this->freezeRows, $this->freezeColumns) . '"/>'
         );
     }
 
@@ -219,10 +219,10 @@ 
     {
         $writer = $this->getFileWriter();
         $writer->write(
-            '<pane ySplit="'.$this->freezeRows.'" topLeftCell="'.
-            Support::xlsCell($this->freezeRows, 0).'" activePane="bottomLeft" state="frozen"/>'.
-            '<selection activeCell="'.Support::xlsCell($this->freezeRows, 0).
-            '" activeCellId="0" pane="bottomLeft" sqref="'.Support::xlsCell($this->freezeRows, 0).'"/>'
+            '<pane ySplit="' . $this->freezeRows . '" topLeftCell="' .
+            Support::xlsCell($this->freezeRows, 0) . '" activePane="bottomLeft" state="frozen"/>' .
+            '<selection activeCell="' . Support::xlsCell($this->freezeRows, 0) .
+            '" activeCellId="0" pane="bottomLeft" sqref="' . Support::xlsCell($this->freezeRows, 0) . '"/>'
         );
     }
 
@@ -230,10 +230,10 @@ 
     {
         $writer = $this->getFileWriter();
         $writer->write(
-            '<pane xSplit="'.$this->freezeColumns.'" topLeftCell="'.
-            Support::xlsCell(0, $this->freezeColumns).'" activePane="topRight" state="frozen"/>'.
-            '<selection activeCell="'.Support::xlsCell(0, $this->freezeColumns).
-            '" activeCellId="0" pane="topRight" sqref="'.Support::xlsCell(0, $this->freezeColumns).'"/>'
+            '<pane xSplit="' . $this->freezeColumns . '" topLeftCell="' .
+            Support::xlsCell(0, $this->freezeColumns) . '" activePane="topRight" state="frozen"/>' .
+            '<selection activeCell="' . Support::xlsCell(0, $this->freezeColumns) .
+            '" activeCellId="0" pane="topRight" sqref="' . Support::xlsCell(0, $this->freezeColumns) . '"/>'
         );
     }