PHPOffice / PhpSpreadsheet

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

tests/PhpSpreadsheetTests/Shared/Date2Test.php

Spacing +4 added lines, -4 removed lines

@@ -39,7 +39,7 @@ 
     }
 
     #[DataProvider('providerTimeOnly')]
-    public function testTimeOnly(int|float $expectedResult, int|float|string $value, ?string $format = null): void
+    public function testTimeOnly(int | float $expectedResult, int | float | string $value, ?string $format = null): void
     {
         Cell::setCalculateDateTimeType(Cell::CALCULATE_TIME_FLOAT);
         $spreadsheet = $this->spreadsheet = new Spreadsheet();
@@ -84,7 +84,7 @@ 
     }
 
     #[DataProvider('providerDateAndTime')]
-    public function testDateAndTime(int|float $expectedResult, int|float|string $value, ?string $format = null): void
+    public function testDateAndTime(int | float $expectedResult, int | float | string $value, ?string $format = null): void
     {
         Cell::setCalculateDateTimeType(
             Cell::CALCULATE_DATE_TIME_FLOAT
@@ -131,7 +131,7 @@ 
     }
 
     #[DataProvider('providerAsis')]
-    public function testDefault(int|float $expectedResult, int|float|string $value, ?string $format = null): void
+    public function testDefault(int | float $expectedResult, int | float | string $value, ?string $format = null): void
     {
         $spreadsheet = $this->spreadsheet = new Spreadsheet();
         self::assertSame(0, $spreadsheet->getActiveSheetIndex());
@@ -152,7 +152,7 @@ 
     }
 
     #[DataProvider('providerAsis')]
-    public function testAsis(int|float $expectedResult, int|float|string $value, ?string $format = null): void
+    public function testAsis(int | float $expectedResult, int | float | string $value, ?string $format = null): void
     {
         Cell::setCalculateDateTimeType(
             Cell::CALCULATE_DATE_TIME_ASIS

src/PhpSpreadsheet/Reader/Xlsx.php

Spacing +4 added lines, -4 removed lines

@@ -2070,13 +2070,13 @@ 
     }
 
     /** @param null|bool|mixed[]|SimpleXMLElement $array */
-    private static function getArrayItem(null|array|bool|SimpleXMLElement $array, int|string $key = 0): mixed
+    private static function getArrayItem(null | array | bool | SimpleXMLElement $array, int | string $key = 0): mixed
     {
         return ($array === null || is_bool($array)) ? null : ($array[$key] ?? null);
     }
 
     /** @param null|bool|mixed[]|SimpleXMLElement $array */
-    private static function getArrayItemString(null|array|bool|SimpleXMLElement $array, int|string $key = 0): string
+    private static function getArrayItemString(null | array | bool | SimpleXMLElement $array, int | string $key = 0): string
     {
         $retVal = self::getArrayItem($array, $key);
 
@@ -2084,14 +2084,14 @@ 
     }
 
     /** @param null|bool|mixed[]|SimpleXMLElement $array */
-    private static function getArrayItemIntOrSxml(null|array|bool|SimpleXMLElement $array, int|string $key = 0): int|SimpleXMLElement
+    private static function getArrayItemIntOrSxml(null | array | bool | SimpleXMLElement $array, int | string $key = 0): int | SimpleXMLElement
     {
         $retVal = self::getArrayItem($array, $key);
 
         return (is_int($retVal) || $retVal instanceof SimpleXMLElement) ? $retVal : 0;
     }
 
-    private static function dirAdd(null|SimpleXMLElement|string $base, null|SimpleXMLElement|string $add): string
+    private static function dirAdd(null | SimpleXMLElement | string $base, null | SimpleXMLElement | string $add): string
     {
         $base = (string) $base;
         $add = (string) $add;