Dolibarr / dolibarr

htdocs/includes/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Shared/OLERead.php

Spacing +4 added lines, -4 removed lines

@@ -108,7 +108,7 @@ 
         // Check OLE identifier
         $identifierOle = pack('CCCCCCCC', 0xd0, 0xcf, 0x11, 0xe0, 0xa1, 0xb1, 0x1a, 0xe1);
         if ($this->data != $identifierOle) {
-            throw new ReaderException('The filename ' . $pFilename . ' is not recognised as an OLE file');
+            throw new ReaderException('The filename '.$pFilename.' is not recognised as an OLE file');
         }
 
         // Get the file data
@@ -303,12 +303,12 @@ 
             }
 
             // Summary information
-            if ($name == chr(5) . 'SummaryInformation') {
+            if ($name == chr(5).'SummaryInformation') {
                 $this->summaryInformation = count($this->props) - 1;
             }
 
             // Additional Document Summary information
-            if ($name == chr(5) . 'DocumentSummaryInformation') {
+            if ($name == chr(5).'DocumentSummaryInformation') {
                 $this->documentSummaryInformation = count($this->props) - 1;
             }
 
@@ -328,7 +328,7 @@ 
     {
         if ($pos < 0) {
             // Invalid position
-            throw new ReaderException('Parameter pos=' . $pos . ' is invalid.');
+            throw new ReaderException('Parameter pos='.$pos.' is invalid.');
         }
 
         $len = strlen($data);

htdocs/includes/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Shared/Font.php

Spacing +2 added lines, -2 removed lines

@@ -506,12 +506,12 @@
 
                 break;
             default:
-                throw new PhpSpreadsheetException('Unknown font name "' . $name . '". Cannot map to TrueType font file');
+                throw new PhpSpreadsheetException('Unknown font name "'.$name.'". Cannot map to TrueType font file');
 
                 break;
         }
 
-        $fontFile = self::$trueTypeFontPath . $fontFile;
+        $fontFile = self::$trueTypeFontPath.$fontFile;
 
         // Check if file actually exists
         if (!file_exists($fontFile)) {

htdocs/includes/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Writer/Xls/Workbook.php

Spacing +20 added lines, -20 removed lines

@@ -541,7 +541,7 @@ 
                 $range = Coordinate::splitRange($namedRange->getRange());
                 $iMax = count($range);
                 for ($i = 0; $i < $iMax; ++$i) {
-                    $range[$i][0] = '\'' . str_replace("'", "''", $namedRange->getWorksheet()->getTitle()) . '\'!' . Coordinate::absoluteCoordinate($range[$i][0]);
+                    $range[$i][0] = '\''.str_replace("'", "''", $namedRange->getWorksheet()->getTitle()).'\'!'.Coordinate::absoluteCoordinate($range[$i][0]);
                     if (isset($range[$i][1])) {
                         $range[$i][1] = Coordinate::absoluteCoordinate($range[$i][1]);
                     }
@@ -555,7 +555,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()) {
@@ -703,12 +703,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;
     }
 
     /**
@@ -743,12 +743,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;
     }
 
     /**
@@ -763,7 +763,7 @@ 
         $header = pack('vv', $record, $length);
         $data = pack('v', $cv);
 
-        $this->append($header . $data);
+        $this->append($header.$data);
     }
 
     /**
@@ -792,7 +792,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);
     }
 
     /**
@@ -836,7 +836,7 @@ 
 
         $length = strlen($data);
         $header = pack('vv', $record, $length);
-        $this->append($header . $data);
+        $this->append($header.$data);
     }
 
     /**
@@ -850,7 +850,7 @@ 
         $header = pack('vv', $record, $length);
         $data = pack('vv', $this->spreadsheet->getSheetCount(), 0x0401);
 
-        return $this->writeData($header . $data);
+        return $this->writeData($header.$data);
     }
 
     /**
@@ -870,7 +870,7 @@ 
             $data .= $this->parser->references[$i];
         }
 
-        return $this->writeData($header . $data);
+        return $this->writeData($header.$data);
     }
 
     /**
@@ -887,7 +887,7 @@ 
 
         $header = pack('vv', $record, $length);
         $data = pack('vCC', $ixfe, $BuiltIn, $iLevel);
-        $this->append($header . $data);
+        $this->append($header.$data);
     }
 
     /**
@@ -904,8 +904,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);
     }
 
     /**
@@ -922,7 +922,7 @@ 
 
         $header = pack('vv', $record, $length);
         $data = pack('v', $f1904);
-        $this->append($header . $data);
+        $this->append($header.$data);
     }
 
     /**
@@ -939,7 +939,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);
     }
 
     /**
@@ -957,7 +957,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);
     }
 
     /**
@@ -980,7 +980,7 @@ 
         }
 
         $header = pack('vvv', $record, $length, $ccv);
-        $this->append($header . $data);
+        $this->append($header.$data);
     }
 
     /**
@@ -1100,7 +1100,7 @@ 
             $record = ($i == 0) ? 0x00FC : 0x003C;
 
             $header = pack('vv', $record, strlen($recordData));
-            $data = $header . $recordData;
+            $data = $header.$recordData;
 
             $chunk .= $this->writeData($data);
         }
@@ -1122,7 +1122,7 @@ 
             $length = strlen($data);
             $header = pack('vv', $record, $length);
 
-            return $this->writeData($header . $data);
+            return $this->writeData($header.$data);
         }
 
         return '';

htdocs/includes/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Writer/Xls/Escher.php

Spacing +12 added lines, -12 removed lines

@@ -102,7 +102,7 @@ 
                 }
 
                 $header = pack('vvV', $recVerInstance, $recType, strlen($dggData));
-                $innerData .= $header . $dggData;
+                $innerData .= $header.$dggData;
 
                 // write the bstoreContainer
                 if ($bstoreContainer = $this->object->getBstoreContainer()) {
@@ -121,7 +121,7 @@ 
 
                 $header = pack('vvV', $recVerInstance, $recType, $length);
 
-                $this->data = $header . $innerData;
+                $this->data = $header.$innerData;
 
                 break;
             case BstoreContainer::class:
@@ -149,7 +149,7 @@ 
 
                 $header = pack('vvV', $recVerInstance, $recType, $length);
 
-                $this->data = $header . $innerData;
+                $this->data = $header.$innerData;
 
                 break;
             case BSE::class:
@@ -283,7 +283,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()) {
@@ -314,7 +314,7 @@ 
 
                 $header = pack('vvV', $recVerInstance, $recType, $length);
 
-                $this->data = $header . $innerData;
+                $this->data = $header.$innerData;
 
                 break;
             case SpgrContainer::class:
@@ -352,7 +352,7 @@ 
 
                 $header = pack('vvV', $recVerInstance, $recType, $length);
 
-                $this->data = $header . $innerData;
+                $this->data = $header.$innerData;
                 $this->spOffsets = $spOffsets;
                 $this->spTypes = $spTypes;
 
@@ -375,7 +375,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());
 
@@ -390,7 +390,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()) {
@@ -408,7 +408,7 @@ 
                     $recVerInstance |= $recInstance << 4;
 
                     $header = pack('vvV', $recVerInstance, $recType, $length);
-                    $data .= $header . $optData;
+                    $data .= $header.$optData;
                 }
 
                 // the client anchor
@@ -449,7 +449,7 @@ 
                     $recVerInstance |= $recInstance << 4;
 
                     $header = pack('vvV', $recVerInstance, $recType, $length);
-                    $data .= $header . $clientAnchorData;
+                    $data .= $header.$clientAnchorData;
                 }
 
                 // the client data, just empty for now
@@ -466,7 +466,7 @@ 
                     $recVerInstance |= $recInstance << 4;
 
                     $header = pack('vvV', $recVerInstance, $recType, $length);
-                    $data .= $header . $clientDataData;
+                    $data .= $header.$clientDataData;
                 }
 
                 // write the record
@@ -480,7 +480,7 @@ 
 
                 $header = pack('vvV', $recVerInstance, $recType, $length);
 
-                $this->data = $header . $data;
+                $this->data = $header.$data;
 
                 break;
         }

htdocs/includes/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Writer/Xls/Parser.php

Spacing +22 added lines, -22 removed lines

@@ -498,19 +498,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])) {
@@ -569,7 +569,7 @@ 
             throw new WriterException('String is too long');
         }
 
-        return pack('C', $this->ptg['ptgStr']) . StringHelper::UTF8toBIFF8UnicodeShort($string);
+        return pack('C', $this->ptg['ptgStr']).StringHelper::UTF8toBIFF8UnicodeShort($string);
     }
 
     /**
@@ -630,7 +630,7 @@ 
             throw new WriterException("Unknown class $class");
         }
 
-        return $ptgArea . $row1 . $row2 . $col1 . $col2;
+        return $ptgArea.$row1.$row2.$col1.$col2;
     }
 
     /**
@@ -657,13 +657,13 @@ 
             [$row1, $col1] = $this->cellToPackedRowcol($cell1);
             [$row2, $col2] = $this->cellToPackedRowcol($cell2);
         } else { // It's a rows range (like 26:27)
-            [$row1, $col1, $row2, $col2] = $this->rangeToPackedRange($cell1 . ':' . $cell2);
+            [$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;
     }
 
     /**
@@ -682,7 +682,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;
     }
 
     /**
@@ -707,7 +707,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;
     }
 
     /**
@@ -1029,22 +1029,22 @@ 
                 // if it's a reference A1 or $A$1 or $A1 or A$1
                 if (preg_match('/^\$?[A-Ia-i]?[A-Za-z]\$?\d+$/', $token) and !preg_match('/\d/', $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]\$?\\d+$/u', $token) and !preg_match('/\d/', $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]\$?\\d+$/u', $token) and !preg_match('/\d/', $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]\\$?\\d+$/u", $token) and !preg_match('/\d/', $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]\\$?\\d+$/u", $token) and !preg_match('/\d/', $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](\$)?\d+:(\$)?[A-Ia-i]?[A-Za-z](\$)?\d+$/', $token) && !preg_match('/\d/', $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])?\$?\\d+:\$?([A-Ia-i]?[A-Za-z])?\$?\\d+$/u', $token) and !preg_match('/\d/', $this->lookAhead)) {
+                } 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) and !preg_match('/\d/', $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])?\\$?\\d+:\\$?([A-Ia-i]?[A-Za-z])?\\$?\\d+$/u", $token) and !preg_match('/\d/', $this->lookAhead)) {
+                } 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) and !preg_match('/\d/', $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)) {
@@ -1258,13 +1258,13 @@ 
             $this->advance();
 
             return $result;
-        } elseif (preg_match('/^' . self::REGEX_SHEET_TITLE_UNQUOTED . '(\\:' . self::REGEX_SHEET_TITLE_UNQUOTED . ')?\\!\$?[A-Ia-i]?[A-Za-z]\$?\\d+$/u', $this->currentToken)) {
+        } elseif (preg_match('/^'.self::REGEX_SHEET_TITLE_UNQUOTED.'(\\:'.self::REGEX_SHEET_TITLE_UNQUOTED.')?\\!\$?[A-Ia-i]?[A-Za-z]\$?\\d+$/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]\\$?\\d+$/u", $this->currentToken)) {
+        } elseif (preg_match("/^'".self::REGEX_SHEET_TITLE_QUOTED.'(\\:'.self::REGEX_SHEET_TITLE_QUOTED.")?'\\!\\$?[A-Ia-i]?[A-Za-z]\\$?\\d+$/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();
@@ -1278,14 +1278,14 @@ 
             $this->advance();
 
             return $result;
-        } 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', $this->currentToken)) {
+        } 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', $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])?\\$?\\d+:\\$?([A-Ia-i]?[A-Za-z])?\\$?\\d+$/u", $this->currentToken)) {
+        } 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", $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, '', '');
@@ -1308,7 +1308,7 @@ 
             return $this->func();
         }
 
-        throw new WriterException('Syntax error: ' . $this->currentToken . ', lookahead: ' . $this->lookAhead . ', current char: ' . $this->currentCharacter);
+        throw new WriterException('Syntax error: '.$this->currentToken.', lookahead: '.$this->lookAhead.', current char: '.$this->currentCharacter);
     }
 
     /**
@@ -1429,10 +1429,10 @@ 
                 $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']);
         }
         $converted_tree = $this->convert($tree['value']);
 
-        return $polish . $converted_tree;
+        return $polish.$converted_tree;
     }
 }

htdocs/includes/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Writer/Xls/Xf.php

Spacing +1 added lines, -1 removed lines

@@ -240,7 +240,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;
     }
 
     /**

htdocs/includes/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Writer/Xls/BIFFwriter.php

Spacing +2 added lines, -2 removed lines

@@ -157,7 +157,7 @@ 
 
         $header = pack('vv', $record, $length);
         $data = pack('vvvv', $version, $type, $build, $year);
-        $this->append($header . $data . $unknown);
+        $this->append($header.$data.$unknown);
     }
 
     /**
@@ -203,7 +203,7 @@ 
 
         // The first 2080/8224 bytes remain intact. However, we have to change
         // the length field of the record.
-        $tmp = substr($data, 0, 2) . pack('v', $limit) . substr($data, 4, $limit);
+        $tmp = substr($data, 0, 2).pack('v', $limit).substr($data, 4, $limit);
 
         $header = pack('vv', $record, $limit); // Headers for continue records
 

htdocs/includes/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Writer/Xls/Worksheet.php

Spacing +70 added lines, -70 removed lines

@@ -522,7 +522,7 @@ 
                 // URL
             } else {
                 // external (local file)
-                $url = 'external:' . $url;
+                $url = 'external:'.$url;
             }
 
             $this->writeUrl($row - 1, Coordinate::columnIndexFromString($column) - 1, $url);
@@ -670,7 +670,7 @@ 
             $xl_double = strrev($xl_double);
         }
 
-        $this->append($header . $data . $xl_double);
+        $this->append($header.$data.$xl_double);
 
         return 0;
     }
@@ -712,7 +712,7 @@ 
 
         $header = pack('vv', $record, $length);
         $data = pack('vvvV', $row, $col, $xfIndex, $this->stringTable[$str]);
-        $this->append($header . $data);
+        $this->append($header.$data);
     }
 
     /**
@@ -740,7 +740,7 @@ 
 
         $header = pack('vv', $record, $length);
         $data = pack('vvvV', $row, $col, $xfIndex, $this->stringTable[$str]);
-        $this->append($header . $data);
+        $this->append($header.$data);
     }
 
     /**
@@ -768,7 +768,7 @@ 
 
         $header = pack('vv', $record, $length);
         $data = pack('vvv', $row, $col, $xfIndex);
-        $this->append($header . $data);
+        $this->append($header.$data);
 
         return 0;
     }
@@ -791,7 +791,7 @@ 
 
         $header = pack('vv', $record, $length);
         $data = pack('vvvCC', $row, $col, $xfIndex, $value, $isError);
-        $this->append($header . $data);
+        $this->append($header.$data);
 
         return 0;
     }
@@ -883,7 +883,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) {
@@ -909,7 +909,7 @@ 
         $length = strlen($data);
         $header = pack('vv', $record, $length);
 
-        $this->append($header . $data);
+        $this->append($header.$data);
     }
 
     /**
@@ -997,7 +997,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));
@@ -1010,7 +1010,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;
     }
@@ -1059,7 +1059,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;
     }
@@ -1124,10 +1124,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));
@@ -1141,14 +1141,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     .
@@ -1161,7 +1161,7 @@ 
         $header = pack('vv', $record, $length);
 
         // Write the packed data
-        $this->append($header . $data);
+        $this->append($header.$data);
 
         return 0;
     }
@@ -1219,7 +1219,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);
     }
 
     /**
@@ -1233,7 +1233,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);
     }
 
     /**
@@ -1285,7 +1285,7 @@ 
 
         $data .= pack('vvvvV', $rgbHdr, 0x0000, $zoom_factor_page_break, $zoom_factor_normal, 0x00000000);
 
-        $this->append($header . $data);
+        $this->append($header.$data);
     }
 
     /**
@@ -1307,7 +1307,7 @@ 
 
         $header = pack('vv', $record, $length);
         $data = pack('vv', 1, $defaultRowHeight);
-        $this->append($header . $data);
+        $this->append($header.$data);
     }
 
     /**
@@ -1322,7 +1322,7 @@ 
 
         $header = pack('vv', $record, $length);
         $data = pack('v', $defaultColWidth);
-        $this->append($header . $data);
+        $this->append($header.$data);
     }
 
     /**
@@ -1380,7 +1380,7 @@ 
 
         $header = pack('vv', $record, $length);
         $data = pack('vvvvvv', $colFirst, $colLast, $coldx, $ixfe, $grbit, $reserved);
-        $this->append($header . $data);
+        $this->append($header.$data);
     }
 
     /**
@@ -1440,7 +1440,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);
     }
 
     /**
@@ -1485,10 +1485,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 = '';
@@ -1521,7 +1521,7 @@ 
 
         $record = 0x0862; // Record identifier
         $header = pack('vv', $record, $length);
-        $this->append($header . $recordData);
+        $this->append($header.$recordData);
     }
 
     /**
@@ -1565,7 +1565,7 @@ 
         $length = strlen($recordData);
         $header = pack('vv', $record, $length);
 
-        $this->append($header . $recordData);
+        $this->append($header.$recordData);
     }
 
     /**
@@ -1606,13 +1606,13 @@ 
                 hexdec($password)
             );
 
-            $recordData .= StringHelper::UTF8toBIFF8UnicodeLong('p' . md5($recordData));
+            $recordData .= 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);
         }
     }
 
@@ -1700,7 +1700,7 @@ 
 
         $header = pack('vv', $record, $length);
         $data = pack('vvvvv', $x, $y, $rwTop, $colLeft, $pnnAct);
-        $this->append($header . $data);
+        $this->append($header.$data);
     }
 
     /**
@@ -1759,9 +1759,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);
     }
 
     /**
@@ -1785,7 +1785,7 @@ 
 
         $header = pack('vv', $record, $length);
 
-        $this->append($header . $recordData);
+        $this->append($header.$recordData);
     }
 
     /**
@@ -1809,7 +1809,7 @@ 
 
         $header = pack('vv', $record, $length);
 
-        $this->append($header . $recordData);
+        $this->append($header.$recordData);
     }
 
     /**
@@ -1825,7 +1825,7 @@ 
         $header = pack('vv', $record, $length);
         $data = pack('v', $fHCenter);
 
-        $this->append($header . $data);
+        $this->append($header.$data);
     }
 
     /**
@@ -1840,7 +1840,7 @@ 
 
         $header = pack('vv', $record, $length);
         $data = pack('v', $fVCenter);
-        $this->append($header . $data);
+        $this->append($header.$data);
     }
 
     /**
@@ -1859,7 +1859,7 @@ 
             $data = strrev($data);
         }
 
-        $this->append($header . $data);
+        $this->append($header.$data);
     }
 
     /**
@@ -1878,7 +1878,7 @@ 
             $data = strrev($data);
         }
 
-        $this->append($header . $data);
+        $this->append($header.$data);
     }
 
     /**
@@ -1897,7 +1897,7 @@ 
             $data = strrev($data);
         }
 
-        $this->append($header . $data);
+        $this->append($header.$data);
     }
 
     /**
@@ -1916,7 +1916,7 @@ 
             $data = strrev($data);
         }
 
-        $this->append($header . $data);
+        $this->append($header.$data);
     }
 
     /**
@@ -1931,7 +1931,7 @@ 
 
         $header = pack('vv', $record, $length);
         $data = pack('v', $fPrintRwCol);
-        $this->append($header . $data);
+        $this->append($header.$data);
     }
 
     /**
@@ -1947,7 +1947,7 @@ 
 
         $header = pack('vv', $record, $length);
         $data = pack('v', $fPrintGrid);
-        $this->append($header . $data);
+        $this->append($header.$data);
     }
 
     /**
@@ -1963,7 +1963,7 @@ 
 
         $header = pack('vv', $record, $length);
         $data = pack('v', $fGridSet);
-        $this->append($header . $data);
+        $this->append($header.$data);
     }
 
     /**
@@ -1979,7 +1979,7 @@ 
 
         $header = pack('vv', $record, $length);
         $data = pack('v', $iNumFilters);
-        $this->append($header . $data);
+        $this->append($header.$data);
     }
 
     /**
@@ -2026,7 +2026,7 @@ 
         $header = pack('vv', $record, $length);
         $data = pack('vvvv', $dxRwGut, $dxColGut, $maxRowOutlineLevel, $col_level);
 
-        $this->append($header . $data);
+        $this->append($header.$data);
     }
 
     /**
@@ -2062,7 +2062,7 @@ 
 
         $header = pack('vv', $record, $length);
         $data = pack('v', $grbit);
-        $this->append($header . $data);
+        $this->append($header.$data);
     }
 
     /**
@@ -2117,7 +2117,7 @@ 
                 $data .= pack('vvv', $hbreak, 0x0000, 0x00ff);
             }
 
-            $this->append($header . $data);
+            $this->append($header.$data);
         }
 
         // vertical page breaks
@@ -2144,7 +2144,7 @@ 
                 $data .= pack('vvv', $vbreak, 0x0000, 0xffff);
             }
 
-            $this->append($header . $data);
+            $this->append($header.$data);
         }
     }
 
@@ -2166,7 +2166,7 @@ 
         $header = pack('vv', $record, $length);
         $data = pack('v', $fLock);
 
-        $this->append($header . $data);
+        $this->append($header.$data);
     }
 
     /**
@@ -2190,7 +2190,7 @@ 
         $header = pack('vv', $record, $length);
         $data = pack('v', 1);
 
-        $this->append($header . $data);
+        $this->append($header.$data);
     }
 
     /**
@@ -2214,7 +2214,7 @@ 
         $header = pack('vv', $record, $length);
         $data = pack('v', 1);
 
-        $this->append($header . $data);
+        $this->append($header.$data);
     }
 
     /**
@@ -2235,7 +2235,7 @@ 
         $header = pack('vv', $record, $length);
         $data = pack('v', $wPassword);
 
-        $this->append($header . $data);
+        $this->append($header.$data);
     }
 
     /**
@@ -2269,7 +2269,7 @@ 
         $lcb = $size;
 
         $header = pack('vvvvV', $record, $length, $cf, $env, $lcb);
-        $this->append($header . $data);
+        $this->append($header.$data);
     }
 
     /**
@@ -2451,7 +2451,7 @@ 
         $data .= pack('v', $grbit2);
         $data .= pack('V', $Reserved5);
 
-        $this->append($header . $data);
+        $this->append($header.$data);
     }
 
     /**
@@ -2473,7 +2473,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);
@@ -2564,7 +2564,7 @@ 
 
         // Add the BITMAPCOREHEADER data
         $header = pack('Vvvvv', 0x000c, $width, $height, 0x01, 0x18);
-        $data = $header . $data;
+        $data = $header.$data;
 
         return [$width, $height, $size, $data];
     }
@@ -2585,7 +2585,7 @@ 
 
         $header = pack('vv', $record, $length);
         $data = pack('vv', $this->phpSheet->getSheetView()->getZoomScale(), 100);
-        $this->append($header . $data);
+        $this->append($header.$data);
     }
 
     /**
@@ -2634,7 +2634,7 @@ 
                 $length = strlen($dataChunk);
                 $header = pack('vv', $record, $length);
 
-                $this->append($header . $dataChunk);
+                $this->append($header.$dataChunk);
 
                 // OBJ record
                 $record = 0x005D; // record identifier
@@ -2688,7 +2688,7 @@ 
 
                 $length = strlen($objData);
                 $header = pack('vv', $record, $length);
-                $this->append($header . $objData);
+                $this->append($header.$objData);
             }
         }
     }
@@ -2714,7 +2714,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
@@ -2901,7 +2901,7 @@ 
                 $length = strlen($data);
                 $header = pack('vv', $record, $length);
 
-                $this->append($header . $data);
+                $this->append($header.$data);
             }
         }
     }
@@ -2963,7 +2963,7 @@ 
 
         $header = pack('vv', $record, $length);
         $data = pack('vvVVvv', $rt, $grbitFrt, 0x00000000, 0x00000000, $wScalvePLV, $grbit);
-        $this->append($header . $data);
+        $this->append($header.$data);
     }
 
     /**
@@ -4428,7 +4428,7 @@ 
             $data .= $operand2;
         }
         $header = pack('vv', $record, strlen($data));
-        $this->append($header . $data);
+        $this->append($header.$data);
     }
 
     /**
@@ -4479,6 +4479,6 @@ 
         $data .= $cellRange;
         $data .= pack('v', 0x0001);
         $data .= $cellRange;
-        $this->append($header . $data);
+        $this->append($header.$data);
     }
 }

htdocs/includes/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Writer/Xls/Font.php

Spacing +1 added lines, -1 removed lines

@@ -99,7 +99,7 @@
         $length = strlen($data);
         $header = pack('vv', $record, $length);
 
-        return $header . $data;
+        return $header.$data;
     }
 
     /**