PHPOffice / PhpSpreadsheet

tests/PhpSpreadsheetTests/Calculation/Functions/LookupRef/OffsetTest.php

Spacing +1 added lines, -1 removed lines

@@ -11,7 +11,7 @@
 class OffsetTest extends AllSetupTeardown
 {
     #[DataProvider('providerOFFSET')]
-    public function testOFFSET(mixed $expectedResult, null|string $cellReference = null): void
+    public function testOFFSET(mixed $expectedResult, null | string $cellReference = null): void
     {
         $result = LookupRef\Offset::OFFSET($cellReference);
         self::assertSame($expectedResult, $result);

src/PhpSpreadsheet/Worksheet/Worksheet.php

Spacing +16 added lines, -16 removed lines

@@ -1112,7 +1112,7 @@ 
      *
      * @return $this
      */
-    public function setCellValue(CellAddress|string|array $coordinate, mixed $value, ?IValueBinder $binder = null): static
+    public function setCellValue(CellAddress | string | array $coordinate, mixed $value, ?IValueBinder $binder = null): static
     {
         $cellAddress = Functions::trimSheetFromCellReference(Validations::validateCellAddress($coordinate));
         $this->getCell($cellAddress)->setValue($value, $binder);
@@ -1137,7 +1137,7 @@ 
      *
      * @return $this
      */
-    public function setCellValueExplicit(CellAddress|string|array $coordinate, mixed $value, string $dataType): static
+    public function setCellValueExplicit(CellAddress | string | array $coordinate, mixed $value, string $dataType): static
     {
         $cellAddress = Functions::trimSheetFromCellReference(Validations::validateCellAddress($coordinate));
         $this->getCell($cellAddress)->setValueExplicit($value, $dataType);
@@ -1158,7 +1158,7 @@ 
      *              the "active" cell, and any previous assignment becomes a disconnected reference because
      *              the active cell has changed.
      */
-    public function getCell(CellAddress|string|array $coordinate): Cell
+    public function getCell(CellAddress | string | array $coordinate): Cell
     {
         $cellAddress = Functions::trimSheetFromCellReference(Validations::validateCellAddress($coordinate));
 
@@ -1303,7 +1303,7 @@ 
      * @param array{0: int, 1: int}|CellAddress|string $coordinate Coordinate of the cell as a string, eg: 'C5';
      *               or as an array of [$columnIndex, $row] (e.g. [3, 5]), or a CellAddress object.
      */
-    public function cellExists(CellAddress|string|array $coordinate): bool
+    public function cellExists(CellAddress | string | array $coordinate): bool
     {
         $cellAddress = Validations::validateCellAddress($coordinate);
         [$sheet, $finalCoordinate] = $this->getWorksheetAndCoordinate($cellAddress);
@@ -1393,7 +1393,7 @@ 
      *              or passing in an array of [$fromColumnIndex, $fromRow, $toColumnIndex, $toRow] (e.g. [3, 5, 6, 8]),
      *              or a CellAddress or AddressRange object.
      */
-    public function getStyle(AddressRange|CellAddress|int|string|array $cellCoordinate): Style
+    public function getStyle(AddressRange | CellAddress | int | string | array $cellCoordinate): Style
     {
         if (is_string($cellCoordinate)) {
             $cellCoordinate = Validations::definedNameToCoordinate($cellCoordinate, $this);
@@ -1639,7 +1639,7 @@ 
      *
      * @return $this
      */
-    public function setBreak(CellAddress|string|array $coordinate, int $break, int $max = -1): static
+    public function setBreak(CellAddress | string | array $coordinate, int $break, int $max = -1): static
     {
         $cellAddress = Functions::trimSheetFromCellReference(Validations::validateCellAddress($coordinate));
 
@@ -1736,7 +1736,7 @@ 
      *
      * @return $this
      */
-    public function mergeCells(AddressRange|string|array $range, string $behaviour = self::MERGE_CELL_CONTENT_EMPTY): static
+    public function mergeCells(AddressRange | string | array $range, string $behaviour = self::MERGE_CELL_CONTENT_EMPTY): static
     {
         $range = Functions::trimSheetFromCellReference(Validations::validateCellRange($range));
 
@@ -1856,7 +1856,7 @@ 
      *
      * @return $this
      */
-    public function unmergeCells(AddressRange|string|array $range): static
+    public function unmergeCells(AddressRange | string | array $range): static
     {
         $range = Functions::trimSheetFromCellReference(Validations::validateCellRange($range));
 
@@ -1909,7 +1909,7 @@ 
      *
      * @return $this
      */
-    public function protectCells(AddressRange|CellAddress|int|string|array $range, string $password = '', bool $alreadyHashed = false, string $name = '', string $securityDescriptor = ''): static
+    public function protectCells(AddressRange | CellAddress | int | string | array $range, string $password = '', bool $alreadyHashed = false, string $name = '', string $securityDescriptor = ''): static
     {
         $range = Functions::trimSheetFromCellReference(Validations::validateCellOrCellRange($range));
 
@@ -1930,7 +1930,7 @@ 
      *
      * @return $this
      */
-    public function unprotectCells(AddressRange|CellAddress|int|string|array $range): static
+    public function unprotectCells(AddressRange | CellAddress | int | string | array $range): static
     {
         $range = Functions::trimSheetFromCellReference(Validations::validateCellOrCellRange($range));
 
@@ -1971,7 +1971,7 @@ 
      *
      * @return $this
      */
-    public function setAutoFilter(AddressRange|string|array|AutoFilter $autoFilterOrRange): static
+    public function setAutoFilter(AddressRange | string | array | AutoFilter $autoFilterOrRange): static
     {
         if (is_object($autoFilterOrRange) && ($autoFilterOrRange instanceof AutoFilter)) {
             $this->autoFilter = $autoFilterOrRange;
@@ -2116,7 +2116,7 @@ 
      *
      * @return $this
      */
-    public function freezePane(null|CellAddress|string|array $coordinate, null|CellAddress|string|array $topLeftCell = null, bool $frozenSplit = false): static
+    public function freezePane(null | CellAddress | string | array $coordinate, null | CellAddress | string | array $topLeftCell = null, bool $frozenSplit = false): static
     {
         $this->panes = [
             'bottomRight' => null,
@@ -2626,7 +2626,7 @@ 
      *
      * @return $this
      */
-    public function removeComment(CellAddress|string|array $cellCoordinate): self
+    public function removeComment(CellAddress | string | array $cellCoordinate): self
     {
         $cellAddress = Functions::trimSheetFromCellReference(Validations::validateCellAddress($cellCoordinate));
 
@@ -2651,7 +2651,7 @@ 
      * @param array{0: int, 1: int}|CellAddress|string $cellCoordinate Coordinate of the cell as a string, eg: 'C5';
      *               or as an array of [$columnIndex, $row] (e.g. [3, 5]), or a CellAddress object.
      */
-    public function getComment(CellAddress|string|array $cellCoordinate, bool $attachNew = true): Comment
+    public function getComment(CellAddress | string | array $cellCoordinate, bool $attachNew = true): Comment
     {
         $cellAddress = Functions::trimSheetFromCellReference(Validations::validateCellAddress($cellCoordinate));
 
@@ -2716,7 +2716,7 @@ 
      *
      * @return $this
      */
-    public function setSelectedCells(AddressRange|CellAddress|int|string|array $coordinate): static
+    public function setSelectedCells(AddressRange | CellAddress | int | string | array $coordinate): static
     {
         if (is_string($coordinate)) {
             $coordinate = Validations::definedNameToCoordinate($coordinate, $this);
@@ -3186,7 +3186,7 @@ 
      *
      * @return ($range is non-empty-string ? ($returnRange is true ? array{0: string, 1: string} : string) : ($returnRange is true ? array{0: null, 1: null} : null))
      */
-    public static function extractSheetTitle(?string $range, bool $returnRange = false, bool $unapostrophize = false): array|null|string
+    public static function extractSheetTitle(?string $range, bool $returnRange = false, bool $unapostrophize = false): array | null | string
     {
         if (empty($range)) {
             return $returnRange ? [null, null] : null;

tests/PhpSpreadsheetTests/Reader/Csv/CsvTest.php

Spacing +1 added lines, -1 removed lines

@@ -12,7 +12,7 @@
 class CsvTest extends TestCase
 {
     #[DataProvider('providerDelimiterDetection')]
-    public function testDelimiterDetection(string $filename, string $expectedDelimiter, string $cell, string|float|int|null $expectedValue): void
+    public function testDelimiterDetection(string $filename, string $expectedDelimiter, string $cell, string | float | int | null $expectedValue): void
     {
         $reader = new Csv();
         $delim1 = $reader->getDelimiter();

src/PhpSpreadsheet/Reader/Csv.php

Spacing +1 added lines, -1 removed lines

@@ -699,7 +699,7 @@
         string $enclosure = '"',
         ?string $escape = null,
         int $version = PHP_VERSION_ID
-    ): array|false {
+    ): array | false {
         $escape = $escape ?? self::getDefaultEscapeCharacter();
         if ($version >= 80400 && $escape !== '') {
             return @fgetcsv($stream, $length, $separator, $enclosure, $escape);

src/PhpSpreadsheet/Calculation/Statistical/Conditional.php

Spacing +8 added lines, -8 removed lines

@@ -29,7 +29,7 @@ 
      * @param null|array|string $condition the criteria that defines which cells will be checked
      * @param mixed $averageRange Data values
      */
-    public static function AVERAGEIF(mixed $range, null|array|string $condition, mixed $averageRange = []): null|int|float|string
+    public static function AVERAGEIF(mixed $range, null | array | string $condition, mixed $averageRange = []): null | int | float | string
     {
         if (!is_array($range) || !is_array($averageRange) || array_key_exists(0, $range) || array_key_exists(0, $averageRange)) {
             $refError = ExcelError::REF();
@@ -55,7 +55,7 @@ 
      *
      * @param mixed $args Pairs of Ranges and Criteria
      */
-    public static function AVERAGEIFS(mixed ...$args): null|int|float|string
+    public static function AVERAGEIFS(mixed ...$args): null | int | float | string
     {
         if (empty($args)) {
             return 0.0;
@@ -85,7 +85,7 @@ 
      * @param mixed $range Data values, expect array
      * @param null|array|string $condition the criteria that defines which cells will be counted
      */
-    public static function COUNTIF(mixed $range, null|array|string $condition): string|int
+    public static function COUNTIF(mixed $range, null | array | string $condition): string | int
     {
         if (
             !is_array($range)
@@ -119,7 +119,7 @@ 
      *
      * @param mixed $args Pairs of Ranges and Criteria
      */
-    public static function COUNTIFS(mixed ...$args): int|string
+    public static function COUNTIFS(mixed ...$args): int | string
     {
         if (empty($args)) {
             return 0;
@@ -143,7 +143,7 @@ 
      *
      * @param mixed $args Pairs of Ranges and Criteria
      */
-    public static function MAXIFS(mixed ...$args): null|float|string
+    public static function MAXIFS(mixed ...$args): null | float | string
     {
         if (empty($args)) {
             return 0.0;
@@ -165,7 +165,7 @@ 
      *
      * @param mixed $args Pairs of Ranges and Criteria
      */
-    public static function MINIFS(mixed ...$args): null|float|string
+    public static function MINIFS(mixed ...$args): null | float | string
     {
         if (empty($args)) {
             return 0.0;
@@ -188,7 +188,7 @@ 
      * @param mixed $range Data values, expecting array
      * @param mixed $sumRange Data values, expecting array
      */
-    public static function SUMIF(mixed $range, mixed $condition, mixed $sumRange = []): null|float|string
+    public static function SUMIF(mixed $range, mixed $condition, mixed $sumRange = []): null | float | string
     {
         if (
             !is_array($range)
@@ -219,7 +219,7 @@ 
      *
      * @param mixed $args Pairs of Ranges and Criteria
      */
-    public static function SUMIFS(mixed ...$args): null|float|string
+    public static function SUMIFS(mixed ...$args): null | float | string
     {
         if (empty($args)) {
             return 0.0;

tests/PhpSpreadsheetTests/Calculation/Functions/Engineering/Oct2DecTest.php

Spacing +2 added lines, -2 removed lines

@@ -29,7 +29,7 @@ 
     }
 
     #[DataProvider('providerOCT2DEC')]
-    public function testDirectCallToOCT2DEC(mixed $expectedResult, bool|string $value): void
+    public function testDirectCallToOCT2DEC(mixed $expectedResult, bool | string $value): void
     {
         $result = ConvertOctal::toDecimal($value);
         self::assertSame($expectedResult, $result);
@@ -98,7 +98,7 @@ 
     }
 
     #[DataProvider('providerOCT2DECOds')]
-    public function testOCT2DECOds(mixed $expectedResult, bool|string $value): void
+    public function testOCT2DECOds(mixed $expectedResult, bool | string $value): void
     {
         Functions::setCompatibilityMode(
             Functions::COMPATIBILITY_OPENOFFICE

tests/PhpSpreadsheetTests/Calculation/Functions/Engineering/Bin2DecTest.php

Spacing +2 added lines, -2 removed lines

@@ -29,7 +29,7 @@ 
     }
 
     #[DataProvider('providerBIN2DEC')]
-    public function testDirectCallToBIN2DEC(float|int|string $expectedResult, bool|int|string $arg1): void
+    public function testDirectCallToBIN2DEC(float | int | string $expectedResult, bool | int | string $arg1): void
     {
         $result = ConvertBinary::toDecimal($arg1);
         self::assertSame($expectedResult, $result);
@@ -98,7 +98,7 @@ 
     }
 
     #[DataProvider('providerBIN2DECOds')]
-    public function testBIN2DECOds(float|int|string $expectedResult, bool $arg1): void
+    public function testBIN2DECOds(float | int | string $expectedResult, bool $arg1): void
     {
         Functions::setCompatibilityMode(
             Functions::COMPATIBILITY_OPENOFFICE

tests/PhpSpreadsheetTests/Calculation/Functions/Engineering/Hex2DecTest.php

Spacing +2 added lines, -2 removed lines

@@ -29,7 +29,7 @@ 
     }
 
     #[DataProvider('providerHEX2DEC')]
-    public function testDirectCallToHEX2DEC(mixed $expectedResult, bool|float|int|string $value): void
+    public function testDirectCallToHEX2DEC(mixed $expectedResult, bool | float | int | string $value): void
     {
         $result = ConvertHex::toDecimal($value);
         self::assertSame($expectedResult, $result);
@@ -98,7 +98,7 @@ 
     }
 
     #[DataProvider('providerHEX2DECOds')]
-    public function testHEX2DECOds(mixed $expectedResult, bool|float|int|string $value): void
+    public function testHEX2DECOds(mixed $expectedResult, bool | float | int | string $value): void
     {
         Functions::setCompatibilityMode(
             Functions::COMPATIBILITY_OPENOFFICE

tests/PhpSpreadsheetTests/Calculation/CustomFunction.php

Spacing +1 added lines, -1 removed lines

@@ -9,7 +9,7 @@
 
 class CustomFunction
 {
-    public static function fourthPower(mixed $number): float|int|string
+    public static function fourthPower(mixed $number): float | int | string
     {
         try {
             $number = Helpers::validateNumericNullBool($number);