Dolibarr / dolibarr

htdocs/includes/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Reader/Security/XmlScanner.php

Spacing +1 added lines, -1 removed lines

@@ -125,7 +125,7 @@
         $xml = $this->toUtf8($xml);
 
         // Don't rely purely on libxml_disable_entity_loader()
-        $pattern = '/\\0?' . implode('\\0?', str_split($this->pattern)) . '\\0?/';
+        $pattern = '/\\0?'.implode('\\0?', str_split($this->pattern)).'\\0?/';
 
         if (preg_match($pattern, $xml)) {
             throw new Reader\Exception('Detected use of ENTITY in XML, spreadsheet file load() aborted to prevent XXE/XEE attacks');

htdocs/includes/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Reader/Ods.php

Spacing +10 added lines, -10 removed lines

@@ -95,14 +95,14 @@ 
 
         $zip = new ZipArchive();
         if (!$zip->open($pFilename)) {
-            throw new Exception('Could not open ' . $pFilename . ' for reading! Error opening file.');
+            throw new Exception('Could not open '.$pFilename.' for reading! Error opening file.');
         }
 
         $worksheetNames = [];
 
         $xml = new XMLReader();
         $xml->xml(
-            $this->securityScanner->scanFile('zip://' . realpath($pFilename) . '#content.xml'),
+            $this->securityScanner->scanFile('zip://'.realpath($pFilename).'#content.xml'),
             null,
             Settings::getLibXmlLoaderOptions()
         );
@@ -151,12 +151,12 @@ 
 
         $zip = new ZipArchive();
         if (!$zip->open($pFilename)) {
-            throw new Exception('Could not open ' . $pFilename . ' for reading! Error opening file.');
+            throw new Exception('Could not open '.$pFilename.' for reading! Error opening file.');
         }
 
         $xml = new XMLReader();
         $xml->xml(
-            $this->securityScanner->scanFile('zip://' . realpath($pFilename) . '#content.xml'),
+            $this->securityScanner->scanFile('zip://'.realpath($pFilename).'#content.xml'),
             null,
             Settings::getLibXmlLoaderOptions()
         );
@@ -397,7 +397,7 @@ 
                                         $text = $this->scanElementForText($textNode->item(0));
 
                                         $spreadsheet->getActiveSheet()
-                                            ->getComment($columnID . $rowID)
+                                            ->getComment($columnID.$rowID)
                                             ->setText($this->parseRichText($text));
 //                                                                    ->setAuthor( $author )
                                     }
@@ -520,7 +520,7 @@ 
 
                                             $dataValue = Date::PHPToExcel(
                                                 strtotime(
-                                                    '01-01-1970 ' . implode(':', sscanf($timeValue, 'PT%dH%dM%dS'))
+                                                    '01-01-1970 '.implode(':', sscanf($timeValue, 'PT%dH%dM%dS'))
                                                 )
                                             );
                                             $formatting = NumberFormat::FORMAT_DATE_TIME4;
@@ -580,7 +580,7 @@ 
                                                 $rID = $rowID + $rowAdjust;
 
                                                 $cell = $spreadsheet->getActiveSheet()
-                                                    ->getCell($columnID . $rID);
+                                                    ->getCell($columnID.$rID);
 
                                                 // Set value
                                                 if ($hasCalculatedValue) {
@@ -596,12 +596,12 @@ 
                                                 // Set other properties
                                                 if ($formatting !== null) {
                                                     $spreadsheet->getActiveSheet()
-                                                        ->getStyle($columnID . $rID)
+                                                        ->getStyle($columnID.$rID)
                                                         ->getNumberFormat()
                                                         ->setFormatCode($formatting);
                                                 } else {
                                                     $spreadsheet->getActiveSheet()
-                                                        ->getStyle($columnID . $rID)
+                                                        ->getStyle($columnID.$rID)
                                                         ->getNumberFormat()
                                                         ->setFormatCode(NumberFormat::FORMAT_GENERAL);
                                                 }
@@ -636,7 +636,7 @@ 
                                             $rowTo = $rowTo + (int) $cellData->getAttributeNS($tableNs, 'number-rows-spanned') - 1;
                                         }
 
-                                        $cellRange = $columnID . $rowID . ':' . $columnTo . $rowTo;
+                                        $cellRange = $columnID.$rowID.':'.$columnTo.$rowTo;
                                         $spreadsheet->getActiveSheet()->mergeCells($cellRange);
                                     }
                                 }

