PHPOffice / PhpSpreadsheet

src/PhpSpreadsheet/Worksheet/Worksheet.php

Spacing +16 added lines, -16 removed lines

@@ -1111,7 +1111,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);
@@ -1136,7 +1136,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);
@@ -1157,7 +1157,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);
@@ -1389,7 +1389,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
     {
         $cellCoordinate = Validations::validateCellOrCellRange($cellCoordinate);
 
@@ -1596,7 +1596,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));
 
@@ -1693,7 +1693,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));
 
@@ -1813,7 +1813,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));
 
@@ -1866,7 +1866,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));
 
@@ -1887,7 +1887,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));
 
@@ -1946,7 +1946,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;
@@ -2091,7 +2091,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,
@@ -2601,7 +2601,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));
 
@@ -2626,7 +2626,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));
 
@@ -2691,7 +2691,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);
@@ -3150,7 +3150,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): array|null|string
+    public static function extractSheetTitle(?string $range, bool $returnRange = false): array | null | string
     {
         if (empty($range)) {
             return $returnRange ? [null, null] : null;

tests/PhpSpreadsheetTests/Document/PropertiesTest.php

Spacing +3 added lines, -3 removed lines

@@ -47,7 +47,7 @@ 
     /**
      * @dataProvider providerCreationTime
      */
-    public function testSetCreated(null|int $expectedCreationTime, null|int|string $created): void
+    public function testSetCreated(null | int $expectedCreationTime, null | int | string $created): void
     {
         $expectedCreationTime = $expectedCreationTime ?? $this->startTime;
 
@@ -76,7 +76,7 @@ 
     /**
      * @dataProvider providerModifiedTime
      */
-    public function testSetModified(mixed $expectedModifiedTime, null|int|string $modified): void
+    public function testSetModified(mixed $expectedModifiedTime, null | int | string $modified): void
     {
         $expectedModifiedTime = $expectedModifiedTime ?? $this->startTime;
 
@@ -153,7 +153,7 @@ 
     /**
      * @dataProvider providerCustomProperties
      */
-    public function testSetCustomProperties(mixed $expectedType, mixed $expectedValue, string $propertyName, null|bool|float|int|string $propertyValue, ?string $propertyType = null): void
+    public function testSetCustomProperties(mixed $expectedType, mixed $expectedValue, string $propertyName, null | bool | float | int | string $propertyValue, ?string $propertyType = null): void
     {
         if ($propertyType === null) {
             $this->properties->setCustomProperty($propertyName, $propertyValue);

tests/PhpSpreadsheetTests/Cell/CellAddressTest.php

Spacing +1 added lines, -1 removed lines

@@ -84,7 +84,7 @@
     /**
      * @dataProvider providerCreateFromColumnRowException
      */
-    public function testCreateFromColumnRowException(int|string $columnId, int|string $rowId): void
+    public function testCreateFromColumnRowException(int | string $columnId, int | string $rowId): void
     {
         $this->expectException(Exception::class);
         $this->expectExceptionMessage('Row and Column Ids must be positive integer values');

src/PhpSpreadsheet/Style/NumberFormat/Wizard/DateTime.php

Spacing +1 added lines, -1 removed lines

@@ -28,7 +28,7 @@
         $this->formatBlocks = array_map([$this, 'mapFormatBlocks'], $formatBlocks);
     }
 
-    private function mapFormatBlocks(DateTimeWizard|string $value): string
+    private function mapFormatBlocks(DateTimeWizard | string $value): string
     {
         // Any date masking codes are returned as lower case values
         if ($value instanceof DateTimeWizard) {

src/PhpSpreadsheet/Worksheet/AutoFilter/Column.php

Spacing +1 added lines, -1 removed lines

@@ -252,7 +252,7 @@
      *
      * @param string $name Attribute Name
      */
-    public function getAttribute(string $name): null|float|int|string
+    public function getAttribute(string $name): null | float | int | string
     {
         if (isset($this->attributes[$name])) {
             return $this->attributes[$name];

src/PhpSpreadsheet/Style/ConditionalFormatting/Wizard/CellValue.php

Spacing +1 added lines, -1 removed lines

@@ -70,7 +70,7 @@
     }
 
     /** @param null|bool|float|int|string $value value to be wrapped */
-    protected function wrapValue(mixed $value, string $operandValueType): float|int|string
+    protected function wrapValue(mixed $value, string $operandValueType): float | int | string
     {
         if (!is_numeric($value) && !is_bool($value) && null !== $value) {
             if ($operandValueType === Wizard::VALUE_TYPE_LITERAL) {

src/PhpSpreadsheet/Calculation/MathTrig/Operations.php

Spacing +4 added lines, -4 removed lines

@@ -23,7 +23,7 @@ 
      *         If an array of numbers is passed as an argument, then the returned result will also be an array
      *            with the same dimensions
      */
-    public static function mod(mixed $dividend, mixed $divisor): array|string|float
+    public static function mod(mixed $dividend, mixed $divisor): array | string | float
     {
         if (is_array($dividend) || is_array($divisor)) {
             return self::evaluateArrayArguments([self::class, __FUNCTION__], $dividend, $divisor);
@@ -59,7 +59,7 @@ 
      *         If an array of numbers is passed as an argument, then the returned result will also be an array
      *            with the same dimensions
      */
-    public static function power(null|array|bool|float|int|string $x, null|array|bool|float|int|string $y): array|float|int|string
+    public static function power(null | array | bool | float | int | string $x, null | array | bool | float | int | string $y): array | float | int | string
     {
         if (is_array($x) || is_array($y)) {
             return self::evaluateArrayArguments([self::class, __FUNCTION__], $x, $y);
@@ -96,7 +96,7 @@ 
      *
      * @param mixed ...$args Data values
      */
-    public static function product(mixed ...$args): string|float
+    public static function product(mixed ...$args): string | float
     {
         $args = array_filter(
             Functions::flattenArray($args),
@@ -136,7 +136,7 @@ 
      * @return array|int|string If an array of numbers is passed as an argument, then the returned result will also be an array
      *            with the same dimensions
      */
-    public static function quotient(mixed $numerator, mixed $denominator): array|string|int
+    public static function quotient(mixed $numerator, mixed $denominator): array | string | int
     {
         if (is_array($numerator) || is_array($denominator)) {
             return self::evaluateArrayArguments([self::class, __FUNCTION__], $numerator, $denominator);

src/PhpSpreadsheet/Reader/Xlsx/ConditionalStyles.php

Spacing +1 added lines, -1 removed lines

@@ -282,7 +282,7 @@
         return $dataBar;
     }
 
-    private function readColorScale(SimpleXMLElement|stdClass $cfRule): ConditionalColorScale
+    private function readColorScale(SimpleXMLElement | stdClass $cfRule): ConditionalColorScale
     {
         $colorScale = new ConditionalColorScale();
         $count = count($cfRule->colorScale->cfvo);

tests/PhpSpreadsheetTests/Calculation/CalculationFunctionListTest.php

Spacing +1 added lines, -1 removed lines

@@ -33,7 +33,7 @@
     /**
      * @dataProvider providerGetFunctions
      */
-    public function testGetFunctions(array|string $functionCall): void
+    public function testGetFunctions(array | string $functionCall): void
     {
         self::assertIsCallable($functionCall);
     }