PHPOffice / PhpSpreadsheet

src/PhpSpreadsheet/Calculation/TextData/Trim.php

Spacing +1 added lines, -1 removed lines

@@ -37,7 +37,7 @@
      * @return array<mixed>|string If an array of values is passed as the argument, then the returned result will also be an array
      *            with the same dimensions
      */
-    public static function spaces(mixed $stringValue = ''): array|string
+    public static function spaces(mixed $stringValue = ''): array | string
     {
         if (is_array($stringValue)) {
             return self::evaluateSingleArgumentArray([self::class, __FUNCTION__], $stringValue);

src/PhpSpreadsheet/Calculation/TextData/Concatenate.php

Spacing +4 added lines, -4 removed lines

@@ -51,7 +51,7 @@ 
      *
      * @return array<string>|string
      */
-    public static function actualCONCATENATE(...$args): array|string
+    public static function actualCONCATENATE(...$args): array | string
     {
         if (Functions::getCompatibilityMode() === Functions::COMPATIBILITY_GNUMERIC) {
             return self::CONCATENATE(...$args);
@@ -73,7 +73,7 @@ 
      *
      * @return array<string>|string
      */
-    private static function concatenate2Args(array|string $operand1, null|array|bool|float|int|string $operand2): array|string
+    private static function concatenate2Args(array | string $operand1, null | array | bool | float | int | string $operand2): array | string
     {
         if (is_array($operand1) || is_array($operand2)) {
             $operand1 = Calculation::boolToString($operand1);
@@ -124,7 +124,7 @@ 
      *         If an array of values is passed for the $delimiter or $ignoreEmpty arguments, then the returned result
      *            will also be an array with matching dimensions
      */
-    public static function TEXTJOIN($delimiter = '', $ignoreEmpty = true, mixed ...$args): array|string
+    public static function TEXTJOIN($delimiter = '', $ignoreEmpty = true, mixed ...$args): array | string
     {
         if (is_array($delimiter) || is_array($ignoreEmpty)) {
             return self::evaluateArrayArgumentsSubset(
@@ -183,7 +183,7 @@ 
      *         If an array of values is passed for the $stringValue or $repeatCount arguments, then the returned result
      *            will also be an array with matching dimensions
      */
-    public static function builtinREPT(mixed $stringValue, mixed $repeatCount): array|string
+    public static function builtinREPT(mixed $stringValue, mixed $repeatCount): array | string
     {
         if (is_array($stringValue) || is_array($repeatCount)) {
             return self::evaluateArrayArguments([self::class, __FUNCTION__], $stringValue, $repeatCount);

src/PhpSpreadsheet/Calculation/TextData/CaseConvert.php

Spacing +3 added lines, -3 removed lines

@@ -21,7 +21,7 @@ 
      * @return array<mixed>|string If an array of values is passed as the argument, then the returned result will also be an array
      *            with the same dimensions
      */
-    public static function lower(mixed $mixedCaseValue): array|string
+    public static function lower(mixed $mixedCaseValue): array | string
     {
         if (is_array($mixedCaseValue)) {
             return self::evaluateSingleArgumentArray([self::class, __FUNCTION__], $mixedCaseValue);
@@ -47,7 +47,7 @@ 
      * @return array<mixed>|string If an array of values is passed as the argument, then the returned result will also be an array
      *            with the same dimensions
      */
-    public static function upper(mixed $mixedCaseValue): array|string
+    public static function upper(mixed $mixedCaseValue): array | string
     {
         if (is_array($mixedCaseValue)) {
             return self::evaluateSingleArgumentArray([self::class, __FUNCTION__], $mixedCaseValue);
@@ -73,7 +73,7 @@ 
      * @return array<mixed>|string If an array of values is passed as the argument, then the returned result will also be an array
      *            with the same dimensions
      */
-    public static function proper(mixed $mixedCaseValue): array|string
+    public static function proper(mixed $mixedCaseValue): array | string
     {
         if (is_array($mixedCaseValue)) {
             return self::evaluateSingleArgumentArray([self::class, __FUNCTION__], $mixedCaseValue);

src/PhpSpreadsheet/Calculation/Calculation.php

Spacing +11 added lines, -11 removed lines

@@ -164,7 +164,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];
     }
@@ -543,7 +543,7 @@ 
      *
      * @return array<mixed>|bool
      */
-    public function parseFormula(string $formula): array|bool
+    public function parseFormula(string $formula): array | bool
     {
         $formula = preg_replace_callback(
             self::CALCULATION_REGEXP_CELLREF_SPILL,
@@ -967,7 +967,7 @@ 
     /**
      * @return false|string False indicates an error
      */
-    private function convertMatrixReferences(string $formula): false|string
+    private function convertMatrixReferences(string $formula): false | string
     {
         //    Convert any Excel matrix references to the MKMATRIX() function
         if (str_contains($formula, self::FORMULA_OPEN_MATRIX_BRACE)) {
@@ -1043,7 +1043,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;
@@ -1563,7 +1563,7 @@ 
      *
      * @return array<int, mixed>|false|string
      */
-    private function processTokenStack(false|array $tokens, ?string $cellID = null, ?Cell $cell = null)
+    private function processTokenStack(false | array $tokens, ?string $cellID = null, ?Cell $cell = null)
     {
         if ($tokens === false) {
             return false;
@@ -2234,7 +2234,7 @@ 
         return $output;
     }
 
-    private function validateBinaryOperand(mixed &$operand, Stack &$stack): bool
+    private function validateBinaryOperand(mixed &$operand, Stack & $stack): bool
     {
         if (is_array($operand)) {
             if ((count($operand, COUNT_RECURSIVE) - count($operand)) == 1) {
@@ -2273,7 +2273,7 @@ 
     }
 
     /** @return mixed[] */
-    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) && is_array($operand1)) {
@@ -2318,7 +2318,7 @@ 
     }
 
     /** @return bool|mixed[] */
-    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))) {
@@ -2335,7 +2335,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 (
@@ -2561,7 +2561,7 @@ 
      *
      * @return mixed[]|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 = [];
@@ -2711,7 +2711,7 @@ 
      *
      * @return mixed[]
      */
-    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)) {

src/PhpSpreadsheet/Calculation/MathTrig/Ceiling.php

Spacing +4 added lines, -4 removed lines

@@ -70,7 +70,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 math(mixed $number, mixed $significance = null, $mode = 0, bool $checkSigns = false): array|string|float
+    public static function math(mixed $number, mixed $significance = null, $mode = 0, bool $checkSigns = false): array | string | float
     {
         if (is_array($number) || is_array($significance) || is_array($mode)) {
             return self::evaluateArrayArguments([self::class, __FUNCTION__], $number, $significance, $mode);
@@ -116,7 +116,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 precise(mixed $number, $significance = 1): array|string|float
+    public static function precise(mixed $number, $significance = 1): array | string | float
     {
         if (is_array($number) || is_array($significance)) {
             return self::evaluateArrayArguments([self::class, __FUNCTION__], $number, $significance);
@@ -149,7 +149,7 @@ 
      *
      * @return array<mixed>|float|string Rounded Number, or a string containing an error
      */
-    public static function mathOds(mixed $number, mixed $significance = null, $mode = 0): array|string|float
+    public static function mathOds(mixed $number, mixed $significance = null, $mode = 0): array | string | float
     {
         return self::math($number, $significance, $mode, true);
     }
@@ -165,7 +165,7 @@ 
     /**
      * Avoid Scrutinizer problems concerning complexity.
      */
-    private static function argumentsOk(float $number, float $significance): float|string
+    private static function argumentsOk(float $number, float $significance): float | string
     {
         if (empty($number * $significance)) {
             return 0.0;

tests/PhpSpreadsheetTests/Calculation/Functions/Database/DCountTest.php

Spacing +2 added lines, -2 removed lines

@@ -15,7 +15,7 @@ 
      * @param mixed[][] $criteria
      */
     #[DataProvider('providerDCount')]
-    public function testDirectCallToDCount(int|string $expectedResult, array $database, string|int|null $field, array $criteria): void
+    public function testDirectCallToDCount(int | string $expectedResult, array $database, string | int | null $field, array $criteria): void
     {
         $result = DCount::evaluate($database, $field, $criteria);
         self::assertEqualsWithDelta($expectedResult, $result, 1.0e-12);
@@ -26,7 +26,7 @@ 
      * @param mixed[][] $criteria
      */
     #[DataProvider('providerDCount')]
-    public function testDCountAsWorksheetFormula(int|string $expectedResult, array $database, string|int|null $field, array $criteria): void
+    public function testDCountAsWorksheetFormula(int | string $expectedResult, array $database, string | int | null $field, array $criteria): void
     {
         $this->prepareWorksheetWithFormula('DCOUNT', $database, $field, $criteria);
 

tests/PhpSpreadsheetTests/Calculation/Functions/Database/DSumTest.php

Spacing +2 added lines, -2 removed lines

@@ -15,7 +15,7 @@ 
      * @param mixed[][] $criteria
      */
     #[DataProvider('providerDSum')]
-    public function testDirectCallToDSum(int|float|string $expectedResult, array $database, ?string $field, array $criteria): void
+    public function testDirectCallToDSum(int | float | string $expectedResult, array $database, ?string $field, array $criteria): void
     {
         $result = DSum::evaluate($database, $field, $criteria);
         self::assertEqualsWithDelta($expectedResult, $result, 1.0e-12);
@@ -26,7 +26,7 @@ 
      * @param mixed[][] $criteria
      */
     #[DataProvider('providerDSum')]
-    public function testDSumAsWorksheetFormula(int|float|string $expectedResult, array $database, ?string $field, array $criteria): void
+    public function testDSumAsWorksheetFormula(int | float | string $expectedResult, array $database, ?string $field, array $criteria): void
     {
         $this->prepareWorksheetWithFormula('DSUM', $database, $field, $criteria);
 

tests/PhpSpreadsheetTests/Calculation/Functions/Database/DVarTest.php

Spacing +2 added lines, -2 removed lines

@@ -15,7 +15,7 @@ 
      * @param mixed[][] $criteria
      */
     #[DataProvider('providerDVar')]
-    public function testDirectCallToDVar(float|string $expectedResult, array $database, ?string $field, array $criteria): void
+    public function testDirectCallToDVar(float | string $expectedResult, array $database, ?string $field, array $criteria): void
     {
         $result = DVar::evaluate($database, $field, $criteria);
         self::assertEqualsWithDelta($expectedResult, $result, 1.0e-12);
@@ -26,7 +26,7 @@ 
      * @param mixed[][] $criteria
      */
     #[DataProvider('providerDVar')]
-    public function testDVarAsWorksheetFormula(float|string $expectedResult, array $database, ?string $field, array $criteria): void
+    public function testDVarAsWorksheetFormula(float | string $expectedResult, array $database, ?string $field, array $criteria): void
     {
         $this->prepareWorksheetWithFormula('DVAR', $database, $field, $criteria);
 

tests/PhpSpreadsheetTests/Calculation/Functions/Database/DStDevTest.php

Spacing +2 added lines, -2 removed lines

@@ -15,7 +15,7 @@ 
      * @param mixed[][] $criteria
      */
     #[DataProvider('providerDStDev')]
-    public function testDirectCallToDStDev(float|string $expectedResult, array $database, ?string $field, array $criteria): void
+    public function testDirectCallToDStDev(float | string $expectedResult, array $database, ?string $field, array $criteria): void
     {
         $result = DStDev::evaluate($database, $field, $criteria);
         self::assertEqualsWithDelta($expectedResult, $result, 1.0e-12);
@@ -26,7 +26,7 @@ 
      * @param mixed[][] $criteria
      */
     #[DataProvider('providerDStDev')]
-    public function testDStDevAsWorksheetFormula(float|string $expectedResult, array $database, ?string $field, array $criteria): void
+    public function testDStDevAsWorksheetFormula(float | string $expectedResult, array $database, ?string $field, array $criteria): void
     {
         $this->prepareWorksheetWithFormula('DSTDEV', $database, $field, $criteria);