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;

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/Worksheet/Table/TableTest.php

Spacing +1 added lines, -1 removed lines

@@ -158,7 +158,7 @@
     /**
      * @param AddressRange<CellAddress>|array{0: int, 1: int, 2: int, 3: int}|array{0: int, 1: int}|string $fullRange
      */
-    public function xtestSetRangeValidRange(string|array|AddressRange $fullRange, string $actualRange): void
+    public function xtestSetRangeValidRange(string | array | AddressRange $fullRange, string $actualRange): void
     {
         $table = new Table(self::INITIAL_RANGE);
 

src/PhpSpreadsheet/Chart/Properties.php

Spacing +10 added lines, -10 removed lines

@@ -178,7 +178,7 @@ 
         return ((float) $value) / self::PERCENTAGE_MULTIPLIER;
     }
 
-    protected function setColorProperties(?string $color, null|float|int|string $alpha, ?string $colorType): array
+    protected function setColorProperties(?string $color, null | float | int | string $alpha, ?string $colorType): array
     {
         return [
             'type' => $colorType,
@@ -403,7 +403,7 @@ 
     /**
      * Get value of array element.
      */
-    protected function getArrayElementsValue(array $properties, array|int|string $elements): mixed
+    protected function getArrayElementsValue(array $properties, array | int | string $elements): mixed
     {
         $reference = &$properties;
         if (!is_array($elements)) {
@@ -437,7 +437,7 @@ 
     /**
      * Get Glow Property.
      */
-    public function getGlowProperty(array|string $property): null|array|float|int|string
+    public function getGlowProperty(array | string $property): null | array | float | int | string
     {
         $retVal = null;
         if ($property === 'size') {
@@ -458,7 +458,7 @@ 
     /**
      * Get Glow Color Property.
      */
-    public function getGlowColor(string $propertyName): null|int|string
+    public function getGlowColor(string $propertyName): null | int | string
     {
         return $this->glowColor->getColorProperty($propertyName);
     }
@@ -522,7 +522,7 @@ 
     /**
      * Set Shadow Properties.
      */
-    public function setShadowProperties(int $presets, ?string $colorValue = null, ?string $colorType = null, null|float|int|string $colorAlpha = null, ?float $blur = null, ?int $angle = null, ?float $distance = null): void
+    public function setShadowProperties(int $presets, ?string $colorValue = null, ?string $colorType = null, null | float | int | string $colorAlpha = null, ?float $blur = null, ?int $angle = null, ?float $distance = null): void
     {
         $this->activateObject()->setShadowPresetsProperties((int) $presets);
         if ($presets === 0) {
@@ -605,7 +605,7 @@ 
      *
      * @return $this
      */
-    protected function setShadowAngle(null|float|int|string $angle)
+    protected function setShadowAngle(null | float | int | string $angle)
     {
         if (is_numeric($angle)) {
             $this->shadowProperties['direction'] = $angle;
@@ -638,7 +638,7 @@ 
      *
      * @param string|string[] $elements
      */
-    public function getShadowProperty($elements): array|string|null
+    public function getShadowProperty($elements): array | string | null
     {
         if ($elements === 'color') {
             return [
@@ -726,7 +726,7 @@ 
     /**
      * Get Line Color Property.
      */
-    public function getLineColorProperty(string $propertyName): null|int|string
+    public function getLineColorProperty(string $propertyName): null | int | string
     {
         return $this->lineColor->getColorProperty($propertyName);
     }
@@ -735,7 +735,7 @@ 
      * Set Line Style Properties.
      */
     public function setLineStyleProperties(
-        null|float|int|string $lineWidth = null,
+        null | float | int | string $lineWidth = null,
         ?string $compoundType = '',
         ?string $dashType = '',
         ?string $capType = '',
@@ -831,7 +831,7 @@ 
     /**
      * Get Line Style Property.
      */
-    public function getLineStyleProperty(array|string $elements): ?string
+    public function getLineStyleProperty(array | string $elements): ?string
     {
         $retVal = $this->getArrayElementsValue($this->lineStyleProperties, $elements);
         if (is_scalar($retVal)) {

src/PhpSpreadsheet/Style/ConditionalFormatting/CellMatcher.php

Spacing +3 added lines, -3 removed lines

@@ -114,7 +114,7 @@ 
         };
     }
 
-    protected function wrapValue(mixed $value): float|int|string
+    protected function wrapValue(mixed $value): float | int | string
     {
         if (!is_numeric($value)) {
             if (is_bool($value)) {
@@ -129,14 +129,14 @@ 
         return $value;
     }
 
-    protected function wrapCellValue(): float|int|string
+    protected function wrapCellValue(): float | int | string
     {
         $this->cell = $this->worksheet->getCell([$this->cellColumn, $this->cellRow]);
 
         return $this->wrapValue($this->cell->getCalculatedValue());
     }
 
-    protected function conditionCellAdjustment(array $matches): float|int|string
+    protected function conditionCellAdjustment(array $matches): float | int | string
     {
         $column = $matches[6];
         $row = $matches[7];