PHPOffice / PhpSpreadsheet

src/PhpSpreadsheet/Writer/Xls/Worksheet.php

Spacing +75 added lines, -75 removed lines

@@ -490,7 +490,7 @@ 
                 // URL
             } else {
                 // external (local file)
-                $url = 'external:'.$url;
+                $url = 'external:' . $url;
             }
 
             $this->writeUrl($row - 1, \PhpOffice\PhpSpreadsheet\Cell::columnIndexFromString($column) - 1, $url);
@@ -636,7 +636,7 @@ 
             $xl_double = strrev($xl_double);
         }
 
-        $this->append($header.$data.$xl_double);
+        $this->append($header . $data . $xl_double);
 
         return 0;
     }
@@ -678,7 +678,7 @@ 
 
         $header = pack('vv', $record, $length);
         $data = pack('vvvV', $row, $col, $xfIndex, $this->stringTable[$str]);
-        $this->append($header.$data);
+        $this->append($header . $data);
     }
 
     /**
@@ -713,7 +713,7 @@ 
 
         $header = pack('vv', $record, $length);
         $data = pack('vvvv', $row, $col, $xfIndex, $strlen);
-        $this->append($header.$data.$str);
+        $this->append($header . $data . $str);
 
         return $str_error;
     }
@@ -748,7 +748,7 @@ 
 
         $header = pack('vv', $record, $length);
         $data = pack('vvvV', $row, $col, $xfIndex, $this->stringTable[$str]);
-        $this->append($header.$data);
+        $this->append($header . $data);
     }
 
     /**
@@ -769,14 +769,14 @@ 
         $length = 0x0006 + min($note_length, 2048);
         $header = pack('vv', $record, $length);
         $data = pack('vvv', $row, $col, $note_length);
-        $this->append($header.$data.substr($note, 0, 2048));
+        $this->append($header . $data . substr($note, 0, 2048));
 
         for ($i = $max_length; $i < $note_length; $i += $max_length) {
             $chunk = substr($note, $i, $max_length);
             $length = 0x0006 + strlen($chunk);
             $header = pack('vv', $record, $length);
             $data = pack('vvv', -1, 0, strlen($chunk));
-            $this->append($header.$data.$chunk);
+            $this->append($header . $data . $chunk);
         }
 
         return 0;
@@ -805,7 +805,7 @@ 
 
         $header = pack('vv', $record, $length);
         $data = pack('vvv', $row, $col, $xfIndex);
-        $this->append($header.$data);
+        $this->append($header . $data);
 
         return 0;
     }
@@ -826,7 +826,7 @@ 
 
         $header = pack('vv', $record, $length);
         $data = pack('vvvCC', $row, $col, $xfIndex, $value, $isError);
-        $this->append($header.$data);
+        $this->append($header . $data);
 
         return 0;
     }
@@ -912,7 +912,7 @@ 
             $data = pack('vvv', $row, $col, $xfIndex)
                         .$num
                         .pack('vVv', $grbit, $unknown, $formlen);
-            $this->append($header.$data.$formula);
+            $this->append($header . $data . $formula);
 
             // Append also a STRING record if necessary
             if ($stringValue !== null) {
@@ -938,7 +938,7 @@ 
         $length = strlen($data);
         $header = pack('vv', $record, $length);
 
-        $this->append($header.$data);
+        $this->append($header . $data);
     }
 
     /**
@@ -1026,7 +1026,7 @@ 
 
         // Convert URL to a null terminated wchar string
         $url = implode("\0", preg_split("''", $url, -1, PREG_SPLIT_NO_EMPTY));
-        $url = $url."\0\0\0";
+        $url = $url . "\0\0\0";
 
         // Pack the length of the URL
         $url_len = pack('V', strlen($url));
@@ -1039,7 +1039,7 @@ 
         $data = pack('vvvv', $row1, $row2, $col1, $col2);
 
         // Write the packed data
-        $this->append($header.$data.$unknown1.$options.$unknown2.$url_len.$url);
+        $this->append($header . $data . $unknown1 . $options . $unknown2 . $url_len . $url);
 
         return 0;
     }
@@ -1088,7 +1088,7 @@ 
         $data = pack('vvvv', $row1, $row2, $col1, $col2);
 
         // Write the packed data
-        $this->append($header.$data.$unknown1.$options.$url_len.$url);
+        $this->append($header . $data . $unknown1 . $options . $url_len . $url);
 
         return 0;
     }
@@ -1153,10 +1153,10 @@ 
         $up_count = pack('v', $up_count);
 
         // Store the short dos dir name (null terminated)
-        $dir_short = preg_replace("/\.\.\\\/", '', $dir_long)."\0";
+        $dir_short = preg_replace("/\.\.\\\/", '', $dir_long) . "\0";
 
         // Store the long dir name as a wchar string (non-null terminated)
-        $dir_long = $dir_long."\0";
+        $dir_long = $dir_long . "\0";
 
         // Pack the lengths of the dir strings
         $dir_short_len = pack('V', strlen($dir_short));
@@ -1170,14 +1170,14 @@ 
         $unknown4 = pack('v', 0x03);
 
         // Pack the main data stream
-        $data = pack('vvvv', $row1, $row2, $col1, $col2).
-                          $unknown1.
-                          $link_type.
-                          $unknown2.
-                          $up_count.
-                          $dir_short_len.
-                          $dir_short.
-                          $unknown3.
+        $data = pack('vvvv', $row1, $row2, $col1, $col2) .
+                          $unknown1 .
+                          $link_type .
+                          $unknown2 .
+                          $up_count .
+                          $dir_short_len .
+                          $dir_short .
+                          $unknown3 .
                           $stream_len; /*.
                           $dir_long_len .
                           $unknown4     .
@@ -1190,7 +1190,7 @@ 
         $header = pack('vv', $record, $length);
 
         // Write the packed data
-        $this->append($header.$data);
+        $this->append($header . $data);
 
         return 0;
     }
@@ -1248,7 +1248,7 @@ 
 
         $header = pack('vv', $record, $length);
         $data = pack('vvvvvvvv', $row, $colMic, $colMac, $miyRw, $irwMac, $reserved, $grbit, $ixfe);
-        $this->append($header.$data);
+        $this->append($header . $data);
     }
 
     /**
@@ -1262,7 +1262,7 @@ 
         $data = pack('VVvvv', $this->firstRowIndex, $this->lastRowIndex + 1, $this->firstColumnIndex, $this->lastColumnIndex + 1, 0x0000); // reserved
 
         $header = pack('vv', $record, $length);
-        $this->append($header.$data);
+        $this->append($header . $data);
     }
 
     /**
@@ -1315,7 +1315,7 @@ 
 
         $data .= pack('vvvvV', $rgbHdr, 0x0000, $zoom_factor_page_break, $zoom_factor_normal, 0x00000000);
 
-        $this->append($header.$data);
+        $this->append($header . $data);
     }
 
     /**
@@ -1337,7 +1337,7 @@ 
 
         $header = pack('vv', $record, $length);
         $data = pack('vv', 1, $defaultRowHeight);
-        $this->append($header.$data);
+        $this->append($header . $data);
     }
 
     /**
@@ -1352,7 +1352,7 @@ 
 
         $header = pack('vv', $record, $length);
         $data = pack('v', $defaultColWidth);
-        $this->append($header.$data);
+        $this->append($header . $data);
     }
 
     /**
@@ -1410,7 +1410,7 @@ 
 
         $header = pack('vv', $record, $length);
         $data = pack('vvvvvv', $colFirst, $colLast, $coldx, $ixfe, $grbit, $reserved);
-        $this->append($header.$data);
+        $this->append($header . $data);
     }
 
     /**
@@ -1471,7 +1471,7 @@ 
 
         $header = pack('vv', $record, $length);
         $data = pack('CvvvvvvCC', $pnn, $rwAct, $colAct, $irefAct, $cref, $rwFirst, $rwLast, $colFirst, $colLast);
-        $this->append($header.$data);
+        $this->append($header . $data);
     }
 
     /**
@@ -1516,10 +1516,10 @@ 
 
             // flush record if we have reached limit for number of merged cells, or reached final merged cell
             if ($j == $maxCountMergeCellsPerRecord or $i == $countMergeCells) {
-                $recordData = pack('v', $j).$recordData;
+                $recordData = pack('v', $j) . $recordData;
                 $length = strlen($recordData);
                 $header = pack('vv', $record, $length);
-                $this->append($header.$recordData);
+                $this->append($header . $recordData);
 
                 // initialize for next record, if any
                 $recordData = '';
@@ -1552,7 +1552,7 @@ 
 
         $record = 0x0862; // Record identifier
         $header = pack('vv', $record, $length);
-        $this->append($header.$recordData);
+        $this->append($header . $recordData);
     }
 
     /**
@@ -1596,7 +1596,7 @@ 
         $length = strlen($recordData);
         $header = pack('vv', $record, $length);
 
-        $this->append($header.$recordData);
+        $this->append($header . $recordData);
     }
 
     /**
@@ -1637,13 +1637,13 @@ 
                 hexdec($password)
             );
 
-            $recordData .= \PhpOffice\PhpSpreadsheet\Shared\StringHelper::UTF8toBIFF8UnicodeLong('p'.md5($recordData));
+            $recordData .= \PhpOffice\PhpSpreadsheet\Shared\StringHelper::UTF8toBIFF8UnicodeLong('p' . md5($recordData));
 
             $length = strlen($recordData);
 
             $record = 0x0868; // Record identifier
             $header = pack('vv', $record, $length);
-            $this->append($header.$recordData);
+            $this->append($header . $recordData);
         }
     }
 
@@ -1666,7 +1666,7 @@ 
 
         $header = pack('vv', $record, $length);
         $data = pack('v', $count);
-        $this->append($header.$data);
+        $this->append($header . $data);
     }
 
     /**
@@ -1697,7 +1697,7 @@ 
 
         $header = pack('vv', $record, $length);
         $data = pack('CC', $cch, $rgch);
-        $this->append($header.$data.$sheetname);
+        $this->append($header . $data . $sheetname);
     }
 
     /**
@@ -1779,7 +1779,7 @@ 
 
         $header = pack('vv', $record, $length);
         $data = pack('vvvvv', $x, $y, $rwTop, $colLeft, $pnnAct);
-        $this->append($header.$data);
+        $this->append($header . $data);
     }
 
     /**
@@ -1838,9 +1838,9 @@ 
 
         $header = pack('vv', $record, $length);
         $data1 = pack('vvvvvvvv', $iPaperSize, $iScale, $iPageStart, $iFitWidth, $iFitHeight, $grbit, $iRes, $iVRes);
-        $data2 = $numHdr.$numFtr;
+        $data2 = $numHdr . $numFtr;
         $data3 = pack('v', $iCopies);
-        $this->append($header.$data1.$data2.$data3);
+        $this->append($header . $data1 . $data2 . $data3);
     }
 
     /**
@@ -1864,7 +1864,7 @@ 
 
         $header = pack('vv', $record, $length);
 
-        $this->append($header.$recordData);
+        $this->append($header . $recordData);
     }
 
     /**
@@ -1888,7 +1888,7 @@ 
 
         $header = pack('vv', $record, $length);
 
-        $this->append($header.$recordData);
+        $this->append($header . $recordData);
     }
 
     /**
@@ -1904,7 +1904,7 @@ 
         $header = pack('vv', $record, $length);
         $data = pack('v', $fHCenter);
 
-        $this->append($header.$data);
+        $this->append($header . $data);
     }
 
     /**
@@ -1919,7 +1919,7 @@ 
 
         $header = pack('vv', $record, $length);
         $data = pack('v', $fVCenter);
-        $this->append($header.$data);
+        $this->append($header . $data);
     }
 
     /**
@@ -1938,7 +1938,7 @@ 
             $data = strrev($data);
         }
 
-        $this->append($header.$data);
+        $this->append($header . $data);
     }
 
     /**
@@ -1957,7 +1957,7 @@ 
             $data = strrev($data);
         }
 
-        $this->append($header.$data);
+        $this->append($header . $data);
     }
 
     /**
@@ -1976,7 +1976,7 @@ 
             $data = strrev($data);
         }
 
-        $this->append($header.$data);
+        $this->append($header . $data);
     }
 
     /**
@@ -1995,7 +1995,7 @@ 
             $data = strrev($data);
         }
 
-        $this->append($header.$data);
+        $this->append($header . $data);
     }
 
     /**
@@ -2010,7 +2010,7 @@ 
 
         $header = pack('vv', $record, $length);
         $data = pack('v', $fPrintRwCol);
-        $this->append($header.$data);
+        $this->append($header . $data);
     }
 
     /**
@@ -2026,7 +2026,7 @@ 
 
         $header = pack('vv', $record, $length);
         $data = pack('v', $fPrintGrid);
-        $this->append($header.$data);
+        $this->append($header . $data);
     }
 
     /**
@@ -2042,7 +2042,7 @@ 
 
         $header = pack('vv', $record, $length);
         $data = pack('v', $fGridSet);
-        $this->append($header.$data);
+        $this->append($header . $data);
     }
 
     /**
@@ -2058,7 +2058,7 @@ 
 
         $header = pack('vv', $record, $length);
         $data = pack('v', $iNumFilters);
-        $this->append($header.$data);
+        $this->append($header . $data);
     }
 
     /**
@@ -2105,7 +2105,7 @@ 
         $header = pack('vv', $record, $length);
         $data = pack('vvvv', $dxRwGut, $dxColGut, $maxRowOutlineLevel, $col_level);
 
-        $this->append($header.$data);
+        $this->append($header . $data);
     }
 
     /**
@@ -2141,7 +2141,7 @@ 
 
         $header = pack('vv', $record, $length);
         $data = pack('v', $grbit);
-        $this->append($header.$data);
+        $this->append($header . $data);
     }
 
     /**
@@ -2194,7 +2194,7 @@ 
                 $data .= pack('vvv', $hbreak, 0x0000, 0x00ff);
             }
 
-            $this->append($header.$data);
+            $this->append($header . $data);
         }
 
         // vertical page breaks
@@ -2221,7 +2221,7 @@ 
                 $data .= pack('vvv', $vbreak, 0x0000, 0xffff);
             }
 
-            $this->append($header.$data);
+            $this->append($header . $data);
         }
     }
 
@@ -2243,7 +2243,7 @@ 
         $header = pack('vv', $record, $length);
         $data = pack('v', $fLock);
 
-        $this->append($header.$data);
+        $this->append($header . $data);
     }
 
     /**
@@ -2267,7 +2267,7 @@ 
         $header = pack('vv', $record, $length);
         $data = pack('v', 1);
 
-        $this->append($header.$data);
+        $this->append($header . $data);
     }
 
     /**
@@ -2291,7 +2291,7 @@ 
         $header = pack('vv', $record, $length);
         $data = pack('v', 1);
 
-        $this->append($header.$data);
+        $this->append($header . $data);
     }
 
     /**
@@ -2312,7 +2312,7 @@ 
         $header = pack('vv', $record, $length);
         $data = pack('v', $wPassword);
 
-        $this->append($header.$data);
+        $this->append($header . $data);
     }
 
     /**
@@ -2346,7 +2346,7 @@ 
         $lcb = $size;
 
         $header = pack('vvvvV', $record, $length, $cf, $env, $lcb);
-        $this->append($header.$data);
+        $this->append($header . $data);
     }
 
     /**
@@ -2528,7 +2528,7 @@ 
         $data .= pack('v', $grbit2);
         $data .= pack('V', $Reserved5);
 
-        $this->append($header.$data);
+        $this->append($header . $data);
     }
 
     /**
@@ -2550,7 +2550,7 @@ 
                 foreach (['red', 'green', 'blue'] as $key) {
                     $color[$key] = $color[$key] + round((255 - $color[$key]) * $color['alpha'] / 127);
                 }
-                $data .= chr($color['blue']).chr($color['green']).chr($color['red']);
+                $data .= chr($color['blue']) . chr($color['green']) . chr($color['red']);
             }
             if (3 * $width % 4) {
                 $data .= str_repeat("\x00", 4 - 3 * $width % 4);
@@ -2641,7 +2641,7 @@ 
 
         // Add the BITMAPCOREHEADER data
         $header = pack('Vvvvv', 0x000c, $width, $height, 0x01, 0x18);
-        $data = $header.$data;
+        $data = $header . $data;
 
         return [$width, $height, $size, $data];
     }
@@ -2662,7 +2662,7 @@ 
 
         $header = pack('vv', $record, $length);
         $data = pack('vv', $this->phpSheet->getSheetView()->getZoomScale(), 100);
-        $this->append($header.$data);
+        $this->append($header . $data);
     }
 
     /**
@@ -2711,7 +2711,7 @@ 
                 $length = strlen($dataChunk);
                 $header = pack('vv', $record, $length);
 
-                $this->append($header.$dataChunk);
+                $this->append($header . $dataChunk);
 
                 // OBJ record
                 $record = 0x005D; // record identifier
@@ -2765,7 +2765,7 @@ 
 
                 $length = strlen($objData);
                 $header = pack('vv', $record, $length);
-                $this->append($header.$objData);
+                $this->append($header . $objData);
             }
         }
     }
@@ -2791,7 +2791,7 @@ 
 
             $header = pack('vv', $record, $length);
             $data = pack('vVVVV', $grbit, $horPos, $verPos, $objId, count($dataValidationCollection));
-            $this->append($header.$data);
+            $this->append($header . $data);
 
             // DATAVALIDATION records
             $record = 0x01BE; // Record identifier
@@ -2956,7 +2956,7 @@ 
                 $length = strlen($data);
                 $header = pack('vv', $record, $length);
 
-                $this->append($header.$data);
+                $this->append($header . $data);
             }
         }
     }
@@ -3018,7 +3018,7 @@ 
 
         $header = pack('vv', $record, $length);
         $data = pack('vvVVvv', $rt, $grbitFrt, 0x00000000, 0x00000000, $wScalvePLV, $grbit);
-        $this->append($header.$data);
+        $this->append($header . $data);
     }
 
     /**
@@ -4196,7 +4196,7 @@ 
             $data .= $operand2;
         }
         $header = pack('vv', $record, strlen($data));
-        $this->append($header.$data);
+        $this->append($header . $data);
     }
 
     /**
@@ -4247,6 +4247,6 @@ 
         $data .= $cellRange;
         $data .= pack('v', 0x0001);
         $data .= $cellRange;
-        $this->append($header.$data);
+        $this->append($header . $data);
     }
 }

src/PhpSpreadsheet/Writer/Xls/Parser.php

Spacing +21 added lines, -21 removed lines

@@ -519,19 +519,19 @@ 
         } elseif (preg_match('/^\$?([A-Ia-i]?[A-Za-z])\$?(\d+)$/', $token)) {
             return $this->convertRef2d($token);
         // match external references like Sheet1!A1 or Sheet1:Sheet2!A1 or Sheet1!$A$1 or Sheet1:Sheet2!$A$1
-        } elseif (preg_match('/^'.self::REGEX_SHEET_TITLE_UNQUOTED."(\:".self::REGEX_SHEET_TITLE_UNQUOTED.")?\!\\$?[A-Ia-i]?[A-Za-z]\\$?(\d+)$/u", $token)) {
+        } elseif (preg_match('/^' . self::REGEX_SHEET_TITLE_UNQUOTED . "(\:" . self::REGEX_SHEET_TITLE_UNQUOTED . ")?\!\\$?[A-Ia-i]?[A-Za-z]\\$?(\d+)$/u", $token)) {
             return $this->convertRef3d($token);
         // match external references like 'Sheet1'!A1 or 'Sheet1:Sheet2'!A1 or 'Sheet1'!$A$1 or 'Sheet1:Sheet2'!$A$1
-        } elseif (preg_match("/^'".self::REGEX_SHEET_TITLE_QUOTED."(\:".self::REGEX_SHEET_TITLE_QUOTED.")?'\!\\$?[A-Ia-i]?[A-Za-z]\\$?(\d+)$/u", $token)) {
+        } elseif (preg_match("/^'" . self::REGEX_SHEET_TITLE_QUOTED . "(\:" . self::REGEX_SHEET_TITLE_QUOTED . ")?'\!\\$?[A-Ia-i]?[A-Za-z]\\$?(\d+)$/u", $token)) {
             return $this->convertRef3d($token);
         // match ranges like A1:B2 or $A$1:$B$2
         } elseif (preg_match('/^(\$)?[A-Ia-i]?[A-Za-z](\$)?(\d+)\:(\$)?[A-Ia-i]?[A-Za-z](\$)?(\d+)$/', $token)) {
             return $this->convertRange2d($token);
         // match external ranges like Sheet1!A1:B2 or Sheet1:Sheet2!A1:B2 or Sheet1!$A$1:$B$2 or Sheet1:Sheet2!$A$1:$B$2
-        } elseif (preg_match('/^'.self::REGEX_SHEET_TITLE_UNQUOTED."(\:".self::REGEX_SHEET_TITLE_UNQUOTED.")?\!\\$?([A-Ia-i]?[A-Za-z])?\\$?(\d+)\:\\$?([A-Ia-i]?[A-Za-z])?\\$?(\d+)$/u", $token)) {
+        } elseif (preg_match('/^' . self::REGEX_SHEET_TITLE_UNQUOTED . "(\:" . self::REGEX_SHEET_TITLE_UNQUOTED . ")?\!\\$?([A-Ia-i]?[A-Za-z])?\\$?(\d+)\:\\$?([A-Ia-i]?[A-Za-z])?\\$?(\d+)$/u", $token)) {
             return $this->convertRange3d($token);
         // match external ranges like 'Sheet1'!A1:B2 or 'Sheet1:Sheet2'!A1:B2 or 'Sheet1'!$A$1:$B$2 or 'Sheet1:Sheet2'!$A$1:$B$2
-        } elseif (preg_match("/^'".self::REGEX_SHEET_TITLE_QUOTED."(\:".self::REGEX_SHEET_TITLE_QUOTED.")?'\!\\$?([A-Ia-i]?[A-Za-z])?\\$?(\d+)\:\\$?([A-Ia-i]?[A-Za-z])?\\$?(\d+)$/u", $token)) {
+        } elseif (preg_match("/^'" . self::REGEX_SHEET_TITLE_QUOTED . "(\:" . self::REGEX_SHEET_TITLE_QUOTED . ")?'\!\\$?([A-Ia-i]?[A-Za-z])?\\$?(\d+)\:\\$?([A-Ia-i]?[A-Za-z])?\\$?(\d+)$/u", $token)) {
             return $this->convertRange3d($token);
         // operators (including parentheses)
         } elseif (isset($this->ptg[$token])) {
@@ -587,7 +587,7 @@ 
             throw new \PhpOffice\PhpSpreadsheet\Writer\WriteException('String is too long');
         }
 
-        return pack('C', $this->ptg['ptgStr']).\PhpOffice\PhpSpreadsheet\Shared\StringHelper::UTF8toBIFF8UnicodeShort($string);
+        return pack('C', $this->ptg['ptgStr']) . \PhpOffice\PhpSpreadsheet\Shared\StringHelper::UTF8toBIFF8UnicodeShort($string);
     }
 
     /**
@@ -647,7 +647,7 @@ 
             throw new \PhpOffice\PhpSpreadsheet\Writer\WriteException("Unknown class $class");
         }
 
-        return $ptgArea.$row1.$row2.$col1.$col2;
+        return $ptgArea . $row1 . $row2 . $col1 . $col2;
     }
 
     /**
@@ -674,13 +674,13 @@ 
             list($row1, $col1) = $this->cellToPackedRowcol($cell1);
             list($row2, $col2) = $this->cellToPackedRowcol($cell2);
         } else { // It's a rows range (like 26:27)
-            list($row1, $col1, $row2, $col2) = $this->rangeToPackedRange($cell1.':'.$cell2);
+            list($row1, $col1, $row2, $col2) = $this->rangeToPackedRange($cell1 . ':' . $cell2);
         }
 
         // The ptg value depends on the class of the ptg.
         $ptgArea = pack('C', $this->ptg['ptgArea3d']);
 
-        return $ptgArea.$ext_ref.$row1.$row2.$col1.$col2;
+        return $ptgArea . $ext_ref . $row1 . $row2 . $col1 . $col2;
     }
 
     /**
@@ -699,7 +699,7 @@ 
         // The ptg value depends on the class of the ptg.
         $ptgRef = pack('C', $this->ptg['ptgRefA']);
 
-        return $ptgRef.$row.$col;
+        return $ptgRef . $row . $col;
     }
 
     /**
@@ -724,7 +724,7 @@ 
         // The ptg value depends on the class of the ptg.
         $ptgRef = pack('C', $this->ptg['ptgRef3dA']);
 
-        return $ptgRef.$ext_ref.$row.$col;
+        return $ptgRef . $ext_ref . $row . $col;
     }
 
     /**
@@ -1086,22 +1086,22 @@ 
                 // if it's a reference A1 or $A$1 or $A1 or A$1
                 if (preg_match('/^\$?[A-Ia-i]?[A-Za-z]\$?[0-9]+$/', $token) and !preg_match('/[0-9]/', $this->lookAhead) and ($this->lookAhead != ':') and ($this->lookAhead != '.') and ($this->lookAhead != '!')) {
                     return $token;
-                } elseif (preg_match('/^'.self::REGEX_SHEET_TITLE_UNQUOTED."(\:".self::REGEX_SHEET_TITLE_UNQUOTED.")?\!\\$?[A-Ia-i]?[A-Za-z]\\$?[0-9]+$/u", $token) and !preg_match('/[0-9]/', $this->lookAhead) and ($this->lookAhead != ':') and ($this->lookAhead != '.')) {
+                } elseif (preg_match('/^' . self::REGEX_SHEET_TITLE_UNQUOTED . "(\:" . self::REGEX_SHEET_TITLE_UNQUOTED . ")?\!\\$?[A-Ia-i]?[A-Za-z]\\$?[0-9]+$/u", $token) and !preg_match('/[0-9]/', $this->lookAhead) and ($this->lookAhead != ':') and ($this->lookAhead != '.')) {
                     // If it's an external reference (Sheet1!A1 or Sheet1:Sheet2!A1 or Sheet1!$A$1 or Sheet1:Sheet2!$A$1)
                     return $token;
-                } elseif (preg_match("/^'".self::REGEX_SHEET_TITLE_QUOTED."(\:".self::REGEX_SHEET_TITLE_QUOTED.")?'\!\\$?[A-Ia-i]?[A-Za-z]\\$?[0-9]+$/u", $token) and !preg_match('/[0-9]/', $this->lookAhead) and ($this->lookAhead != ':') and ($this->lookAhead != '.')) {
+                } elseif (preg_match("/^'" . self::REGEX_SHEET_TITLE_QUOTED . "(\:" . self::REGEX_SHEET_TITLE_QUOTED . ")?'\!\\$?[A-Ia-i]?[A-Za-z]\\$?[0-9]+$/u", $token) and !preg_match('/[0-9]/', $this->lookAhead) and ($this->lookAhead != ':') and ($this->lookAhead != '.')) {
                     // If it's an external reference ('Sheet1'!A1 or 'Sheet1:Sheet2'!A1 or 'Sheet1'!$A$1 or 'Sheet1:Sheet2'!$A$1)
                     return $token;
                 } elseif (preg_match('/^(\$)?[A-Ia-i]?[A-Za-z](\$)?[0-9]+:(\$)?[A-Ia-i]?[A-Za-z](\$)?[0-9]+$/', $token) && !preg_match('/[0-9]/', $this->lookAhead)) {
                     // if it's a range A1:A2 or $A$1:$A$2
                     return $token;
-                } elseif (preg_match('/^'.self::REGEX_SHEET_TITLE_UNQUOTED."(\:".self::REGEX_SHEET_TITLE_UNQUOTED.")?\!\\$?([A-Ia-i]?[A-Za-z])?\\$?[0-9]+:\\$?([A-Ia-i]?[A-Za-z])?\\$?[0-9]+$/u", $token) and !preg_match('/[0-9]/', $this->lookAhead)) {
+                } elseif (preg_match('/^' . self::REGEX_SHEET_TITLE_UNQUOTED . "(\:" . self::REGEX_SHEET_TITLE_UNQUOTED . ")?\!\\$?([A-Ia-i]?[A-Za-z])?\\$?[0-9]+:\\$?([A-Ia-i]?[A-Za-z])?\\$?[0-9]+$/u", $token) and !preg_match('/[0-9]/', $this->lookAhead)) {
                     // If it's an external range like Sheet1!A1:B2 or Sheet1:Sheet2!A1:B2 or Sheet1!$A$1:$B$2 or Sheet1:Sheet2!$A$1:$B$2
                     return $token;
-                } elseif (preg_match("/^'".self::REGEX_SHEET_TITLE_QUOTED."(\:".self::REGEX_SHEET_TITLE_QUOTED.")?'\!\\$?([A-Ia-i]?[A-Za-z])?\\$?[0-9]+:\\$?([A-Ia-i]?[A-Za-z])?\\$?[0-9]+$/u", $token) and !preg_match('/[0-9]/', $this->lookAhead)) {
+                } elseif (preg_match("/^'" . self::REGEX_SHEET_TITLE_QUOTED . "(\:" . self::REGEX_SHEET_TITLE_QUOTED . ")?'\!\\$?([A-Ia-i]?[A-Za-z])?\\$?[0-9]+:\\$?([A-Ia-i]?[A-Za-z])?\\$?[0-9]+$/u", $token) and !preg_match('/[0-9]/', $this->lookAhead)) {
                     // If it's an external range like 'Sheet1'!A1:B2 or 'Sheet1:Sheet2'!A1:B2 or 'Sheet1'!$A$1:$B$2 or 'Sheet1:Sheet2'!$A$1:$B$2
                     return $token;
-                } elseif (is_numeric($token) and (!is_numeric($token.$this->lookAhead) or ($this->lookAhead == '')) and ($this->lookAhead != '!') and ($this->lookAhead != ':')) {
+                } elseif (is_numeric($token) and (!is_numeric($token . $this->lookAhead) or ($this->lookAhead == '')) and ($this->lookAhead != '!') and ($this->lookAhead != ':')) {
                     // If it's a number (check that it's not a sheet name or range)
                     return $token;
                 } elseif (preg_match('/"([^"]|""){0,255}"/', $token) and $this->lookAhead != '"' and (substr_count($token, '"') % 2 == 0)) {
@@ -1320,13 +1320,13 @@ 
             $this->advance();
 
             return $result;
-        } elseif (preg_match('/^'.self::REGEX_SHEET_TITLE_UNQUOTED."(\:".self::REGEX_SHEET_TITLE_UNQUOTED.")?\!\\$?[A-Ia-i]?[A-Za-z]\\$?[0-9]+$/u", $this->currentToken)) {
+        } elseif (preg_match('/^' . self::REGEX_SHEET_TITLE_UNQUOTED . "(\:" . self::REGEX_SHEET_TITLE_UNQUOTED . ")?\!\\$?[A-Ia-i]?[A-Za-z]\\$?[0-9]+$/u", $this->currentToken)) {
             // If it's an external reference (Sheet1!A1 or Sheet1:Sheet2!A1 or Sheet1!$A$1 or Sheet1:Sheet2!$A$1)
             $result = $this->createTree($this->currentToken, '', '');
             $this->advance();
 
             return $result;
-        } elseif (preg_match("/^'".self::REGEX_SHEET_TITLE_QUOTED."(\:".self::REGEX_SHEET_TITLE_QUOTED.")?'\!\\$?[A-Ia-i]?[A-Za-z]\\$?[0-9]+$/u", $this->currentToken)) {
+        } elseif (preg_match("/^'" . self::REGEX_SHEET_TITLE_QUOTED . "(\:" . self::REGEX_SHEET_TITLE_QUOTED . ")?'\!\\$?[A-Ia-i]?[A-Za-z]\\$?[0-9]+$/u", $this->currentToken)) {
             // If it's an external reference ('Sheet1'!A1 or 'Sheet1:Sheet2'!A1 or 'Sheet1'!$A$1 or 'Sheet1:Sheet2'!$A$1)
             $result = $this->createTree($this->currentToken, '', '');
             $this->advance();
@@ -1340,14 +1340,14 @@ 
             $this->advance();
 
             return $result;
-        } elseif (preg_match('/^'.self::REGEX_SHEET_TITLE_UNQUOTED."(\:".self::REGEX_SHEET_TITLE_UNQUOTED.")?\!\\$?([A-Ia-i]?[A-Za-z])?\\$?[0-9]+:\\$?([A-Ia-i]?[A-Za-z])?\\$?[0-9]+$/u", $this->currentToken)) {
+        } elseif (preg_match('/^' . self::REGEX_SHEET_TITLE_UNQUOTED . "(\:" . self::REGEX_SHEET_TITLE_UNQUOTED . ")?\!\\$?([A-Ia-i]?[A-Za-z])?\\$?[0-9]+:\\$?([A-Ia-i]?[A-Za-z])?\\$?[0-9]+$/u", $this->currentToken)) {
             // If it's an external range (Sheet1!A1:B2 or Sheet1:Sheet2!A1:B2 or Sheet1!$A$1:$B$2 or Sheet1:Sheet2!$A$1:$B$2)
             // must be an error?
             $result = $this->createTree($this->currentToken, '', '');
             $this->advance();
 
             return $result;
-        } elseif (preg_match("/^'".self::REGEX_SHEET_TITLE_QUOTED."(\:".self::REGEX_SHEET_TITLE_QUOTED.")?'\!\\$?([A-Ia-i]?[A-Za-z])?\\$?[0-9]+:\\$?([A-Ia-i]?[A-Za-z])?\\$?[0-9]+$/u", $this->currentToken)) {
+        } elseif (preg_match("/^'" . self::REGEX_SHEET_TITLE_QUOTED . "(\:" . self::REGEX_SHEET_TITLE_QUOTED . ")?'\!\\$?([A-Ia-i]?[A-Za-z])?\\$?[0-9]+:\\$?([A-Ia-i]?[A-Za-z])?\\$?[0-9]+$/u", $this->currentToken)) {
             // If it's an external range ('Sheet1'!A1:B2 or 'Sheet1'!A1:B2 or 'Sheet1'!$A$1:$B$2 or 'Sheet1'!$A$1:$B$2)
             // must be an error?
             $result = $this->createTree($this->currentToken, '', '');
@@ -1371,7 +1371,7 @@ 
 
             return $result;
         }
-        throw new \PhpOffice\PhpSpreadsheet\Writer\WriteException('Syntax error: '.$this->currentToken.', lookahead: '.$this->lookAhead.', current char: '.$this->currentCharacter);
+        throw new \PhpOffice\PhpSpreadsheet\Writer\WriteException('Syntax error: ' . $this->currentToken . ', lookahead: ' . $this->lookAhead . ', current char: ' . $this->currentCharacter);
     }
 
     /**
@@ -1492,7 +1492,7 @@ 
                 $left_tree = '';
             }
             // add it's left subtree and return.
-            return $left_tree.$this->convertFunction($tree['value'], $tree['right']);
+            return $left_tree . $this->convertFunction($tree['value'], $tree['right']);
         } else {
             $converted_tree = $this->convert($tree['value']);
         }

src/PhpSpreadsheet/Writer/Xls/Escher.php

Spacing +12 added lines, -12 removed lines

@@ -116,7 +116,7 @@ 
                 }
 
                 $header = pack('vvV', $recVerInstance, $recType, strlen($dggData));
-                $innerData .= $header.$dggData;
+                $innerData .= $header . $dggData;
 
                 // write the bstoreContainer
                 if ($bstoreContainer = $this->object->getBstoreContainer()) {
@@ -135,7 +135,7 @@ 
 
                 $header = pack('vvV', $recVerInstance, $recType, $length);
 
-                $this->data = $header.$innerData;
+                $this->data = $header . $innerData;
                 break;
             case '\\PhpOffice\\PhpSpreadsheet\\Shared\\Escher\\DggContainer\\BstoreContainer':
                 // this is a container record
@@ -162,7 +162,7 @@ 
 
                 $header = pack('vvV', $recVerInstance, $recType, $length);
 
-                $this->data = $header.$innerData;
+                $this->data = $header . $innerData;
                 break;
             case '\\PhpOffice\\PhpSpreadsheet\\Shared\\Escher\\DggContainer\\BstoreContainer\\BSE':
                 // this is a semi-container record
@@ -292,7 +292,7 @@ 
 
                 // number of shapes in this drawing (including group shape)
                 $countShapes = count($this->object->getSpgrContainer()->getChildren());
-                $innerData .= $header.pack('VV', $countShapes, $this->object->getLastSpId());
+                $innerData .= $header . pack('VV', $countShapes, $this->object->getLastSpId());
 
                 // write the spgrContainer
                 if ($spgrContainer = $this->object->getSpgrContainer()) {
@@ -323,7 +323,7 @@ 
 
                 $header = pack('vvV', $recVerInstance, $recType, $length);
 
-                $this->data = $header.$innerData;
+                $this->data = $header . $innerData;
                 break;
             case '\\PhpOffice\\PhpSpreadsheet\\Shared\\Escher\\DgContainer\\SpgrContainer':
                 // this is a container record
@@ -360,7 +360,7 @@ 
 
                 $header = pack('vvV', $recVerInstance, $recType, $length);
 
-                $this->data = $header.$innerData;
+                $this->data = $header . $innerData;
                 $this->spOffsets = $spOffsets;
                 $this->spTypes = $spTypes;
                 break;
@@ -382,7 +382,7 @@ 
 
                     $header = pack('vvV', $recVerInstance, $recType, $length);
 
-                    $data .= $header.pack('VVVV', 0, 0, 0, 0);
+                    $data .= $header . pack('VVVV', 0, 0, 0, 0);
                 }
                 $this->spTypes[] = ($this->object->getSpType());
 
@@ -397,7 +397,7 @@ 
 
                 $header = pack('vvV', $recVerInstance, $recType, $length);
 
-                $data .= $header.pack('VV', $this->object->getSpId(), $this->object->getSpgr() ? 0x0005 : 0x0A00);
+                $data .= $header . pack('VV', $this->object->getSpId(), $this->object->getSpgr() ? 0x0005 : 0x0A00);
 
                 // the options
                 if ($this->object->getOPTCollection()) {
@@ -415,7 +415,7 @@ 
                     $recVerInstance |= $recInstance << 4;
 
                     $header = pack('vvV', $recVerInstance, $recType, $length);
-                    $data .= $header.$optData;
+                    $data .= $header . $optData;
                 }
 
                 // the client anchor
@@ -456,7 +456,7 @@ 
                     $recVerInstance |= $recInstance << 4;
 
                     $header = pack('vvV', $recVerInstance, $recType, $length);
-                    $data .= $header.$clientAnchorData;
+                    $data .= $header . $clientAnchorData;
                 }
 
                 // the client data, just empty for now
@@ -473,7 +473,7 @@ 
                     $recVerInstance |= $recInstance << 4;
 
                     $header = pack('vvV', $recVerInstance, $recType, $length);
-                    $data .= $header.$clientDataData;
+                    $data .= $header . $clientDataData;
                 }
 
                 // write the record
@@ -487,7 +487,7 @@ 
 
                 $header = pack('vvV', $recVerInstance, $recType, $length);
 
-                $this->data = $header.$data;
+                $this->data = $header . $data;
                 break;
         }
 

src/PhpSpreadsheet/Writer/Xls/Xf.php

Spacing +1 added lines, -1 removed lines

@@ -258,7 +258,7 @@
         $data .= pack('CCC', self::mapTextRotation($this->_style->getAlignment()->getTextRotation()), $biff8_options, $used_attrib);
         $data .= pack('VVv', $border1, $border2, $icv);
 
-        return $header.$data;
+        return $header . $data;
     }
 
     /**

src/PhpSpreadsheet/Writer/Xls/Font.php

Spacing +6 added lines, -6 removed lines

@@ -84,9 +84,9 @@ 
         $bFamily = 0; // Font family
         $bCharSet = \PhpOffice\PhpSpreadsheet\Shared\Font::getCharsetFromFontName($this->font->getName()); // Character set
 
-        $record = 0x31;        // Record identifier
-        $reserved = 0x00;    // Reserved
-        $grbit = 0x00;        // Font attributes
+        $record = 0x31; // Record identifier
+        $reserved = 0x00; // Reserved
+        $grbit = 0x00; // Font attributes
         if ($this->font->getItalic()) {
             $grbit |= 0x02;
         }
@@ -121,7 +121,7 @@ 
         $length = strlen($data);
         $header = pack('vv', $record, $length);
 
-        return $header.$data;
+        return $header . $data;
     }
 
     /**
@@ -134,10 +134,10 @@ 
     private static function mapBold($bold)
     {
         if ($bold) {
-            return 0x2BC;  //  700 = Bold font weight
+            return 0x2BC; //  700 = Bold font weight
         }
 
-        return 0x190;      //  400 = Normal font weight
+        return 0x190; //  400 = Normal font weight
     }
 
     /**

src/PhpSpreadsheet/Writer/Xlsx/Workbook.php

Spacing +6 added lines, -6 removed lines

@@ -253,7 +253,7 @@ 
             if ($sheetState != 'visible' && $sheetState != '') {
                 $objWriter->writeAttribute('state', $sheetState);
             }
-            $objWriter->writeAttribute('r:id', 'rId'.$pRelId);
+            $objWriter->writeAttribute('r:id', 'rId' . $pRelId);
             $objWriter->endElement();
         } else {
             throw new \PhpOffice\PhpSpreadsheet\Writer\WriteException('Invalid parameters passed.');
@@ -332,7 +332,7 @@ 
         // Create absolute coordinate and write as raw text
         $range = \PhpOffice\PhpSpreadsheet\Cell::splitRange($pNamedRange->getRange());
         for ($i = 0; $i < count($range); ++$i) {
-            $range[$i][0] = '\''.str_replace("'", "''", $pNamedRange->getWorksheet()->getTitle()).'\'!'.\PhpOffice\PhpSpreadsheet\Cell::absoluteReference($range[$i][0]);
+            $range[$i][0] = '\'' . str_replace("'", "''", $pNamedRange->getWorksheet()->getTitle()) . '\'!' . \PhpOffice\PhpSpreadsheet\Cell::absoluteReference($range[$i][0]);
             if (isset($range[$i][1])) {
                 $range[$i][1] = \PhpOffice\PhpSpreadsheet\Cell::absoluteReference($range[$i][1]);
             }
@@ -375,7 +375,7 @@ 
             $range[1] = \PhpOffice\PhpSpreadsheet\Cell::absoluteCoordinate($range[1]);
             $range = implode(':', $range);
 
-            $objWriter->writeRawData('\''.str_replace("'", "''", $pSheet->getTitle()).'\'!'.$range);
+            $objWriter->writeRawData('\'' . str_replace("'", "''", $pSheet->getTitle()) . '\'!' . $range);
 
             $objWriter->endElement();
         }
@@ -405,7 +405,7 @@ 
             if ($pSheet->getPageSetup()->isColumnsToRepeatAtLeftSet()) {
                 $repeat = $pSheet->getPageSetup()->getColumnsToRepeatAtLeft();
 
-                $settingString .= '\''.str_replace("'", "''", $pSheet->getTitle()).'\'!$'.$repeat[0].':$'.$repeat[1];
+                $settingString .= '\'' . str_replace("'", "''", $pSheet->getTitle()) . '\'!$' . $repeat[0] . ':$' . $repeat[1];
             }
 
             // Rows to repeat
@@ -416,7 +416,7 @@ 
 
                 $repeat = $pSheet->getPageSetup()->getRowsToRepeatAtTop();
 
-                $settingString .= '\''.str_replace("'", "''", $pSheet->getTitle()).'\'!$'.$repeat[0].':$'.$repeat[1];
+                $settingString .= '\'' . str_replace("'", "''", $pSheet->getTitle()) . '\'!$' . $repeat[0] . ':$' . $repeat[1];
             }
 
             $objWriter->writeRawData($settingString);
@@ -452,7 +452,7 @@ 
             foreach ($printArea as $printAreaRect) {
                 $printAreaRect[0] = \PhpOffice\PhpSpreadsheet\Cell::absoluteReference($printAreaRect[0]);
                 $printAreaRect[1] = \PhpOffice\PhpSpreadsheet\Cell::absoluteReference($printAreaRect[1]);
-                $chunks[] = '\''.str_replace("'", "''", $pSheet->getTitle()).'\'!'.implode(':', $printAreaRect);
+                $chunks[] = '\'' . str_replace("'", "''", $pSheet->getTitle()) . '\'!' . implode(':', $printAreaRect);
             }
 
             $objWriter->writeRawData(implode(',', $chunks));

src/PhpSpreadsheet/Writer/Xlsx/Chart.php

Spacing +5 added lines, -5 removed lines

@@ -246,7 +246,7 @@ 
         $catIsMultiLevelSeries = $valIsMultiLevelSeries = false;
         $plotGroupingType = '';
         foreach ($chartTypes as $chartType) {
-            $objWriter->startElement('c:'.$chartType);
+            $objWriter->startElement('c:' . $chartType);
 
             $groupCount = $plotArea->getPlotGroupCount();
             for ($i = 0; $i < $groupCount; ++$i) {
@@ -847,7 +847,7 @@ 
 
         if (!is_null($xAxis->getFillProperty('value'))) {
             $objWriter->startElement('a:solidFill');
-            $objWriter->startElement('a:'.$xAxis->getFillProperty('type'));
+            $objWriter->startElement('a:' . $xAxis->getFillProperty('type'));
             $objWriter->writeAttribute('val', $xAxis->getFillProperty('value'));
             $objWriter->startElement('a:alpha');
             $objWriter->writeAttribute('val', $xAxis->getFillProperty('alpha'));
@@ -864,7 +864,7 @@ 
 
         if (!is_null($xAxis->getLineProperty('value'))) {
             $objWriter->startElement('a:solidFill');
-            $objWriter->startElement('a:'.$xAxis->getLineProperty('type'));
+            $objWriter->startElement('a:' . $xAxis->getLineProperty('type'));
             $objWriter->writeAttribute('val', $xAxis->getLineProperty('value'));
             $objWriter->startElement('a:alpha');
             $objWriter->writeAttribute('val', $xAxis->getLineProperty('alpha'));
@@ -1304,13 +1304,13 @@ 
 
             $objWriter->endElement();
         } else {
-            $objWriter->startElement('c:'.$dataType.'Ref');
+            $objWriter->startElement('c:' . $dataType . 'Ref');
 
             $objWriter->startElement('c:f');
             $objWriter->writeRawData($plotSeriesValues->getDataSource());
             $objWriter->endElement();
 
-            $objWriter->startElement('c:'.$dataType.'Cache');
+            $objWriter->startElement('c:' . $dataType . 'Cache');
 
             if (($groupType != DataSeries::TYPE_PIECHART) && ($groupType != DataSeries::TYPE_PIECHART_3D) && ($groupType != DataSeries::TYPE_DONUTCHART)) {
                 if (($plotSeriesValues->getFormatCode() !== null) && ($plotSeriesValues->getFormatCode() !== '')) {

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