PHPOffice / PhpSpreadsheet

src/PhpSpreadsheet/Writer/Xlsx/Rels.php

Spacing +13 added lines, -13 removed lines

@@ -160,7 +160,7 @@ 
                 $objWriter,
                 ($i + 1 + 3),
                 'http://schemas.openxmlformats.org/officeDocument/2006/relationships/worksheet',
-                'worksheets/sheet'.($i + 1).'.xml'
+                'worksheets/sheet' . ($i + 1) . '.xml'
             );
         }
         // Relationships for vbaProject if needed
@@ -225,7 +225,7 @@ 
                 $objWriter,
                 ++$d,
                 'http://schemas.openxmlformats.org/officeDocument/2006/relationships/drawing',
-                '../drawings/drawing'.$pWorksheetId.'.xml'
+                '../drawings/drawing' . $pWorksheetId . '.xml'
             );
         }
 
@@ -235,7 +235,7 @@ 
             if (!$hyperlink->isInternal()) {
                 $this->writeRelationship(
                     $objWriter,
-                    '_hyperlink_'.$i,
+                    '_hyperlink_' . $i,
                     'http://schemas.openxmlformats.org/officeDocument/2006/relationships/hyperlink',
                     $hyperlink->getUrl(),
                     'External'
@@ -250,16 +250,16 @@ 
         if (count($pWorksheet->getComments()) > 0) {
             $this->writeRelationship(
                 $objWriter,
-                '_comments_vml'.$i,
+                '_comments_vml' . $i,
                 'http://schemas.openxmlformats.org/officeDocument/2006/relationships/vmlDrawing',
-                '../drawings/vmlDrawing'.$pWorksheetId.'.vml'
+                '../drawings/vmlDrawing' . $pWorksheetId . '.vml'
             );
 
             $this->writeRelationship(
                 $objWriter,
-                '_comments'.$i,
+                '_comments' . $i,
                 'http://schemas.openxmlformats.org/officeDocument/2006/relationships/comments',
-                '../comments'.$pWorksheetId.'.xml'
+                '../comments' . $pWorksheetId . '.xml'
             );
         }
 
@@ -268,9 +268,9 @@ 
         if (count($pWorksheet->getHeaderFooter()->getImages()) > 0) {
             $this->writeRelationship(
                 $objWriter,
-                '_headerfooter_vml'.$i,
+                '_headerfooter_vml' . $i,
                 'http://schemas.openxmlformats.org/officeDocument/2006/relationships/vmlDrawing',
-                '../drawings/vmlDrawingHF'.$pWorksheetId.'.vml'
+                '../drawings/vmlDrawingHF' . $pWorksheetId . '.vml'
             );
         }
 
@@ -318,7 +318,7 @@ 
                     $objWriter,
                     $i,
                     'http://schemas.openxmlformats.org/officeDocument/2006/relationships/image',
-                    '../media/'.str_replace(' ', '', $iterator->current()->getIndexedFilename())
+                    '../media/' . str_replace(' ', '', $iterator->current()->getIndexedFilename())
                 );
             }
 
@@ -335,7 +335,7 @@ 
                         $objWriter,
                         $i++,
                         'http://schemas.openxmlformats.org/officeDocument/2006/relationships/chart',
-                        '../charts/chart'.++$chartRef.'.xml'
+                        '../charts/chart' . ++$chartRef . '.xml'
                     );
                 }
             }
@@ -379,7 +379,7 @@ 
                 $objWriter,
                 $key,
                 'http://schemas.openxmlformats.org/officeDocument/2006/relationships/image',
-                '../media/'.$value->getIndexedFilename()
+                '../media/' . $value->getIndexedFilename()
             );
         }
 
