PHPOffice / PhpSpreadsheet

src/PhpSpreadsheet/Calculation/Calculation.php

Spacing +11 added lines, -11 removed lines

@@ -163,7 +163,7 @@ 
         return array_key_exists($key, self::EXCEL_CONSTANTS);
     }
 
-    public static function getExcelConstants(string $key): bool|null
+    public static function getExcelConstants(string $key): bool | null
     {
         return self::EXCEL_CONSTANTS[$key];
     }
@@ -538,7 +538,7 @@ 
      *
      * @param string $formula Formula to parse
      */
-    public function parseFormula(string $formula): array|bool
+    public function parseFormula(string $formula): array | bool
     {
         $formula = preg_replace_callback(
             self::CALCULATION_REGEXP_CELLREF_SPILL,
@@ -957,7 +957,7 @@ 
     /**
      * @return false|string False indicates an error
      */
-    private function convertMatrixReferences(string $formula): false|string
+    private function convertMatrixReferences(string $formula): false | string
     {
         static $matrixReplaceFrom = [self::FORMULA_OPEN_MATRIX_BRACE, ';', self::FORMULA_CLOSE_MATRIX_BRACE];
         static $matrixReplaceTo = ['MKMATRIX(MKMATRIX(', '),MKMATRIX(', '))'];
@@ -1036,7 +1036,7 @@ 
     /**
      * @return array<int, mixed>|false
      */
-    private function internalParseFormula(string $formula, ?Cell $cell = null): bool|array
+    private function internalParseFormula(string $formula, ?Cell $cell = null): bool | array
     {
         if (($formula = $this->convertMatrixReferences(trim($formula))) === false) {
             return false;
@@ -1549,7 +1549,7 @@ 
     /**
      * @return array<int, mixed>|false|string
      */
-    private function processTokenStack(false|array $tokens, ?string $cellID = null, ?Cell $cell = null)
+    private function processTokenStack(false | array $tokens, ?string $cellID = null, ?Cell $cell = null)
     {
         if ($tokens === false) {
             return false;
@@ -2201,7 +2201,7 @@ 
         return $output;
     }
 
-    private function validateBinaryOperand(mixed &$operand, Stack &$stack): bool
+    private function validateBinaryOperand(mixed &$operand, Stack & $stack): bool
     {
         if (is_array($operand)) {
             if ((count($operand, COUNT_RECURSIVE) - count($operand)) == 1) {
@@ -2240,7 +2240,7 @@ 
     }
 
     /** @return mixed[] */
-    private function executeArrayComparison(mixed $operand1, mixed $operand2, string $operation, Stack &$stack, bool $recursingArrays): array
+    private function executeArrayComparison(mixed $operand1, mixed $operand2, string $operation, Stack & $stack, bool $recursingArrays): array
     {
         $result = [];
         if (!is_array($operand2) && is_array($operand1)) {
@@ -2285,7 +2285,7 @@ 
     }
 
     /** @return bool|mixed[] */
-    private function executeBinaryComparisonOperation(mixed $operand1, mixed $operand2, string $operation, Stack &$stack, bool $recursingArrays = false): array|bool
+    private function executeBinaryComparisonOperation(mixed $operand1, mixed $operand2, string $operation, Stack & $stack, bool $recursingArrays = false): array | bool
     {
         //    If we're dealing with matrix operations, we want a matrix result
         if ((is_array($operand1)) || (is_array($operand2))) {
@@ -2302,7 +2302,7 @@ 
         return $result;
     }
 
-    private function executeNumericBinaryOperation(mixed $operand1, mixed $operand2, string $operation, Stack &$stack): mixed
+    private function executeNumericBinaryOperation(mixed $operand1, mixed $operand2, string $operation, Stack & $stack): mixed
     {
         //    Validate the two operands
         if (
@@ -2525,7 +2525,7 @@ 
      *
      * @return mixed[]|string Array of values in range if range contains more than one element. Otherwise, a single value is returned.
      */
-    public function extractNamedRange(string &$range = 'A1', ?Worksheet $worksheet = null, bool $resetLog = true): string|array
+    public function extractNamedRange(string &$range = 'A1', ?Worksheet $worksheet = null, bool $resetLog = true): string | array
     {
         // Return value
         $returnValue = [];
@@ -2674,7 +2674,7 @@ 
      *
      * @return mixed[]
      */
-    private function addCellReference(array $args, bool $passCellReference, array|string $functionCall, ?Cell $cell = null): array
+    private function addCellReference(array $args, bool $passCellReference, array | string $functionCall, ?Cell $cell = null): array
     {
         if ($passCellReference) {
             if (is_array($functionCall)) {

tests/PhpSpreadsheetTests/Cell/CoordinateTest.php

Spacing +1 added lines, -1 removed lines

@@ -170,7 +170,7 @@
     }
 
     #[DataProvider('providerAbsoluteReferences')]
-    public function testAbsoluteReferenceFromString(mixed $expectedResult, int|string $rangeSet): void
+    public function testAbsoluteReferenceFromString(mixed $expectedResult, int | string $rangeSet): void
     {
         $result = Coordinate::absoluteReference((string) $rangeSet);
         self::assertEquals($expectedResult, $result);

src/PhpSpreadsheet/Chart/Title.php

Spacing +4 added lines, -4 removed lines

@@ -18,7 +18,7 @@ 
      *
      * @var array<RichText|string>|RichText|string
      */
-    private array|RichText|string $caption;
+    private array | RichText | string $caption;
 
     /**
      * Allow overlay of other elements?
@@ -37,7 +37,7 @@ 
     /**
      * Create a new Title.
      */
-    public function __construct(array|RichText|string $caption = '', ?Layout $layout = null, bool $overlay = false)
+    public function __construct(array | RichText | string $caption = '', ?Layout $layout = null, bool $overlay = false)
     {
         $this->caption = $caption;
         $this->layout = $layout;
@@ -49,7 +49,7 @@ 
      *
      * @return array<RichText|string>|RichText|string
      */
-    public function getCaption(): array|RichText|string
+    public function getCaption(): array | RichText | string
     {
         return $this->caption;
     }
@@ -88,7 +88,7 @@ 
      *
      * @return $this
      */
-    public function setCaption(array|RichText|string $caption): static
+    public function setCaption(array | RichText | string $caption): static
     {
         $this->caption = $caption;
 

src/PhpSpreadsheet/Cell/Coordinate.php

Spacing +2 added lines, -2 removed lines

@@ -84,7 +84,7 @@ 
      *
      * @return string Absolute coordinate        e.g. '$A' or '$1' or '$A$1'
      */
-    public static function absoluteReference(int|string $cellAddress): string
+    public static function absoluteReference(int | string $cellAddress): string
     {
         $cellAddress = (string) $cellAddress;
         if (self::coordinateIsRange($cellAddress)) {
@@ -420,7 +420,7 @@ 
      *
      * @param int|numeric-string $columnIndex Column index (A = 1)
      */
-    public static function stringFromColumnIndex(int|string $columnIndex): string
+    public static function stringFromColumnIndex(int | string $columnIndex): string
     {
         /** @var string[] */
         static $indexCache = [];

src/PhpSpreadsheet/Writer/Html.php

Spacing +2 added lines, -2 removed lines

@@ -1428,7 +1428,7 @@ 
     }
 
     /** @param string|string[] $cssClass */
-    private function generateRowCellData(Worksheet $worksheet, null|Cell|string $cell, array|string &$cssClass): string
+    private function generateRowCellData(Worksheet $worksheet, null | Cell | string $cell, array | string &$cssClass): string
     {
         $cellData = ' ';
         if ($cell instanceof Cell) {
@@ -1513,7 +1513,7 @@ 
         string $cellData,
         int $colSpan,
         int $rowSpan,
-        array|string $cssClass,
+        array | string $cssClass,
         int $colNum,
         int $sheetIndex,
         int $row,

src/PhpSpreadsheet/Writer/Xls.php

Spacing +4 added lines, -4 removed lines

@@ -383,7 +383,7 @@ 
         }
     }
 
-    private function processMemoryDrawing(BstoreContainer &$bstoreContainer, MemoryDrawing $drawing, string $renderingFunctionx): void
+    private function processMemoryDrawing(BstoreContainer & $bstoreContainer, MemoryDrawing $drawing, string $renderingFunctionx): void
     {
         switch ($renderingFunctionx) {
             case MemoryDrawing::RENDERING_JPEG:
@@ -415,7 +415,7 @@ 
 
     private static int $two = 2; // phpstan silliness
 
-    private function processDrawing(BstoreContainer &$bstoreContainer, Drawing $drawing): void
+    private function processDrawing(BstoreContainer & $bstoreContainer, Drawing $drawing): void
     {
         $blipType = 0;
         $blipData = '';
@@ -472,7 +472,7 @@ 
         }
     }
 
-    private function processBaseDrawing(BstoreContainer &$bstoreContainer, BaseDrawing $drawing): void
+    private function processBaseDrawing(BstoreContainer & $bstoreContainer, BaseDrawing $drawing): void
     {
         if ($drawing instanceof Drawing && $drawing->getPath() !== '') {
             $this->processDrawing($bstoreContainer, $drawing);
@@ -760,7 +760,7 @@ 
     }
 
     /** @param array<int, array{summary: array{pack: string, data: mixed}, offset: array{pack: string}, type: array{pack: string, data: int}, data: array{data: mixed}}> $dataSection */
-    private function writeSummaryPropOle(float|int $dataProp, int &$dataSection_NumProps, array &$dataSection, int $sumdata, int $typdata): void
+    private function writeSummaryPropOle(float | int $dataProp, int &$dataSection_NumProps, array &$dataSection, int $sumdata, int $typdata): void
     {
         if ($dataProp) {
             $dataSection[] = [

src/PhpSpreadsheet/Writer/Xls/Parser.php

Spacing +1 added lines, -1 removed lines

@@ -94,7 +94,7 @@
      *
      * @var mixed[]|string
      */
-    public array|string $parseTree;
+    public array | string $parseTree;
 
     /**
      * Array of external sheets.

src/PhpSpreadsheet/Reader/Slk.php

Spacing +8 added lines, -8 removed lines

@@ -222,7 +222,7 @@ 
     }
 
     /** @param mixed[] $rowData */
-    private function processCRecord(array $rowData, Spreadsheet &$spreadsheet, string &$row, string &$column): void
+    private function processCRecord(array $rowData, Spreadsheet & $spreadsheet, string &$row, string &$column): void
     {
         //    Read cell value data
         $hasCalculatedValue = false;
@@ -297,7 +297,7 @@ 
         $this->processCFinal($spreadsheet, $hasCalculatedValue, $cellDataFormula, $cellData, "$columnLetter$row", $tryNumeric);
     }
 
-    private function processCFinal(Spreadsheet &$spreadsheet, bool $hasCalculatedValue, string $cellDataFormula, string $cellData, string $coordinate, bool $tryNumeric): void
+    private function processCFinal(Spreadsheet & $spreadsheet, bool $hasCalculatedValue, string $cellDataFormula, string $cellData, string $coordinate, bool $tryNumeric): void
     {
         // Set cell value
         $spreadsheet->getActiveSheet()->getCell($coordinate)->setValue(($hasCalculatedValue) ? $cellDataFormula : $cellData);
@@ -308,7 +308,7 @@ 
     }
 
     /** @param mixed[] $rowData */
-    private function processFRecord(array $rowData, Spreadsheet &$spreadsheet, string &$row, string &$column): void
+    private function processFRecord(array $rowData, Spreadsheet & $spreadsheet, string &$row, string &$column): void
     {
         //    Read cell formatting
         $formatStyle = $columnWidth = '';
@@ -379,7 +379,7 @@ 
         }
     }
 
-    private function addFormats(Spreadsheet &$spreadsheet, string $formatStyle, string $row, string $column): void
+    private function addFormats(Spreadsheet & $spreadsheet, string $formatStyle, string $row, string $column): void
     {
         if ($formatStyle && $column > '' && $row > '') {
             $columnLetter = Coordinate::stringFromColumnIndex((int) $column);
@@ -389,7 +389,7 @@ 
         }
     }
 
-    private function addFonts(Spreadsheet &$spreadsheet, string $fontStyle, string $row, string $column): void
+    private function addFonts(Spreadsheet & $spreadsheet, string $fontStyle, string $row, string $column): void
     {
         if ($fontStyle && $column > '' && $row > '') {
             $columnLetter = Coordinate::stringFromColumnIndex((int) $column);
@@ -400,7 +400,7 @@ 
     }
 
     /** @param mixed[] $styleData */
-    private function addStyle(Spreadsheet &$spreadsheet, array $styleData, string $row, string $column): void
+    private function addStyle(Spreadsheet & $spreadsheet, array $styleData, string $row, string $column): void
     {
         if ((!empty($styleData)) && $column > '' && $row > '') {
             $columnLetter = Coordinate::stringFromColumnIndex((int) $column);
@@ -427,7 +427,7 @@ 
     }
 
     /** @param string[] $rowData */
-    private function processPRecord(array $rowData, Spreadsheet &$spreadsheet): void
+    private function processPRecord(array $rowData, Spreadsheet & $spreadsheet): void
     {
         //    Read shared styles
         $formatArray = [];
@@ -484,7 +484,7 @@ 
     }
 
     /** @param mixed[] $formatArray */
-    private function processPFinal(Spreadsheet &$spreadsheet, array $formatArray): void
+    private function processPFinal(Spreadsheet & $spreadsheet, array $formatArray): void
     {
         if (array_key_exists('numberFormat', $formatArray)) {
             $this->formats['P' . $this->format] = $formatArray;

src/PhpSpreadsheet/Reader/BaseReader.php

Spacing +1 added lines, -1 removed lines

@@ -119,7 +119,7 @@
     }
 
     /** @param null|string|string[] $sheetList */
-    public function setLoadSheetsOnly(string|array|null $sheetList): self
+    public function setLoadSheetsOnly(string | array | null $sheetList): self
     {
         if ($sheetList === null) {
             return $this->setLoadAllSheets();