PHPOffice / PhpSpreadsheet

tests/PhpSpreadsheetTests/Cell/CoordinateTest.php

Spacing +1 added lines, -1 removed lines

@@ -180,7 +180,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);

tests/PhpSpreadsheetTests/Shared/CodePageTest.php

Spacing +1 added lines, -1 removed lines

@@ -15,7 +15,7 @@
      *
      * @param string|string[] $expectedResult
      */
-    public function testCodePageNumberToName(array|string $expectedResult, int $codePageIndex): void
+    public function testCodePageNumberToName(array | string $expectedResult, int $codePageIndex): void
     {
         if ($expectedResult === 'exception') {
             $this->expectException(Exception::class);

tests/PhpSpreadsheetTests/Shared/FontTest.php

Spacing +2 added lines, -2 removed lines

@@ -44,7 +44,7 @@ 
     /**
      * @dataProvider providerFontSizeToPixels
      */
-    public function testFontSizeToPixels(float|int $expectedResult, float|int $size): void
+    public function testFontSizeToPixels(float | int $expectedResult, float | int $size): void
     {
         $result = Font::fontSizeToPixels($size);
         self::assertEquals($expectedResult, $result);
@@ -58,7 +58,7 @@ 
     /**
      * @dataProvider providerInchSizeToPixels
      */
-    public function testInchSizeToPixels(float|int $expectedResult, float|int $size): void
+    public function testInchSizeToPixels(float | int $expectedResult, float | int $size): void
     {
         $result = Font::inchSizeToPixels($size);
         self::assertEqualsWithDelta($expectedResult, $result, self::FONT_PRECISION);

src/PhpSpreadsheet/Calculation/Engineering/Compare.php

Spacing +2 added lines, -2 removed lines

@@ -29,7 +29,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 DELTA(array|float|bool|string|int $a, array|float|bool|string|int $b = 0.0): array|string|int
+    public static function DELTA(array | float | bool | string | int $a, array | float | bool | string | int $b = 0.0): array | string | int
     {
         if (is_array($a) || is_array($b)) {
             return self::evaluateArrayArguments([self::class, __FUNCTION__], $a, $b);
@@ -64,7 +64,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 GESTEP(array|float|bool|string|int $number, $step = 0.0): array|string|int
+    public static function GESTEP(array | float | bool | string | int $number, $step = 0.0): array | string | int
     {
         if (is_array($number) || is_array($step)) {
             return self::evaluateArrayArguments([self::class, __FUNCTION__], $number, $step);

src/PhpSpreadsheet/Shared/Font.php

Spacing +7 added lines, -7 removed lines

@@ -329,12 +329,12 @@ 
     /**
      * Pad amount for exact in pixels; use best guess if null.
      */
-    private static null|float|int $paddingAmountExact = null;
+    private static null | float | int $paddingAmountExact = null;
 
     /**
      * Set pad amount for exact in pixels; use best guess if null.
      */
-    public static function setPaddingAmountExact(null|float|int $paddingAmountExact): void
+    public static function setPaddingAmountExact(null | float | int $paddingAmountExact): void
     {
         self::$paddingAmountExact = $paddingAmountExact;
     }
@@ -342,7 +342,7 @@ 
     /**
      * Get pad amount for exact in pixels; or null if using best guess.
      */
-    public static function getPaddingAmountExact(): null|float|int
+    public static function getPaddingAmountExact(): null | float | int
     {
         return self::$paddingAmountExact;
     }
@@ -503,7 +503,7 @@ 
      *
      * @return int Font size (in pixels)
      */
-    public static function fontSizeToPixels(float|int $fontSizeInPoints): int
+    public static function fontSizeToPixels(float | int $fontSizeInPoints): int
     {
         return (int) ((4 / 3) * $fontSizeInPoints);
     }
@@ -515,7 +515,7 @@ 
      *
      * @return float|int Size (in pixels)
      */
-    public static function inchSizeToPixels(int|float $sizeInInch): int|float
+    public static function inchSizeToPixels(int | float $sizeInInch): int | float
     {
         return $sizeInInch * 96;
     }
@@ -527,7 +527,7 @@ 
      *
      * @return float Size (in pixels)
      */
-    public static function centimeterSizeToPixels(int|float $sizeInCm): float
+    public static function centimeterSizeToPixels(int | float $sizeInCm): float
     {
         return $sizeInCm * 37.795275591;
     }
@@ -628,7 +628,7 @@ 
      *
      * @return ($returnAsPixels is true ? int : float) Column width
      */
-    public static function getDefaultColumnWidthByFont(FontStyle $font, bool $returnAsPixels = false): float|int
+    public static function getDefaultColumnWidthByFont(FontStyle $font, bool $returnAsPixels = false): float | int
     {
         if (isset(self::DEFAULT_COLUMN_WIDTHS[$font->getName()][$font->getSize()])) {
             // Exact width can be determined

src/PhpSpreadsheet/Reader/Xlsx/Properties.php

Spacing +1 added lines, -1 removed lines

@@ -91,7 +91,7 @@
         }
     }
 
-    private function getArrayItem(null|array|false $array): string
+    private function getArrayItem(null | array | false $array): string
     {
         return is_array($array) ? (string) ($array[0] ?? '') : '';
     }

src/PhpSpreadsheet/Document/Properties.php

Spacing +38 added lines, -38 removed lines

@@ -36,12 +36,12 @@ 
     /**
      * Created.
      */
-    private float|int $created;
+    private float | int $created;
 
     /**
      * Modified.
      */
-    private float|int $modified;
+    private float | int $modified;
 
     /**
      * Title.
@@ -140,7 +140,7 @@ 
         return $this;
     }
 
-    private static function intOrFloatTimestamp(null|float|int|string $timestamp): float|int
+    private static function intOrFloatTimestamp(null | float | int | string $timestamp): float | int
     {
         if ($timestamp === null) {
             $timestamp = (float) (new DateTime())->format('U');
@@ -161,7 +161,7 @@ 
     /**
      * Get Created.
      */
-    public function getCreated(): float|int
+    public function getCreated(): float | int
     {
         return $this->created;
     }
@@ -171,7 +171,7 @@ 
      *
      * @return $this
      */
-    public function setCreated(null|float|int|string $timestamp): self
+    public function setCreated(null | float | int | string $timestamp): self
     {
         $this->created = self::intOrFloatTimestamp($timestamp);
 
@@ -181,7 +181,7 @@ 
     /**
      * Get Modified.
      */
-    public function getModified(): float|int
+    public function getModified(): float | int
     {
         return $this->modified;
     }
@@ -191,7 +191,7 @@ 
      *
      * @return $this
      */
-    public function setModified(null|float|int|string $timestamp): self
+    public function setModified(null | float | int | string $timestamp): self
     {
         $this->modified = self::intOrFloatTimestamp($timestamp);
 
@@ -359,7 +359,7 @@ 
     /**
      * Get a Custom Property Value.
      */
-    public function getCustomPropertyValue(string $propertyName): bool|int|float|string|null
+    public function getCustomPropertyValue(string $propertyName): bool | int | float | string | null
     {
         if (isset($this->customProperties[$propertyName])) {
             return $this->customProperties[$propertyName]['value'];
@@ -376,7 +376,7 @@ 
         return $this->customProperties[$propertyName]['type'] ?? null;
     }
 
-    private function identifyPropertyType(bool|int|float|string|null $propertyValue): string
+    private function identifyPropertyType(bool | int | float | string | null $propertyValue): string
     {
         if (is_float($propertyValue)) {
             return self::PROPERTY_TYPE_FLOAT;
@@ -398,7 +398,7 @@ 
      *
      * @return $this
      */
-    public function setCustomProperty(string $propertyName, bool|int|float|string|null $propertyValue = '', ?string $propertyType = null): self
+    public function setCustomProperty(string $propertyName, bool | int | float | string | null $propertyValue = '', ?string $propertyType = null): self
     {
         if (($propertyType === null) || (!in_array($propertyType, self::VALID_PROPERTY_TYPE_LIST))) {
             $propertyType = $this->identifyPropertyType($propertyValue);
@@ -415,32 +415,32 @@ 
     }
 
     private const PROPERTY_TYPE_ARRAY = [
-        'i' => self::PROPERTY_TYPE_INTEGER,      //    Integer
-        'i1' => self::PROPERTY_TYPE_INTEGER,     //    1-Byte Signed Integer
-        'i2' => self::PROPERTY_TYPE_INTEGER,     //    2-Byte Signed Integer
-        'i4' => self::PROPERTY_TYPE_INTEGER,     //    4-Byte Signed Integer
-        'i8' => self::PROPERTY_TYPE_INTEGER,     //    8-Byte Signed Integer
-        'int' => self::PROPERTY_TYPE_INTEGER,    //    Integer
-        'ui1' => self::PROPERTY_TYPE_INTEGER,    //    1-Byte Unsigned Integer
-        'ui2' => self::PROPERTY_TYPE_INTEGER,    //    2-Byte Unsigned Integer
-        'ui4' => self::PROPERTY_TYPE_INTEGER,    //    4-Byte Unsigned Integer
-        'ui8' => self::PROPERTY_TYPE_INTEGER,    //    8-Byte Unsigned Integer
-        'uint' => self::PROPERTY_TYPE_INTEGER,   //    Unsigned Integer
-        'f' => self::PROPERTY_TYPE_FLOAT,        //    Real Number
-        'r4' => self::PROPERTY_TYPE_FLOAT,       //    4-Byte Real Number
-        'r8' => self::PROPERTY_TYPE_FLOAT,       //    8-Byte Real Number
-        'decimal' => self::PROPERTY_TYPE_FLOAT,  //    Decimal
-        's' => self::PROPERTY_TYPE_STRING,       //    String
-        'empty' => self::PROPERTY_TYPE_STRING,   //    Empty
-        'null' => self::PROPERTY_TYPE_STRING,    //    Null
-        'lpstr' => self::PROPERTY_TYPE_STRING,   //    LPSTR
-        'lpwstr' => self::PROPERTY_TYPE_STRING,  //    LPWSTR
-        'bstr' => self::PROPERTY_TYPE_STRING,    //    Basic String
-        'd' => self::PROPERTY_TYPE_DATE,         //    Date and Time
-        'date' => self::PROPERTY_TYPE_DATE,      //    Date and Time
-        'filetime' => self::PROPERTY_TYPE_DATE,  //    File Time
-        'b' => self::PROPERTY_TYPE_BOOLEAN,      //    Boolean
-        'bool' => self::PROPERTY_TYPE_BOOLEAN,   //    Boolean
+        'i' => self::PROPERTY_TYPE_INTEGER, //    Integer
+        'i1' => self::PROPERTY_TYPE_INTEGER, //    1-Byte Signed Integer
+        'i2' => self::PROPERTY_TYPE_INTEGER, //    2-Byte Signed Integer
+        'i4' => self::PROPERTY_TYPE_INTEGER, //    4-Byte Signed Integer
+        'i8' => self::PROPERTY_TYPE_INTEGER, //    8-Byte Signed Integer
+        'int' => self::PROPERTY_TYPE_INTEGER, //    Integer
+        'ui1' => self::PROPERTY_TYPE_INTEGER, //    1-Byte Unsigned Integer
+        'ui2' => self::PROPERTY_TYPE_INTEGER, //    2-Byte Unsigned Integer
+        'ui4' => self::PROPERTY_TYPE_INTEGER, //    4-Byte Unsigned Integer
+        'ui8' => self::PROPERTY_TYPE_INTEGER, //    8-Byte Unsigned Integer
+        'uint' => self::PROPERTY_TYPE_INTEGER, //    Unsigned Integer
+        'f' => self::PROPERTY_TYPE_FLOAT, //    Real Number
+        'r4' => self::PROPERTY_TYPE_FLOAT, //    4-Byte Real Number
+        'r8' => self::PROPERTY_TYPE_FLOAT, //    8-Byte Real Number
+        'decimal' => self::PROPERTY_TYPE_FLOAT, //    Decimal
+        's' => self::PROPERTY_TYPE_STRING, //    String
+        'empty' => self::PROPERTY_TYPE_STRING, //    Empty
+        'null' => self::PROPERTY_TYPE_STRING, //    Null
+        'lpstr' => self::PROPERTY_TYPE_STRING, //    LPSTR
+        'lpwstr' => self::PROPERTY_TYPE_STRING, //    LPWSTR
+        'bstr' => self::PROPERTY_TYPE_STRING, //    Basic String
+        'd' => self::PROPERTY_TYPE_DATE, //    Date and Time
+        'date' => self::PROPERTY_TYPE_DATE, //    Date and Time
+        'filetime' => self::PROPERTY_TYPE_DATE, //    File Time
+        'b' => self::PROPERTY_TYPE_BOOLEAN, //    Boolean
+        'bool' => self::PROPERTY_TYPE_BOOLEAN, //    Boolean
     ];
 
     private const SPECIAL_TYPES = [
@@ -451,7 +451,7 @@ 
     /**
      * Convert property to form desired by Excel.
      */
-    public static function convertProperty(bool|int|float|string|null $propertyValue, string $propertyType): bool|int|float|string|null
+    public static function convertProperty(bool | int | float | string | null $propertyValue, string $propertyType): bool | int | float | string | null
     {
         return self::SPECIAL_TYPES[$propertyType] ?? self::convertProperty2($propertyValue, $propertyType);
     }
@@ -459,7 +459,7 @@ 
     /**
      * Convert property to form desired by Excel.
      */
-    private static function convertProperty2(bool|int|float|string|null $propertyValue, string $type): bool|int|float|string|null
+    private static function convertProperty2(bool | int | float | string | null $propertyValue, string $type): bool | int | float | string | null
     {
         $propertyType = self::convertPropertyType($type);
         switch ($propertyType) {

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

Spacing +3 added lines, -3 removed lines

@@ -16,7 +16,7 @@ 
     /**
      * @dataProvider providerBITOR
      */
-    public function testDirectCallToBITOR(float|int|string $expectedResult, null|bool|int|float|string $arg1, null|bool|int|float|string $arg2): void
+    public function testDirectCallToBITOR(float | int | string $expectedResult, null | bool | int | float | string $arg1, null | bool | int | float | string $arg2): void
     {
         $result = BitWise::BITOR($arg1, $arg2);
         self::assertSame($expectedResult, $result);
@@ -25,7 +25,7 @@ 
     /**
      * @dataProvider providerBITOR
      */
-    public function testBITORAsFormula(float|int|string $expectedResult, mixed ...$args): void
+    public function testBITORAsFormula(float | int | string $expectedResult, mixed ...$args): void
     {
         $arguments = new FormulaArguments(...$args);
 
@@ -39,7 +39,7 @@ 
     /**
      * @dataProvider providerBITOR
      */
-    public function testBITORInWorksheet(float|int|string $expectedResult, mixed ...$args): void
+    public function testBITORInWorksheet(float | int | string $expectedResult, mixed ...$args): void
     {
         $arguments = new FormulaArguments(...$args);
 

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

Spacing +3 added lines, -3 removed lines

@@ -16,7 +16,7 @@ 
     /**
      * @dataProvider providerBITAND
      */
-    public function testDirectCallToBITAND(float|int|string $expectedResult, null|bool|int|float|string $arg1, null|bool|int|float|string $arg2): void
+    public function testDirectCallToBITAND(float | int | string $expectedResult, null | bool | int | float | string $arg1, null | bool | int | float | string $arg2): void
     {
         $result = BitWise::BITAND($arg1, $arg2);
         self::assertSame($expectedResult, $result);
@@ -25,7 +25,7 @@ 
     /**
      * @dataProvider providerBITAND
      */
-    public function testBITANDAsFormula(float|int|string $expectedResult, mixed ...$args): void
+    public function testBITANDAsFormula(float | int | string $expectedResult, mixed ...$args): void
     {
         $arguments = new FormulaArguments(...$args);
 
@@ -39,7 +39,7 @@ 
     /**
      * @dataProvider providerBITAND
      */
-    public function testBITANDInWorksheet(float|int|string $expectedResult, mixed ...$args): void
+    public function testBITANDInWorksheet(float | int | string $expectedResult, mixed ...$args): void
     {
         $arguments = new FormulaArguments(...$args);