PHPOffice / PhpSpreadsheet

tests/PhpSpreadsheetTests/Document/PropertiesTest.php

Spacing +2 added lines, -2 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 ??= $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 ??= $this->startTime;
 

src/PhpSpreadsheet/Style/ConditionalFormatting/ConditionalFormatValueObject.php

Spacing +3 added lines, -3 removed lines

@@ -4,7 +4,7 @@ 
 
 class ConditionalFormatValueObject
 {
-    public function __construct(private string $type, private null|float|int|string $value = null, private ?string $cellFormula = null)
+    public function __construct(private string $type, private null | float | int | string $value = null, private ?string $cellFormula = null)
     {
     }
 
@@ -20,12 +20,12 @@ 
         return $this;
     }
 
-    public function getValue(): null|float|int|string
+    public function getValue(): null | float | int | string
     {
         return $this->value;
     }
 
-    public function setValue(null|float|int|string $value): self
+    public function setValue(null | float | int | string $value): self
     {
         $this->value = $value;
 

src/PhpSpreadsheet/Chart/Title.php

Spacing +3 added lines, -3 removed lines

@@ -30,7 +30,7 @@ 
          *
          * @var array<RichText|string>|RichText|string
          */
-        private array|RichText|string $caption = '', /**
+        private array | RichText | string $caption = '', /**
          * Title Layout.
          */
         private ?Layout $layout = null,
@@ -42,7 +42,7 @@ 
     /**
      * Get caption.
      */
-    public function getCaption(): array|RichText|string
+    public function getCaption(): array | RichText | string
     {
         return $this->caption;
     }
@@ -81,7 +81,7 @@ 
      *
      * @return $this
      */
-    public function setCaption(array|RichText|string $caption): static
+    public function setCaption(array | RichText | string $caption): static
     {
         $this->caption = $caption;
 

src/PhpSpreadsheet/Chart/DataSeriesValues.php

Spacing +5 added lines, -5 removed lines

@@ -74,8 +74,8 @@ 
          * Series Point Marker.
          */
         private ?string $pointMarker = null,
-        null|ChartColor|array|string $fillColor = null,
-        int|string $pointSize = 3
+        null | ChartColor | array | string $fillColor = null,
+        int | string $pointSize = 3
     ) {
         parent::__construct();
         $this->markerFillColor = new ChartColor();
@@ -267,7 +267,7 @@ 
      *
      * @return string|string[] HEX color or array with HEX colors
      */
-    public function getFillColor(): string|array
+    public function getFillColor(): string | array
     {
         if ($this->fillColor === null) {
             return '';
@@ -330,7 +330,7 @@ 
     /**
      * Get line width for series.
      */
-    public function getLineWidth(): null|float|int
+    public function getLineWidth(): null | float | int
     {
         return $this->lineStyleProperties['width'];
     }
@@ -340,7 +340,7 @@ 
      *
      * @return $this
      */
-    public function setLineWidth(null|float|int $width): static
+    public function setLineWidth(null | float | int $width): static
     {
         $this->lineStyleProperties['width'] = $width;
 

src/PhpSpreadsheet/Chart/DataSeries.php

Spacing +3 added lines, -3 removed lines

@@ -218,7 +218,7 @@ 
      *
      * @return DataSeriesValues|false
      */
-    public function getPlotLabelByIndex(int $index): bool|DataSeriesValues
+    public function getPlotLabelByIndex(int $index): bool | DataSeriesValues
     {
         $keys = array_keys($this->plotLabel);
         if (in_array($index, $keys)) {
@@ -243,7 +243,7 @@ 
      *
      * @return DataSeriesValues|false
      */
-    public function getPlotCategoryByIndex(int $index): bool|DataSeriesValues
+    public function getPlotCategoryByIndex(int $index): bool | DataSeriesValues
     {
         $keys = array_keys($this->plotCategory);
         if (in_array($index, $keys)) {
@@ -290,7 +290,7 @@ 
      *
      * @return DataSeriesValues|false
      */
-    public function getPlotValuesByIndex(int $index): bool|DataSeriesValues
+    public function getPlotValuesByIndex(int $index): bool | DataSeriesValues
     {
         $keys = array_keys($this->plotValues);
         if (in_array($index, $keys)) {

src/PhpSpreadsheet/Reader/Xlsx/Chart.php

Spacing +4 added lines, -4 removed lines

@@ -26,7 +26,7 @@ 
     {
     }
 
-    private static function getAttributeString(SimpleXMLElement $component, string $name): string|null
+    private static function getAttributeString(SimpleXMLElement $component, string $name): string | null
     {
         $attributes = $component->attributes();
         if (@isset($attributes[$name])) {
@@ -36,7 +36,7 @@ 
         return null;
     }
 
-    private static function getAttributeInteger(SimpleXMLElement $component, string $name): int|null
+    private static function getAttributeInteger(SimpleXMLElement $component, string $name): int | null
     {
         $attributes = $component->attributes();
         if (@isset($attributes[$name])) {
@@ -46,7 +46,7 @@ 
         return null;
     }
 
-    private static function getAttributeBoolean(SimpleXMLElement $component, string $name): bool|null
+    private static function getAttributeBoolean(SimpleXMLElement $component, string $name): bool | null
     {
         $attributes = $component->attributes();
         if (@isset($attributes[$name])) {
@@ -58,7 +58,7 @@ 
         return null;
     }
 
-    private static function getAttributeFloat(SimpleXMLElement $component, string $name): float|null
+    private static function getAttributeFloat(SimpleXMLElement $component, string $name): float | null
     {
         $attributes = $component->attributes();
         if (@isset($attributes[$name])) {

src/PhpSpreadsheet/Reader/Xlsx/AutoFilter.php

Spacing +1 added lines, -1 removed lines

@@ -11,7 +11,7 @@
 
 class AutoFilter
 {
-    public function __construct(private Table|Worksheet $parent, private SimpleXMLElement $worksheetXml)
+    public function __construct(private Table | Worksheet $parent, private SimpleXMLElement $worksheetXml)
     {
     }
 

src/PhpSpreadsheet/Reader/Xls/Escher.php

Spacing +2 added lines, -2 removed lines

@@ -55,7 +55,7 @@ 
         /**
          * The object to be returned by the reader. Modified during load.
          */
-        private BSE|BstoreContainer|DgContainer|DggContainer|\PhpOffice\PhpSpreadsheet\Shared\Escher|SpContainer|SpgrContainer $object
+        private BSE | BstoreContainer | DgContainer | DggContainer | \PhpOffice\PhpSpreadsheet\Shared\Escher | SpContainer | SpgrContainer $object
     ) {
     }
 
@@ -83,7 +83,7 @@ 
     /**
      * Load Escher stream data. May be a partial Escher stream.
      */
-    public function load(string $data): BSE|BstoreContainer|DgContainer|DggContainer|\PhpOffice\PhpSpreadsheet\Shared\Escher|SpContainer|SpgrContainer
+    public function load(string $data): BSE | BstoreContainer | DgContainer | DggContainer | \PhpOffice\PhpSpreadsheet\Shared\Escher | SpContainer | SpgrContainer
     {
         $this->data = $data;
 

src/PhpSpreadsheet/Calculation/Calculation.php

Spacing +13 added lines, -13 removed lines

@@ -203,7 +203,7 @@ 
         return array_key_exists($key, self::$excelConstants);
     }
 
-    public static function getExcelConstants(string $key): bool|null
+    public static function getExcelConstants(string $key): bool | null
     {
         return self::$excelConstants[$key];
     }
@@ -3270,10 +3270,10 @@ 
     }
 
     /** @var ?array */
-    private static ?array $functionReplaceFromExcel = null;
+    private static ? array $functionReplaceFromExcel = null;
 
     /** @var ?array */
-    private static ?array $functionReplaceToLocale = null;
+    private static ? array $functionReplaceToLocale = null;
 
     /**
      * @deprecated 1.30.0 use translateFormulaToLocale() instead
@@ -3319,10 +3319,10 @@ 
     }
 
     /** @var ?array */
-    private static ?array $functionReplaceFromLocale = null;
+    private static ? array $functionReplaceFromLocale = null;
 
     /** @var ?array */
-    private static ?array $functionReplaceToExcel = null;
+    private static ? array $functionReplaceToExcel = null;
 
     /**
      * @deprecated 1.30.0 use translateFormulaToEnglish() instead
@@ -3530,7 +3530,7 @@ 
      *
      * @param string $formula Formula to parse
      */
-    public function parseFormula(string $formula): array|bool
+    public function parseFormula(string $formula): array | bool
     {
         //    Basic validation that this is indeed a formula
         //    We return an empty array if not
@@ -3924,7 +3924,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(', '))'];
@@ -4019,7 +4019,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;
@@ -5150,7 +5150,7 @@ 
         return true;
     }
 
-    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)) {
@@ -5189,7 +5189,7 @@ 
         return $result;
     }
 
-    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))) {
@@ -5206,7 +5206,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 (
@@ -5411,7 +5411,7 @@ 
      *
      * @return array|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 = [];
@@ -5552,7 +5552,7 @@ 
     /**
      * Add cell reference if needed while making sure that it is the last argument.
      */
-    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)) {