htdocs/includes/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Reader/Html.php

Spacing +21 added lines, -21 removed lines

@@ -280,13 +280,13 @@ 
                 //    Only actually write it if there's content in the string
                 //    Write to worksheet to be done here...
                 //    ... we return the cell so we can mess about with styles more easily
-                $sheet->setCellValue($column . $row, $cellContent);
+                $sheet->setCellValue($column.$row, $cellContent);
                 $this->dataArray[$row][$column] = $cellContent;
             }
         } else {
             //    We have a Rich Text run
             //    TODO
-            $this->dataArray[$row][$column] = 'RICH TEXT: ' . $cellContent;
+            $this->dataArray[$row][$column] = 'RICH TEXT: '.$cellContent;
         }
         $cellContent = (string) '';
     }
@@ -340,7 +340,7 @@ 
                     case 'strong':
                     case 'b':
                         if (isset($attributeArray['class']) && $attributeArray['class'] === 'comment') {
-                            $sheet->getComment($column . $row)
+                            $sheet->getComment($column.$row)
                                 ->getText()
                                 ->createTextRun($child->textContent);
 
@@ -356,7 +356,7 @@ 
                         }
 
                         if (isset($this->formats[$child->nodeName])) {
-                            $sheet->getStyle($column . $row)->applyFromArray($this->formats[$child->nodeName]);
+                            $sheet->getStyle($column.$row)->applyFromArray($this->formats[$child->nodeName]);
                         }
 
                         break;
