PHPOffice / PhpSpreadsheet

src/PhpSpreadsheet/Calculation/Functions.php

Spacing +1 added lines, -1 removed lines

@@ -189,7 +189,7 @@
         return str_replace('""""', '""', $operator . $operand);
     }
 
-    private static function operandSpecialHandling(mixed $operand): bool|float|int|string
+    private static function operandSpecialHandling(mixed $operand): bool | float | int | string
     {
         if (is_numeric($operand) || is_bool($operand)) {
             return $operand;

src/PhpSpreadsheet/Calculation/TextData/Concatenate.php

Spacing +4 added lines, -4 removed lines

@@ -49,7 +49,7 @@ 
      *
      * @param array $args data to be concatenated
      */
-    public static function actualCONCATENATE(...$args): array|string
+    public static function actualCONCATENATE(...$args): array | string
     {
         if (Functions::getCompatibilityMode() === Functions::COMPATIBILITY_GNUMERIC) {
             return self::CONCATENATE(...$args);
@@ -65,7 +65,7 @@ 
         return $result;
     }
 
-    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);
@@ -113,7 +113,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(
@@ -171,7 +171,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/MathTrig/Subtotal.php

Spacing +1 added lines, -1 removed lines

@@ -84,7 +84,7 @@
      *                    in hidden rows
      * @param mixed[] $args A mixed data series of values
      */
-    public static function evaluate(mixed $functionType, ...$args): float|int|string
+    public static function evaluate(mixed $functionType, ...$args): float | int | string
     {
         /** @var Cell */
         $cellReference = array_pop($args);

src/PhpSpreadsheet/Calculation/LookupRef/Offset.php

Spacing +1 added lines, -1 removed lines

@@ -42,7 +42,7 @@
      *
      * @return array|string An array containing a cell or range of cells, or a string on error
      */
-    public static function OFFSET(?string $cellAddress = null, $rows = 0, $columns = 0, $height = null, $width = null, ?Cell $cell = null): string|array
+    public static function OFFSET(?string $cellAddress = null, $rows = 0, $columns = 0, $height = null, $width = null, ?Cell $cell = null): string | array
     {
         /** @var int */
         $rows = Functions::flattenSingleValue($rows);

src/PhpSpreadsheet/Calculation/Statistical/Distributions/ChiSquared.php

Spacing +4 added lines, -4 removed lines

@@ -26,7 +26,7 @@ 
      * @return array|float|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 distributionRightTail(mixed $value, mixed $degrees): array|string|int|float
+    public static function distributionRightTail(mixed $value, mixed $degrees): array | string | int | float
     {
         if (is_array($value) || is_array($degrees)) {
             return self::evaluateArrayArguments([self::class, __FUNCTION__], $value, $degrees);
@@ -68,7 +68,7 @@ 
      * @return array|float|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 distributionLeftTail(mixed $value, mixed $degrees, mixed $cumulative): array|string|int|float
+    public static function distributionLeftTail(mixed $value, mixed $degrees, mixed $cumulative): array | string | int | float
     {
         if (is_array($value) || is_array($degrees) || is_array($cumulative)) {
             return self::evaluateArrayArguments([self::class, __FUNCTION__], $value, $degrees, $cumulative);
@@ -154,7 +154,7 @@ 
      * @return array|float|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 inverseLeftTail(mixed $probability, mixed $degrees): array|string|float
+    public static function inverseLeftTail(mixed $probability, mixed $degrees): array | string | float
     {
         if (is_array($probability) || is_array($degrees)) {
             return self::evaluateArrayArguments([self::class, __FUNCTION__], $probability, $degrees);
@@ -184,7 +184,7 @@ 
      * @param array $actual an array of observed frequencies
      * @param array $expected an array of expected frequencies
      */
-    public static function test($actual, $expected): float|string
+    public static function test($actual, $expected): float | string
     {
         $rows = count($actual);
         $actual = Functions::flattenArray($actual);

src/PhpSpreadsheet/Calculation/CalculationLocale.php

Spacing +4 added lines, -4 removed lines

@@ -337,10 +337,10 @@ 
     }
 
     /** @var null|string[] */
-    private static ?array $functionReplaceFromExcel;
+    private static ? array $functionReplaceFromExcel;
 
     /** @var null|string[] */
-    private static ?array $functionReplaceToLocale;
+    private static ? array $functionReplaceToLocale;
 
     public function translateFormulaToLocale(string $formula): string
     {
@@ -376,10 +376,10 @@ 
     }
 
     /** @var null|string[] */
-    protected static ?array $functionReplaceFromLocale;
+    protected static ? array $functionReplaceFromLocale;
 
     /** @var null|string[] */
-    protected static ?array $functionReplaceToExcel;
+    protected static ? array $functionReplaceToExcel;
 
     public function translateFormulaToEnglish(string $formula): string
     {

src/PhpSpreadsheet/Calculation/Database/DatabaseAbstract.php

Spacing +1 added lines, -1 removed lines

@@ -25,7 +25,7 @@
      *                                        the column label in which you specify a condition for the
      *                                        column.
      */
-    abstract public static function evaluate(array $database, array|null|int|string $field, array $criteria): null|float|int|string;
+    abstract public static function evaluate(array $database, array | null | int | string $field, array $criteria): null | float | int | string;
 
     /**
      * fieldExtract.

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

Spacing +1 added lines, -1 removed lines

@@ -51,7 +51,7 @@
     }
 
     #[DataProvider('providerCONVERTUOM')]
-    public function testDirectCallToCONVERTUOM(float|int|string $expectedResult, float|int|string $value, string $from, string $to): void
+    public function testDirectCallToCONVERTUOM(float | int | string $expectedResult, float | int | string $value, string $from, string $to): void
     {
         $result = ConvertUOM::convert($value, $from, $to);
         self::assertEqualsWithDelta($expectedResult, $result, self::UOM_PRECISION);

src/PhpSpreadsheet/Calculation/Calculation.php

Spacing +11 added lines, -11 removed lines

@@ -163,7 +163,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];
     }
@@ -538,7 +538,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,
@@ -957,7 +957,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(', '))'];
@@ -1036,7 +1036,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;
@@ -1549,7 +1549,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;
@@ -2201,7 +2201,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) {
@@ -2240,7 +2240,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)) {
@@ -2285,7 +2285,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))) {
@@ -2302,7 +2302,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 (
@@ -2525,7 +2525,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 = [];
@@ -2674,7 +2674,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)) {