Dolibarr / dolibarr

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

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

Spacing +14 added lines, -14 removed lines

@@ -39,7 +39,7 @@ 
             throw new Exception('Cell coordinate can not be zero-length string');
         }
 
-        throw new Exception('Invalid cell coordinate ' . $pCoordinateString);
+        throw new Exception('Invalid cell coordinate '.$pCoordinateString);
     }
 
     /**
@@ -78,12 +78,12 @@ 
 
         // Create absolute coordinate
         if (ctype_digit($pCoordinateString)) {
-            return $worksheet . '$' . $pCoordinateString;
+            return $worksheet.'$'.$pCoordinateString;
         } elseif (ctype_alpha($pCoordinateString)) {
-            return $worksheet . '$' . strtoupper($pCoordinateString);
+            return $worksheet.'$'.strtoupper($pCoordinateString);
         }
 
-        return $worksheet . self::absoluteCoordinate($pCoordinateString);
+        return $worksheet.self::absoluteCoordinate($pCoordinateString);
     }
 
     /**
@@ -112,7 +112,7 @@ 
         $column = ltrim($column, '$');
         $row = ltrim($row, '$');
 
-        return $worksheet . '$' . $column . '$' . $row;
+        return $worksheet.'$'.$column.'$'.$row;
     }
 
     /**
@@ -289,7 +289,7 @@ 
             }
         }
 
-        throw new Exception('Column string index can not be ' . ((isset($pString[0])) ? 'longer than 3 characters' : 'empty'));
+        throw new Exception('Column string index can not be '.((isset($pString[0])) ? 'longer than 3 characters' : 'empty'));
     }
 
     /**
@@ -309,7 +309,7 @@ 
             do {
                 $characterValue = ($indexValue % 26) ?: 26;
                 $indexValue = ($indexValue - $characterValue) / 26;
-                $base26 = chr($characterValue + 64) . ($base26 ?: '');
+                $base26 = chr($characterValue + 64).($base26 ?: '');
             } while ($indexValue > 0);
             $indexCache[$columnIndex] = $base26;
         }
@@ -392,7 +392,7 @@ 
             // Loop cells
             while ($currentColumnIndex < $endColumnIndex) {
                 while ($currentRow <= $endRow) {
-                    $returnValue[] = self::stringFromColumnIndex($currentColumnIndex) . $currentRow;
+                    $returnValue[] = self::stringFromColumnIndex($currentColumnIndex).$currentRow;
                     ++$currentRow;
                 }
                 ++$currentColumnIndex;
@@ -434,7 +434,7 @@ 
 
             [$column, $row] = self::coordinateFromString($coord);
             $row = (int) (ltrim($row, '$'));
-            $hashCode = $column . '-' . (is_object($value) ? $value->getHashCode() : $value);
+            $hashCode = $column.'-'.(is_object($value) ? $value->getHashCode() : $value);
 
             if (!isset($hashedValues[$hashCode])) {
                 $hashedValues[$hashCode] = (object) [
@@ -463,9 +463,9 @@ 
                     $rowEnd = $row;
                 } else {
                     if ($rowStart == $rowEnd) {
-                        $ranges[] = $hashedValue->col . $rowStart;
+                        $ranges[] = $hashedValue->col.$rowStart;
                     } else {
-                        $ranges[] = $hashedValue->col . $rowStart . ':' . $hashedValue->col . $rowEnd;
+                        $ranges[] = $hashedValue->col.$rowStart.':'.$hashedValue->col.$rowEnd;
                     }
 
                     $rowStart = $row;
@@ -475,9 +475,9 @@ 
 
             if ($rowStart !== null) {
                 if ($rowStart == $rowEnd) {
-                    $ranges[] = $hashedValue->col . $rowStart;
+                    $ranges[] = $hashedValue->col.$rowStart;
                 } else {
-                    $ranges[] = $hashedValue->col . $rowStart . ':' . $hashedValue->col . $rowEnd;
+                    $ranges[] = $hashedValue->col.$rowStart.':'.$hashedValue->col.$rowEnd;
                 }
             }
 
@@ -514,7 +514,7 @@ 
     private static function validateRange($cellBlock, $startColumnIndex, $endColumnIndex, $currentRow, $endRow)
     {
         if ($startColumnIndex >= $endColumnIndex || $currentRow > $endRow) {
-            throw new Exception('Invalid range: "' . $cellBlock . '"');
+            throw new Exception('Invalid range: "'.$cellBlock.'"');
         }
     }
 }

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

Spacing +1 added lines, -1 removed lines

@@ -59,7 +59,7 @@
                 return in_array(strtolower($cellValue), explode(',', strtolower(trim($formula1, '"'))), true);
             } elseif (strpos($formula1, ':') > 0) {
                 // values list cells
-                $matchFormula = '=MATCH(' . $cell->getCoordinate() . ', ' . $formula1 . ', 0)';
+                $matchFormula = '=MATCH('.$cell->getCoordinate().', '.$formula1.', 0)';
                 $calculation = Calculation::getInstance($cell->getWorksheet()->getParent());
 
                 try {