PHPOffice / PhpSpreadsheet

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);

src/PhpSpreadsheet/Reader/Xlsx.php

Spacing +4 added lines, -4 removed lines

@@ -2029,26 +2029,26 @@
         }
     }
 
-    private static function getArrayItem(null|array|bool|SimpleXMLElement $array, int|string $key = 0): mixed
+    private static function getArrayItem(null | array | bool | SimpleXMLElement $array, int | string $key = 0): mixed
     {
         return ($array === null || is_bool($array)) ? null : ($array[$key] ?? null);
     }
 
-    private static function getArrayItemString(null|array|bool|SimpleXMLElement $array, int|string $key = 0): string
+    private static function getArrayItemString(null | array | bool | SimpleXMLElement $array, int | string $key = 0): string
     {
         $retVal = self::getArrayItem($array, $key);
 
         return StringHelper::convertToString($retVal, false);
     }
 
-    private static function getArrayItemIntOrSxml(null|array|bool|SimpleXMLElement $array, int|string $key = 0): int|SimpleXMLElement
+    private static function getArrayItemIntOrSxml(null | array | bool | SimpleXMLElement $array, int | string $key = 0): int | SimpleXMLElement
     {
         $retVal = self::getArrayItem($array, $key);
 
         return (is_int($retVal) || $retVal instanceof SimpleXMLElement) ? $retVal : 0;
     }
 
-    private static function dirAdd(null|SimpleXMLElement|string $base, null|SimpleXMLElement|string $add): string
+    private static function dirAdd(null | SimpleXMLElement | string $base, null | SimpleXMLElement | string $add): string
     {
         $base = (string) $base;
         $add = (string) $add;

src/PhpSpreadsheet/Calculation/CalculationLocale.php

Spacing +4 added lines, -4 removed lines

@@ -327,9 +327,9 @@ 
         return $formula;
     }
 
-    private static ?array $functionReplaceFromExcel;
+    private static ? array $functionReplaceFromExcel;
 
-    private static ?array $functionReplaceToLocale;
+    private static ? array $functionReplaceToLocale;
 
     public function translateFormulaToLocale(string $formula): string
     {
@@ -364,9 +364,9 @@ 
         );
     }
 
-    protected static ?array $functionReplaceFromLocale;
+    protected static ? array $functionReplaceFromLocale;
 
-    protected static ?array $functionReplaceToExcel;
+    protected static ? array $functionReplaceToExcel;
 
     public function translateFormulaToEnglish(string $formula): string
     {

src/PhpSpreadsheet/Calculation/Calculation.php

Spacing +9 added lines, -9 removed lines

@@ -161,7 +161,7 @@ 
         return array_key_exists($key, self::EXCEL_CONSTANTS);
     }
 
-    public static function getExcelConstants(string $key): bool|null
+    public static function getExcelConstants(string $key): bool | null
     {
         return self::EXCEL_CONSTANTS[$key];
     }
@@ -527,7 +527,7 @@ 
      *
      * @param string $formula Formula to parse
      */
-    public function parseFormula(string $formula): array|bool
+    public function parseFormula(string $formula): array | bool
     {
         $formula = preg_replace_callback(
             self::CALCULATION_REGEXP_CELLREF_SPILL,
@@ -930,7 +930,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(', '))'];
@@ -1009,7 +1009,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;
@@ -2201,7 +2201,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)) {
@@ -2243,7 +2243,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))) {
@@ -2260,7 +2260,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 (
@@ -2477,7 +2477,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 = [];
@@ -2612,7 +2612,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)) {

tests/PhpSpreadsheetTests/Reader/Xlsx/MySpreadsheet.php

Spacing +1 added lines, -1 removed lines

@@ -8,7 +8,7 @@
 
 class MySpreadsheet extends Spreadsheet
 {
-    public function calcSquare(string $cellAddress): float|int|string
+    public function calcSquare(string $cellAddress): float | int | string
     {
         $value = $this->getActiveSheet()
             ->getCell($cellAddress)

src/PhpSpreadsheet/Reader/Html.php

Spacing +3 added lines, -3 removed lines

@@ -254,7 +254,7 @@ 
      *
      * @param-out string $cellContent In one case, it can be bool
      */
-    protected function flushCell(Worksheet $sheet, string $column, int|string $row, mixed &$cellContent, array $attributeArray): void
+    protected function flushCell(Worksheet $sheet, string $column, int | string $row, mixed &$cellContent, array $attributeArray): void
     {
         if (is_string($cellContent)) {
             //    Simple String content
@@ -304,7 +304,7 @@ 
     /** @var array<int, array<int, string>> */
     private static array $falseTrueArray = [];
 
-    private static function convertBoolean(?string $cellContent): bool|string
+    private static function convertBoolean(?string $cellContent): bool | string
     {
         if ($cellContent === '1') {
             return true;
@@ -892,7 +892,7 @@ 
      * TODO :
      * - Implement to other propertie, such as border
      */
-    private function applyInlineStyle(Worksheet &$sheet, int $row, string $column, array $attributeArray): void
+    private function applyInlineStyle(Worksheet & $sheet, int $row, string $column, array $attributeArray): void
     {
         if (!isset($attributeArray['style'])) {
             return;