@@ -404,7 +404,7 @@ 
         if ($pType != '' && $pTarget != '') {
             // Write relationship
             $objWriter->startElement('Relationship');
-            $objWriter->writeAttribute('Id', 'rId'.$pId);
+            $objWriter->writeAttribute('Id', 'rId' . $pId);
             $objWriter->writeAttribute('Type', $pType);
             $objWriter->writeAttribute('Target', $pTarget);
 

src/PhpSpreadsheet/Writer/Xlsx/Drawing.php

Spacing +5 added lines, -5 removed lines

@@ -118,7 +118,7 @@ 
         $objWriter->writeAttribute('macro', '');
         $objWriter->startElement('xdr:nvGraphicFramePr');
         $objWriter->startElement('xdr:cNvPr');
-        $objWriter->writeAttribute('name', 'Chart '.$pRelationId);
+        $objWriter->writeAttribute('name', 'Chart ' . $pRelationId);
         $objWriter->writeAttribute('id', 1025 * $pRelationId);
         $objWriter->endElement();
         $objWriter->startElement('xdr:cNvGraphicFramePr');
@@ -144,7 +144,7 @@ 
         $objWriter->startElement('c:chart');
         $objWriter->writeAttribute('xmlns:c', 'http://schemas.openxmlformats.org/drawingml/2006/chart');
         $objWriter->writeAttribute('xmlns:r', 'http://schemas.openxmlformats.org/officeDocument/2006/relationships');
-        $objWriter->writeAttribute('r:id', 'rId'.$pRelationId);
+        $objWriter->writeAttribute('r:id', 'rId' . $pRelationId);
         $objWriter->endElement();
         $objWriter->endElement();
         $objWriter->endElement();
@@ -219,7 +219,7 @@ 
             // a:blip
             $objWriter->startElement('a:blip');
             $objWriter->writeAttribute('xmlns:r', 'http://schemas.openxmlformats.org/officeDocument/2006/relationships');
-            $objWriter->writeAttribute('r:embed', 'rId'.$pRelationId);
+            $objWriter->writeAttribute('r:embed', 'rId' . $pRelationId);
             $objWriter->endElement();
 
             // a:stretch
@@ -507,13 +507,13 @@ 
         // v:shape
         $objWriter->startElement('v:shape');
         $objWriter->writeAttribute('id', $pReference);
-        $objWriter->writeAttribute('o:spid', '_x0000_s'.$id);
+        $objWriter->writeAttribute('o:spid', '_x0000_s' . $id);
         $objWriter->writeAttribute('type', '#_x0000_t75');
         $objWriter->writeAttribute('style', "position:absolute;margin-left:{$marginLeft}px;margin-top:{$marginTop}px;width:{$width}px;height:{$height}px;z-index:1");
 
         // v:imagedata
         $objWriter->startElement('v:imagedata');
-        $objWriter->writeAttribute('o:relid', 'rId'.$pReference);
+        $objWriter->writeAttribute('o:relid', 'rId' . $pReference);
         $objWriter->writeAttribute('o:title', $pImage->getName());
         $objWriter->endElement();
 

src/PhpSpreadsheet/Writer/Xlsx/Theme.php

Spacing +1 added lines, -1 removed lines

@@ -860,7 +860,7 @@
     private function writeColourScheme($objWriter)
     {
         foreach (self::$colourScheme as $colourName => $colourValue) {
-            $objWriter->startElement('a:'.$colourName);
+            $objWriter->startElement('a:' . $colourName);
 
                 $objWriter->startElement('a:srgbClr');
                     $objWriter->writeAttribute('val', $colourValue);

src/PhpSpreadsheet/Writer/Xlsx/Comments.php

Spacing +4 added lines, -4 removed lines

@@ -204,15 +204,15 @@
 
         // v:shape
         $objWriter->startElement('v:shape');
-        $objWriter->writeAttribute('id', '_x0000_s'.$id);
+        $objWriter->writeAttribute('id', '_x0000_s' . $id);
         $objWriter->writeAttribute('type', '#_x0000_t202');
-        $objWriter->writeAttribute('style', 'position:absolute;margin-left:'.$pComment->getMarginLeft().';margin-top:'.$pComment->getMarginTop().';width:'.$pComment->getWidth().';height:'.$pComment->getHeight().';z-index:1;visibility:'.($pComment->getVisible() ? 'visible' : 'hidden'));
-        $objWriter->writeAttribute('fillcolor', '#'.$pComment->getFillColor()->getRGB());
+        $objWriter->writeAttribute('style', 'position:absolute;margin-left:' . $pComment->getMarginLeft() . ';margin-top:' . $pComment->getMarginTop() . ';width:' . $pComment->getWidth() . ';height:' . $pComment->getHeight() . ';z-index:1;visibility:' . ($pComment->getVisible() ? 'visible' : 'hidden'));
+        $objWriter->writeAttribute('fillcolor', '#' . $pComment->getFillColor()->getRGB());
         $objWriter->writeAttribute('o:insetmode', 'auto');
 
             // v:fill
             $objWriter->startElement('v:fill');
-        $objWriter->writeAttribute('color2', '#'.$pComment->getFillColor()->getRGB());
+        $objWriter->writeAttribute('color2', '#' . $pComment->getFillColor()->getRGB());
         $objWriter->endElement();
 
             // v:shadow

src/PhpSpreadsheet/Writer/Xlsx/ContentTypes.php

Spacing +5 added lines, -5 removed lines

@@ -99,7 +99,7 @@ 
         // Worksheets
         $sheetCount = $spreadsheet->getSheetCount();
         for ($i = 0; $i < $sheetCount; ++$i) {
-            $this->writeOverrideContentType($objWriter, '/xl/worksheets/sheet'.($i + 1).'.xml', 'application/vnd.openxmlformats-officedocument.spreadsheetml.worksheet+xml');
+            $this->writeOverrideContentType($objWriter, '/xl/worksheets/sheet' . ($i + 1) . '.xml', 'application/vnd.openxmlformats-officedocument.spreadsheetml.worksheet+xml');
         }
 
         // Shared strings
@@ -114,13 +114,13 @@ 
 
             //    We need a drawing relationship for the worksheet if we have either drawings or charts
             if (($drawingCount > 0) || ($chartCount > 0)) {
-                $this->writeOverrideContentType($objWriter, '/xl/drawings/drawing'.($i + 1).'.xml', 'application/vnd.openxmlformats-officedocument.drawing+xml');
+                $this->writeOverrideContentType($objWriter, '/xl/drawings/drawing' . ($i + 1) . '.xml', 'application/vnd.openxmlformats-officedocument.drawing+xml');
             }
 
             //    If we have charts, then we need a chart relationship for every individual chart
             if ($chartCount > 0) {
                 for ($c = 0; $c < $chartCount; ++$c) {
-                    $this->writeOverrideContentType($objWriter, '/xl/charts/chart'.$chart++.'.xml', 'application/vnd.openxmlformats-officedocument.drawingml.chart+xml');
+                    $this->writeOverrideContentType($objWriter, '/xl/charts/chart' . $chart++ . '.xml', 'application/vnd.openxmlformats-officedocument.drawingml.chart+xml');
                 }
             }
         }
@@ -128,7 +128,7 @@ 
         // Comments
         for ($i = 0; $i < $sheetCount; ++$i) {
             if (count($spreadsheet->getSheet($i)->getComments()) > 0) {
-                $this->writeOverrideContentType($objWriter, '/xl/comments'.($i + 1).'.xml', 'application/vnd.openxmlformats-officedocument.spreadsheetml.comments+xml');
+                $this->writeOverrideContentType($objWriter, '/xl/comments' . ($i + 1) . '.xml', 'application/vnd.openxmlformats-officedocument.spreadsheetml.comments+xml');
             }
         }
 
@@ -161,7 +161,7 @@ 
             // we need to write "Extension" but not already write for media content
             $tabRibbonTypes = array_diff($spreadsheet->getRibbonBinObjects('types'), array_keys($aMediaContentTypes));
             foreach ($tabRibbonTypes as $aRibbonType) {
-                $mimeType = 'image/.'.$aRibbonType; //we wrote $mimeType like customUI Editor
+                $mimeType = 'image/.' . $aRibbonType; //we wrote $mimeType like customUI Editor
                 $this->writeDefaultContentType($objWriter, $aRibbonType, $mimeType);
             }
         }

src/PhpSpreadsheet/Writer/Xlsx/StringTable.php

Spacing +15 added lines, -15 removed lines

@@ -153,31 +153,31 @@ 
         $elements = $pRichText->getRichTextElements();
         foreach ($elements as $element) {
             // r
-            $objWriter->startElement($prefix.'r');
+            $objWriter->startElement($prefix . 'r');
 
             // rPr
             if ($element instanceof \PhpOffice\PhpSpreadsheet\RichText\Run) {
                 // rPr
-                $objWriter->startElement($prefix.'rPr');
+                $objWriter->startElement($prefix . 'rPr');
 
                 // rFont
-                $objWriter->startElement($prefix.'rFont');
+                $objWriter->startElement($prefix . 'rFont');
                 $objWriter->writeAttribute('val', $element->getFont()->getName());
                 $objWriter->endElement();
 
                 // Bold
-                $objWriter->startElement($prefix.'b');
+                $objWriter->startElement($prefix . 'b');
                 $objWriter->writeAttribute('val', ($element->getFont()->getBold() ? 'true' : 'false'));
                 $objWriter->endElement();
 
                 // Italic
-                $objWriter->startElement($prefix.'i');
+                $objWriter->startElement($prefix . 'i');
                 $objWriter->writeAttribute('val', ($element->getFont()->getItalic() ? 'true' : 'false'));
                 $objWriter->endElement();
 
                 // Superscript / subscript
                 if ($element->getFont()->getSuperScript() || $element->getFont()->getSubScript()) {
-                    $objWriter->startElement($prefix.'vertAlign');
+                    $objWriter->startElement($prefix . 'vertAlign');
                     if ($element->getFont()->getSuperScript()) {
                         $objWriter->writeAttribute('val', 'superscript');
                     } elseif ($element->getFont()->getSubScript()) {
@@ -187,22 +187,22 @@ 
                 }
 
                 // Strikethrough
-                $objWriter->startElement($prefix.'strike');
+                $objWriter->startElement($prefix . 'strike');
                 $objWriter->writeAttribute('val', ($element->getFont()->getStrikethrough() ? 'true' : 'false'));
                 $objWriter->endElement();
 
                 // Color
-                $objWriter->startElement($prefix.'color');
+                $objWriter->startElement($prefix . 'color');
                 $objWriter->writeAttribute('rgb', $element->getFont()->getColor()->getARGB());
                 $objWriter->endElement();
 
                 // Size
-                $objWriter->startElement($prefix.'sz');
+                $objWriter->startElement($prefix . 'sz');
                 $objWriter->writeAttribute('val', $element->getFont()->getSize());
                 $objWriter->endElement();
 
                 // Underline
-                $objWriter->startElement($prefix.'u');
+                $objWriter->startElement($prefix . 'u');
                 $objWriter->writeAttribute('val', $element->getFont()->getUnderline());
                 $objWriter->endElement();
 
@@ -210,7 +210,7 @@ 
             }
 
             // t
-            $objWriter->startElement($prefix.'t');
+            $objWriter->startElement($prefix . 't');
             $objWriter->writeAttribute('xml:space', 'preserve');
             $objWriter->writeRawData(\PhpOffice\PhpSpreadsheet\Shared\StringHelper::controlCharacterPHP2OOXML($element->getText()));
             $objWriter->endElement();
@@ -244,10 +244,10 @@ 
         $elements = $pRichText->getRichTextElements();
         foreach ($elements as $element) {
             // r
-            $objWriter->startElement($prefix.'r');
+            $objWriter->startElement($prefix . 'r');
 
             // rPr
-            $objWriter->startElement($prefix.'rPr');
+            $objWriter->startElement($prefix . 'rPr');
 
             // Bold
             $objWriter->writeAttribute('b', ($element->getFont()->getBold() ? 1 : 0));
@@ -268,14 +268,14 @@ 
             $objWriter->writeAttribute('strike', ($element->getFont()->getStrikethrough() ? 'sngStrike' : 'noStrike'));
 
             // rFont
-            $objWriter->startElement($prefix.'latin');
+            $objWriter->startElement($prefix . 'latin');
             $objWriter->writeAttribute('typeface', $element->getFont()->getName());
             $objWriter->endElement();
 
             $objWriter->endElement();
 
             // t
-            $objWriter->startElement($prefix.'t');
+            $objWriter->startElement($prefix . 't');
             $objWriter->writeRawData(\PhpOffice\PhpSpreadsheet\Shared\StringHelper::controlCharacterPHP2OOXML($element->getText()));
             $objWriter->endElement();
 

src/PhpSpreadsheet/Writer/Xlsx/Worksheet.php

Spacing +7 added lines, -7 removed lines

@@ -515,19 +515,19 @@ 
                     if ($conditional->getConditionType() == \PhpOffice\PhpSpreadsheet\Style\Conditional::CONDITION_CONTAINSTEXT
                         && $conditional->getOperatorType() == \PhpOffice\PhpSpreadsheet\Style\Conditional::OPERATOR_CONTAINSTEXT
                         && !is_null($conditional->getText())) {
-                        $objWriter->writeElement('formula', 'NOT(ISERROR(SEARCH("'.$conditional->getText().'",'.$cellCoordinate.')))');
+                        $objWriter->writeElement('formula', 'NOT(ISERROR(SEARCH("' . $conditional->getText() . '",' . $cellCoordinate . ')))');
                     } elseif ($conditional->getConditionType() == \PhpOffice\PhpSpreadsheet\Style\Conditional::CONDITION_CONTAINSTEXT
                         && $conditional->getOperatorType() == \PhpOffice\PhpSpreadsheet\Style\Conditional::OPERATOR_BEGINSWITH
                         && !is_null($conditional->getText())) {
-                        $objWriter->writeElement('formula', 'LEFT('.$cellCoordinate.','.strlen($conditional->getText()).')="'.$conditional->getText().'"');
+                        $objWriter->writeElement('formula', 'LEFT(' . $cellCoordinate . ',' . strlen($conditional->getText()) . ')="' . $conditional->getText() . '"');
                     } elseif ($conditional->getConditionType() == \PhpOffice\PhpSpreadsheet\Style\Conditional::CONDITION_CONTAINSTEXT
                         && $conditional->getOperatorType() == \PhpOffice\PhpSpreadsheet\Style\Conditional::OPERATOR_ENDSWITH
                         && !is_null($conditional->getText())) {
-                        $objWriter->writeElement('formula', 'RIGHT('.$cellCoordinate.','.strlen($conditional->getText()).')="'.$conditional->getText().'"');
+                        $objWriter->writeElement('formula', 'RIGHT(' . $cellCoordinate . ',' . strlen($conditional->getText()) . ')="' . $conditional->getText() . '"');
                     } elseif ($conditional->getConditionType() == \PhpOffice\PhpSpreadsheet\Style\Conditional::CONDITION_CONTAINSTEXT
                         && $conditional->getOperatorType() == \PhpOffice\PhpSpreadsheet\Style\Conditional::OPERATOR_NOTCONTAINS
                         && !is_null($conditional->getText())) {
-                        $objWriter->writeElement('formula', 'ISERROR(SEARCH("'.$conditional->getText().'",'.$cellCoordinate.'))');
+                        $objWriter->writeElement('formula', 'ISERROR(SEARCH("' . $conditional->getText() . '",' . $cellCoordinate . '))');
                     } elseif ($conditional->getConditionType() == \PhpOffice\PhpSpreadsheet\Style\Conditional::CONDITION_CELLIS
                         || $conditional->getConditionType() == \PhpOffice\PhpSpreadsheet\Style\Conditional::CONDITION_CONTAINSTEXT
                         || $conditional->getConditionType() == \PhpOffice\PhpSpreadsheet\Style\Conditional::CONDITION_EXPRESSION) {
@@ -637,7 +637,7 @@ 
 
                 $objWriter->writeAttribute('ref', $coordinate);
                 if (!$hyperlink->isInternal()) {
-                    $objWriter->writeAttribute('r:id', 'rId_hyperlink_'.$relationId);
+                    $objWriter->writeAttribute('r:id', 'rId_hyperlink_' . $relationId);
                     ++$relationId;
                 } else {
                     $objWriter->writeAttribute('location', str_replace('sheet://', '', $hyperlink->getUrl()));
@@ -672,7 +672,7 @@ 
             foreach ($pSheet->getProtectedCells() as $protectedCell => $passwordHash) {
                 // protectedRange
                 $objWriter->startElement('protectedRange');
-                $objWriter->writeAttribute('name', 'p'.md5($protectedCell));
+                $objWriter->writeAttribute('name', 'p' . md5($protectedCell));
                 $objWriter->writeAttribute('sqref', $protectedCell);
                 if (!empty($passwordHash)) {
                     $objWriter->writeAttribute('password', $passwordHash);
@@ -1015,7 +1015,7 @@ 
                     // Start a new row
                     $objWriter->startElement('row');
                     $objWriter->writeAttribute('r', $currentRow);
-                    $objWriter->writeAttribute('spans', '1:'.$colCount);
+                    $objWriter->writeAttribute('spans', '1:' . $colCount);
 
                     // Row dimensions
                     if ($rowDimension->getRowHeight() >= 0) {

src/PhpSpreadsheet/Spreadsheet.php

Spacing +6 added lines, -6 removed lines

@@ -733,7 +733,7 @@ 
             return $worksheet;
         }
 
-        throw new Exception('Workbook does not contain sheet:'.$pValue);
+        throw new Exception('Workbook does not contain sheet:' . $pValue);
     }
 
     /**
@@ -812,7 +812,7 @@ 
             $this->namedRanges[$namedRange->getName()] = $namedRange;
         } else {
             // local scope
-            $this->namedRanges[$namedRange->getScope()->getTitle().'!'.$namedRange->getName()] = $namedRange;
+            $this->namedRanges[$namedRange->getScope()->getTitle() . '!' . $namedRange->getName()] = $namedRange;
         }
 
         return true;
@@ -837,8 +837,8 @@ 
             }
 
             // then look for local defined name (has priority over global defined name if both names exist)
-            if (($pSheet !== null) && isset($this->namedRanges[$pSheet->getTitle().'!'.$namedRange])) {
-                $returnValue = $this->namedRanges[$pSheet->getTitle().'!'.$namedRange];
+            if (($pSheet !== null) && isset($this->namedRanges[$pSheet->getTitle() . '!' . $namedRange])) {
+                $returnValue = $this->namedRanges[$pSheet->getTitle() . '!' . $namedRange];
             }
         }
 
@@ -860,8 +860,8 @@ 
                 unset($this->namedRanges[$namedRange]);
             }
         } else {
-            if (isset($this->namedRanges[$pSheet->getTitle().'!'.$namedRange])) {
-                unset($this->namedRanges[$pSheet->getTitle().'!'.$namedRange]);
+            if (isset($this->namedRanges[$pSheet->getTitle() . '!' . $namedRange])) {
+                unset($this->namedRanges[$pSheet->getTitle() . '!' . $namedRange]);
             }
         }
 

src/PhpSpreadsheet/Chart/Properties.php

Spacing +1 added lines, -1 removed lines

@@ -133,7 +133,7 @@
 
     protected function getTrueAlpha($alpha)
     {
-        return (string) 100 - $alpha.'000';
+        return (string) 100 - $alpha . '000';
     }
 
     protected function setColorProperties($color, $alpha, $type)