@@ -364,7 +364,7 @@ 
                         $this->flushCell($sheet, $column, $row, $cellContent);
                         ++$row;
                         if (isset($this->formats[$child->nodeName])) {
-                            $sheet->getStyle($column . $row)->applyFromArray($this->formats[$child->nodeName]);
+                            $sheet->getStyle($column.$row)->applyFromArray($this->formats[$child->nodeName]);
                         } else {
                             $cellContent = '----------';
                             $this->flushCell($sheet, $column, $row, $cellContent);
@@ -376,7 +376,7 @@ 
                         if ($this->tableLevel > 0) {
                             //    If we're inside a table, replace with a \n and set the cell to wrap
                             $cellContent .= "\n";
-                            $sheet->getStyle($column . $row)->getAlignment()->setWrapText(true);
+                            $sheet->getStyle($column.$row)->getAlignment()->setWrapText(true);
                         } else {
                             //    Otherwise flush our existing content and move the row cursor on
                             $this->flushCell($sheet, $column, $row, $cellContent);
@@ -388,9 +388,9 @@ 
                         foreach ($attributeArray as $attributeName => $attributeValue) {
                             switch ($attributeName) {
                                 case 'href':
-                                    $sheet->getCell($column . $row)->getHyperlink()->setUrl($attributeValue);
+                                    $sheet->getCell($column.$row)->getHyperlink()->setUrl($attributeValue);
                                     if (isset($this->formats[$child->nodeName])) {
-                                        $sheet->getStyle($column . $row)->applyFromArray($this->formats[$child->nodeName]);
+                                        $sheet->getStyle($column.$row)->applyFromArray($this->formats[$child->nodeName]);
                                     }
 
                                     break;
@@ -426,7 +426,7 @@ 
                             $this->flushCell($sheet, $column, $row, $cellContent);
 
                             if (isset($this->formats[$child->nodeName])) {
-                                $sheet->getStyle($column . $row)->applyFromArray($this->formats[$child->nodeName]);
+                                $sheet->getStyle($column.$row)->applyFromArray($this->formats[$child->nodeName]);
                             }
 
                             ++$row;
@@ -490,7 +490,7 @@ 
                     case 'td':
                         $this->processDomElement($child, $sheet, $row, $column, $cellContent);
 
-                        while (isset($this->rowspan[$column . $row])) {
+                        while (isset($this->rowspan[$column.$row])) {
                             ++$column;
                         }
 
@@ -505,7 +505,7 @@ 
                             for ($i = 0; $i < (int) $attributeArray['colspan'] - 1; ++$i) {
                                 ++$columnTo;
                             }
-                            $range = $column . $row . ':' . $columnTo . ($row + (int) $attributeArray['rowspan'] - 1);
+                            $range = $column.$row.':'.$columnTo.($row + (int) $attributeArray['rowspan'] - 1);
                             foreach (Coordinate::extractAllCellReferencesInRange($range) as $value) {
                                 $this->rowspan[$value] = true;
                             }
@@ -513,7 +513,7 @@ 
                             $column = $columnTo;
                         } elseif (isset($attributeArray['rowspan'])) {
                             //create merging rowspan
-                            $range = $column . $row . ':' . $column . ($row + (int) $attributeArray['rowspan'] - 1);
+                            $range = $column.$row.':'.$column.($row + (int) $attributeArray['rowspan'] - 1);
                             foreach (Coordinate::extractAllCellReferencesInRange($range) as $value) {
                                 $this->rowspan[$value] = true;
                             }
@@ -524,10 +524,10 @@ 
                             for ($i = 0; $i < (int) $attributeArray['colspan'] - 1; ++$i) {
                                 ++$columnTo;
                             }
-                            $sheet->mergeCells($column . $row . ':' . $columnTo . $row);
+                            $sheet->mergeCells($column.$row.':'.$columnTo.$row);
                             $column = $columnTo;
                         } elseif (isset($attributeArray['bgcolor'])) {
-                            $sheet->getStyle($column . $row)->applyFromArray(
+                            $sheet->getStyle($column.$row)->applyFromArray(
                                 [
                                     'fill' => [
                                         'fillType' => Fill::FILL_SOLID,
@@ -546,15 +546,15 @@ 
                         }
 
                         if (isset($attributeArray['align'])) {
-                            $sheet->getStyle($column . $row)->getAlignment()->setHorizontal($attributeArray['align']);
+                            $sheet->getStyle($column.$row)->getAlignment()->setHorizontal($attributeArray['align']);
                         }
 
                         if (isset($attributeArray['valign'])) {
-                            $sheet->getStyle($column . $row)->getAlignment()->setVertical($attributeArray['valign']);
+                            $sheet->getStyle($column.$row)->getAlignment()->setVertical($attributeArray['valign']);
                         }
 
                         if (isset($attributeArray['data-format'])) {
-                            $sheet->getStyle($column . $row)->getNumberFormat()->setFormatCode($attributeArray['data-format']);
+                            $sheet->getStyle($column.$row)->getNumberFormat()->setFormatCode($attributeArray['data-format']);
                         }
 
                         ++$column;
@@ -589,7 +589,7 @@ 
     {
         // Validate
         if (!$this->canRead($pFilename)) {
-            throw new Exception($pFilename . ' is an Invalid HTML file.');
+            throw new Exception($pFilename.' is an Invalid HTML file.');
         }
 
         // Create a new DOM object
@@ -597,7 +597,7 @@ 
         // Reload the HTML file into the DOM object
         $loaded = $dom->loadHTML(mb_convert_encoding($this->securityScanner->scanFile($pFilename), 'HTML-ENTITIES', 'UTF-8'));
         if ($loaded === false) {
-            throw new Exception('Failed to load ' . $pFilename . ' as a DOM Document');
+            throw new Exception('Failed to load '.$pFilename.' as a DOM Document');
         }
 
         return $this->loadDocument($dom, $spreadsheet);
@@ -699,7 +699,7 @@ 
             return;
         }
 
-        $cellStyle = $sheet->getStyle($column . $row);
+        $cellStyle = $sheet->getStyle($column.$row);
 
         // add color styles (background & text) from dom element,currently support : td & th, using ONLY inline css style with RGB color
         $styles = explode(';', $attributeArray['style']);
@@ -879,7 +879,7 @@ 
         $drawing = new Drawing();
         $drawing->setPath($src);
         $drawing->setWorksheet($sheet);
-        $drawing->setCoordinates($column . $row);
+        $drawing->setCoordinates($column.$row);
         $drawing->setOffsetX(0);
         $drawing->setOffsetY(10);
         $drawing->setResizeProportional(true);

htdocs/includes/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Reader/Slk.php

Spacing +9 added lines, -9 removed lines

@@ -115,7 +115,7 @@ 
     {
         // Open file
         if (!$this->canRead($pFilename)) {
-            throw new Exception($pFilename . ' is an Invalid Spreadsheet file.');
+            throw new Exception($pFilename.' is an Invalid Spreadsheet file.');
         }
         $this->openFile($pFilename);
         $fileHandle = $this->fileHandle;
@@ -204,7 +204,7 @@ 
     {
         // Open file
         if (!$this->canRead($pFilename)) {
-            throw new Exception($pFilename . ' is an Invalid Spreadsheet file.');
+            throw new Exception($pFilename.' is an Invalid Spreadsheet file.');
         }
         $this->openFile($pFilename);
         $fileHandle = $this->fileHandle;
@@ -285,7 +285,7 @@ 
                             break;
                     }
                 }
-                $this->formats['P' . $this->format++] = $formatArray;
+                $this->formats['P'.$this->format++] = $formatArray;
             //    Read cell value data
             } elseif ($dataType == 'C') {
                 $hasCalculatedValue = false;
@@ -307,7 +307,7 @@ 
 
                             break;
                         case 'E':
-                            $cellDataFormula = '=' . substr($rowDatum, 1);
+                            $cellDataFormula = '='.substr($rowDatum, 1);
                             //    Convert R1C1 style references to A1 style references (but only when not quoted)
                             $temp = explode('"', $cellDataFormula);
                             $key = false;
@@ -340,7 +340,7 @@ 
                                         if ($columnReference[0] == '[') {
                                             $columnReference = $column + trim($columnReference, '[]');
                                         }
-                                        $A1CellReference = Coordinate::stringFromColumnIndex($columnReference) . $rowReference;
+                                        $A1CellReference = Coordinate::stringFromColumnIndex($columnReference).$rowReference;
 
                                         $value = substr_replace($value, $A1CellReference, $cellReference[0][1], strlen($cellReference[0][0]));
                                     }
@@ -358,10 +358,10 @@ 
                 $cellData = Calculation::unwrapResult($cellData);
 
                 // Set cell value
-                $spreadsheet->getActiveSheet()->getCell($columnLetter . $row)->setValue(($hasCalculatedValue) ? $cellDataFormula : $cellData);
+                $spreadsheet->getActiveSheet()->getCell($columnLetter.$row)->setValue(($hasCalculatedValue) ? $cellDataFormula : $cellData);
                 if ($hasCalculatedValue) {
                     $cellData = Calculation::unwrapResult($cellData);
-                    $spreadsheet->getActiveSheet()->getCell($columnLetter . $row)->setCalculatedValue($cellData);
+                    $spreadsheet->getActiveSheet()->getCell($columnLetter.$row)->setCalculatedValue($cellData);
                 }
                 //    Read cell formatting
             } elseif ($dataType == 'F') {
@@ -425,12 +425,12 @@ 
                 if (($formatStyle > '') && ($column > '') && ($row > '')) {
                     $columnLetter = Coordinate::stringFromColumnIndex($column);
                     if (isset($this->formats[$formatStyle])) {
-                        $spreadsheet->getActiveSheet()->getStyle($columnLetter . $row)->applyFromArray($this->formats[$formatStyle]);
+                        $spreadsheet->getActiveSheet()->getStyle($columnLetter.$row)->applyFromArray($this->formats[$formatStyle]);
                     }
                 }
                 if ((!empty($styleData)) && ($column > '') && ($row > '')) {
                     $columnLetter = Coordinate::stringFromColumnIndex($column);
-                    $spreadsheet->getActiveSheet()->getStyle($columnLetter . $row)->applyFromArray($styleData);
+                    $spreadsheet->getActiveSheet()->getStyle($columnLetter.$row)->applyFromArray($styleData);
                 }
                 if ($columnWidth > '') {
                     if ($startCol == $endCol) {

htdocs/includes/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Collection/Cells.php

Spacing +6 added lines, -6 removed lines

@@ -131,7 +131,7 @@ 
         unset($this->index[$pCoord]);
 
         // Delete the entry from cache
-        $this->cache->delete($this->cachePrefix . $pCoord);
+        $this->cache->delete($this->cachePrefix.$pCoord);
     }
 
     /**
@@ -178,7 +178,7 @@ 
             $r = 0;
             sscanf($coord, '%[A-Z]%d', $c, $r);
             $row[$r] = $r;
-            $col[$c] = strlen($c) . $c;
+            $col[$c] = strlen($c).$c;
         }
 
         // Determine highest column and row
@@ -300,7 +300,7 @@ 
      */
     private function getUniqueID()
     {
-        return uniqid('phpspreadsheet.', true) . '.';
+        return uniqid('phpspreadsheet.', true).'.';
     }
 
     /**
@@ -390,7 +390,7 @@ 
         if ($this->currentCellIsDirty && !empty($this->currentCoordinate)) {
             $this->currentCell->detach();
 
-            $stored = $this->cache->set($this->cachePrefix . $this->currentCoordinate, $this->currentCell);
+            $stored = $this->cache->set($this->cachePrefix.$this->currentCoordinate, $this->currentCell);
             if (!$stored) {
                 $this->__destruct();
 
@@ -449,7 +449,7 @@ 
         }
 
         // Check if the entry that has been requested actually exists
-        $cell = $this->cache->get($this->cachePrefix . $pCoord);
+        $cell = $this->cache->get($this->cachePrefix.$pCoord);
         if ($cell === null) {
             throw new PhpSpreadsheetException("Cell entry {$pCoord} no longer exists in cache. This probably means that the cache was cleared by someone else.");
         }
@@ -500,7 +500,7 @@ 
     private function getAllCacheKeys()
     {
         foreach ($this->getCoordinates() as $coordinate) {
-            yield $this->cachePrefix . $coordinate;
+            yield $this->cachePrefix.$coordinate;
         }
     }
 }

htdocs/includes/phpoffice/phpspreadsheet/src/PhpSpreadsheet/IOFactory.php

Spacing +2 added lines, -2 removed lines

@@ -205,7 +205,7 @@ 
     public static function registerWriter($writerType, $writerClass)
     {
         if (!is_a($writerClass, Writer\IWriter::class, true)) {
-            throw new Writer\Exception('Registered writers must implement ' . Writer\IWriter::class);
+            throw new Writer\Exception('Registered writers must implement '.Writer\IWriter::class);
         }
 
         self::$writers[$writerType] = $writerClass;
@@ -220,7 +220,7 @@ 
     public static function registerReader($readerType, $readerClass)
     {
         if (!is_a($readerClass, Reader\IReader::class, true)) {
-            throw new Reader\Exception('Registered readers must implement ' . Reader\IReader::class);
+            throw new Reader\Exception('Registered readers must implement '.Reader\IReader::class);
         }
 
         self::$readers[$readerType] = $readerClass;

htdocs/includes/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Cell/AdvancedValueBinder.php

Spacing +2 added lines, -2 removed lines

@@ -44,7 +44,7 @@ 
             }
 
             // Check for number in scientific format
-            if (preg_match('/^' . Calculation::CALCULATION_REGEXP_NUMBER . '$/', $value)) {
+            if (preg_match('/^'.Calculation::CALCULATION_REGEXP_NUMBER.'$/', $value)) {
                 $cell->setValueExplicit((float) $value, DataType::TYPE_NUMERIC);
 
                 return true;
@@ -93,7 +93,7 @@ 
             $currencyCode = StringHelper::getCurrencyCode();
             $decimalSeparator = StringHelper::getDecimalSeparator();
             $thousandsSeparator = StringHelper::getThousandsSeparator();
-            if (preg_match('/^' . preg_quote($currencyCode, '/') . ' *(\d{1,3}(' . preg_quote($thousandsSeparator, '/') . '\d{3})*|(\d+))(' . preg_quote($decimalSeparator, '/') . '\d{2})?$/', $value)) {
+            if (preg_match('/^'.preg_quote($currencyCode, '/').' *(\d{1,3}('.preg_quote($thousandsSeparator, '/').'\d{3})*|(\d+))('.preg_quote($decimalSeparator, '/').'\d{2})?$/', $value)) {
                 // Convert value to number
                 $value = (float) trim(str_replace([$currencyCode, $thousandsSeparator, $decimalSeparator], ['', '', '.'], $value));
                 $cell->setValueExplicit($value, DataType::TYPE_NUMERIC);

htdocs/includes/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Cell/Hyperlink.php

Spacing +2 added lines, -2 removed lines

@@ -105,8 +105,8 @@
     public function getHashCode()
     {
         return md5(
-            $this->url .
-            $this->tooltip .
+            $this->url.
+            $this->tooltip.
             __CLASS__
         );
     }

htdocs/includes/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Cell/Cell.php

Spacing +2 added lines, -2 removed lines

@@ -236,7 +236,7 @@ 
 
                 break;
             default:
-                throw new Exception('Invalid datatype: ' . $pDataType);
+                throw new Exception('Invalid datatype: '.$pDataType);
 
                 break;
         }
@@ -275,7 +275,7 @@ 
                 }
 
                 throw new \PhpOffice\PhpSpreadsheet\Calculation\Exception(
-                    $this->getWorksheet()->getTitle() . '!' . $this->getCoordinate() . ' -> ' . $ex->getMessage()
+                    $this->getWorksheet()->getTitle().'!'.$this->getCoordinate().' -> '.$ex->getMessage()
                 );
             }