PHPOffice / PhpSpreadsheet

src/PhpSpreadsheet/Calculation/MathTrig/Floor.php

Spacing +3 added lines, -3 removed lines

@@ -128,7 +128,7 @@ 
     /**
      * Avoid Scrutinizer problems concerning complexity.
      */
-    private static function argumentsOkPrecise(float $number, float $significance): string|float
+    private static function argumentsOkPrecise(float $number, float $significance): string | float
     {
         if ($significance == 0.0) {
             return ExcelError::DIV0();
@@ -145,7 +145,7 @@ 
      *
      * @return float|string Rounded Number, or a string containing an error
      */
-    private static function argsOk(float $number, float $significance, int $mode): string|float
+    private static function argsOk(float $number, float $significance, int $mode): string | float
     {
         if (!$significance) {
             return ExcelError::DIV0();
@@ -171,7 +171,7 @@ 
     /**
      * Avoid Scrutinizer problems concerning complexity.
      */
-    private static function argumentsOk(float $number, float $significance): string|float
+    private static function argumentsOk(float $number, float $significance): string | float
     {
         if ($significance == 0.0) {
             return ExcelError::DIV0();

src/PhpSpreadsheet/Calculation/MathTrig/Factorial.php

Spacing +3 added lines, -3 removed lines

@@ -27,7 +27,7 @@ 
      *         If an array of numbers is passed as the argument, then the returned result will also be an array
      *            with the same dimensions
      */
-    public static function fact($factVal): array|string|float|int
+    public static function fact($factVal): array | string | float | int
     {
         if (is_array($factVal)) {
             return self::evaluateSingleArgumentArray([self::class, __FUNCTION__], $factVal);
@@ -69,7 +69,7 @@ 
      *         If an array of numbers is passed as the argument, then the returned result will also be an array
      *            with the same dimensions
      */
-    public static function factDouble($factVal): array|string|float|int
+    public static function factDouble($factVal): array | string | float | int
     {
         if (is_array($factVal)) {
             return self::evaluateSingleArgumentArray([self::class, __FUNCTION__], $factVal);
@@ -101,7 +101,7 @@ 
      *
      * @return float|string The result, or a string containing an error
      */
-    public static function multinomial(...$args): string|int|float
+    public static function multinomial(...$args): string | int | float
     {
         $summer = 0;
         $divisor = 1;

src/PhpSpreadsheet/Calculation/MathTrig/Operations.php

Spacing +3 added lines, -3 removed lines

@@ -23,7 +23,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 mod($dividend, $divisor): array|string|float
+    public static function mod($dividend, $divisor): array | string | float
     {
         if (is_array($dividend) || is_array($divisor)) {
             return self::evaluateArrayArguments([self::class, __FUNCTION__], $dividend, $divisor);
@@ -98,7 +98,7 @@ 
      *
      * @param mixed ...$args Data values
      */
-    public static function product(...$args): string|float
+    public static function product(...$args): string | float
     {
         $args = array_filter(
             Functions::flattenArray($args),
@@ -141,7 +141,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 quotient($numerator, $denominator): array|string|int
+    public static function quotient($numerator, $denominator): array | string | int
     {
         if (is_array($numerator) || is_array($denominator)) {
             return self::evaluateArrayArguments([self::class, __FUNCTION__], $numerator, $denominator);

src/PhpSpreadsheet/Calculation/MathTrig/Random.php

Spacing +4 added lines, -4 removed lines

@@ -15,7 +15,7 @@ 
      *
      * @return float Random number
      */
-    public static function rand(): int|float
+    public static function rand(): int | float
     {
         return mt_rand(0, 10000000) / 10000000;
     }
@@ -32,7 +32,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 randBetween($min, $max): array|string|int
+    public static function randBetween($min, $max): array | string | int
     {
         if (is_array($min) || is_array($max)) {
             return self::evaluateArrayArguments([self::class, __FUNCTION__], $min, $max);
@@ -67,7 +67,7 @@ 
      *
      * @return array|string The resulting array, or a string containing an error
      */
-    public static function randArray($rows = 1, $columns = 1, $min = 0, $max = 1, $wholeNumber = false): string|array
+    public static function randArray($rows = 1, $columns = 1, $min = 0, $max = 1, $wholeNumber = false): string | array
     {
         try {
             $rows = (int) Helpers::validateNumericNullSubstitution($rows, 1);
@@ -86,7 +86,7 @@ 
 
         return array_chunk(
             array_map(
-                function () use ($min, $max, $wholeNumber): int|float {
+                function () use ($min, $max, $wholeNumber): int | float {
                     return $wholeNumber
                         ? mt_rand((int) $min, (int) $max)
                         : (mt_rand() / mt_getrandmax()) * ($max - $min) + $min;

src/PhpSpreadsheet/Calculation/MathTrig/Round.php

Spacing +6 added lines, -6 removed lines

@@ -22,7 +22,7 @@ 
      *         If an array of numbers is passed as the argument, then the returned result will also be an array
      *            with the same dimensions
      */
-    public static function round($number, $precision): array|string|float
+    public static function round($number, $precision): array | string | float
     {
         if (is_array($number) || is_array($precision)) {
             return self::evaluateArrayArguments([self::class, __FUNCTION__], $number, $precision);
@@ -50,7 +50,7 @@ 
      *         If an array of numbers is passed as the argument, then the returned result will also be an array
      *            with the same dimensions
      */
-    public static function up($number, $digits): array|string|float
+    public static function up($number, $digits): array | string | float
     {
         if (is_array($number) || is_array($digits)) {
             return self::evaluateArrayArguments([self::class, __FUNCTION__], $number, $digits);
@@ -86,7 +86,7 @@ 
      *         If an array of numbers is passed as the argument, then the returned result will also be an array
      *            with the same dimensions
      */
-    public static function down($number, $digits): array|string|float
+    public static function down($number, $digits): array | string | float
     {
         if (is_array($number) || is_array($digits)) {
             return self::evaluateArrayArguments([self::class, __FUNCTION__], $number, $digits);
@@ -122,7 +122,7 @@ 
      *         If an array of numbers is passed as the argument, then the returned result will also be an array
      *            with the same dimensions
      */
-    public static function multiple($number, $multiple): array|string|int|float
+    public static function multiple($number, $multiple): array | string | int | float
     {
         if (is_array($number) || is_array($multiple)) {
             return self::evaluateArrayArguments([self::class, __FUNCTION__], $number, $multiple);
@@ -165,7 +165,7 @@ 
      *         If an array of numbers is passed as the argument, then the returned result will also be an array
      *            with the same dimensions
      */
-    public static function even($number): array|string|float
+    public static function even($number): array | string | float
     {
         if (is_array($number)) {
             return self::evaluateSingleArgumentArray([self::class, __FUNCTION__], $number);
@@ -191,7 +191,7 @@ 
      *         If an array of numbers is passed as the argument, then the returned result will also be an array
      *            with the same dimensions
      */
-    public static function odd($number): array|string|int|float
+    public static function odd($number): array | string | int | float
     {
         if (is_array($number)) {
             return self::evaluateSingleArgumentArray([self::class, __FUNCTION__], $number);

src/PhpSpreadsheet/Calculation/LookupRef.php

Spacing +2 added lines, -2 removed lines

@@ -41,7 +41,7 @@ 
      *                                FALSE                CELL_ADDRESS returns an R1C1-style reference
      * @param array|string $sheetText Optional Name of worksheet to use
      */
-    public static function cellAddress($row, $column, $relativity = 1, $referenceStyle = true, $sheetText = ''): string|array
+    public static function cellAddress($row, $column, $relativity = 1, $referenceStyle = true, $sheetText = ''): string | array
     {
         return Address::cell($row, $column, $relativity, $referenceStyle, $sheetText);
     }
@@ -268,7 +268,7 @@ 
      *
      * @return array|float|int|string The relative position of the found item
      */
-    public static function MATCH($lookupValue, $lookupArray, $matchType = 1): array|float|int|string
+    public static function MATCH($lookupValue, $lookupArray, $matchType = 1): array | float | int | string
     {
         return LookupRef\ExcelMatch::MATCH($lookupValue, $lookupArray, $matchType);
     }

src/PhpSpreadsheet/Calculation/MathTrig.php

Spacing +28 added lines, -28 removed lines

@@ -53,7 +53,7 @@ 
      *
      * @return array|float|string the inverse tangent of the specified x- and y-coordinates, or a string containing an error
      */
-    public static function ATAN2($xCoordinate = null, $yCoordinate = null): string|float|array
+    public static function ATAN2($xCoordinate = null, $yCoordinate = null): string | float | array
     {
         return MathTrig\Trig\Tangent::atan2($xCoordinate, $yCoordinate);
     }
@@ -76,7 +76,7 @@ 
      *
      * @return array|string the text representation with the given radix (base)
      */
-    public static function BASE($number, $radix, $minLength = null): string|array
+    public static function BASE($number, $radix, $minLength = null): string | array
     {
         return MathTrig\Base::evaluate($number, $radix, $minLength);
     }
@@ -149,7 +149,7 @@ 
      *
      * @return array|float|string Rounded Number, or a string containing an error
      */
-    public static function EVEN($number): string|float|array
+    public static function EVEN($number): string | float | array
     {
         return MathTrig\Round::even($number);
     }
@@ -361,7 +361,7 @@ 
      *
      * @return array|float|string The result, or a string containing an error
      */
-    public static function logBase($number, $base = 10): string|float|array
+    public static function logBase($number, $base = 10): string | float | array
     {
         return MathTrig\Logarithms::withBase($number, $base);
     }
@@ -403,7 +403,7 @@ 
      *
      * @return array|string The result, or a string containing an error
      */
-    public static function MINVERSE($matrixValues): string|array
+    public static function MINVERSE($matrixValues): string | array
     {
         return MathTrig\MatrixFunctions::inverse($matrixValues);
     }
@@ -420,7 +420,7 @@ 
      *
      * @return array|string The result, or a string containing an error
      */
-    public static function MMULT($matrixData1, $matrixData2): string|array
+    public static function MMULT($matrixData1, $matrixData2): string | array
     {
         return MathTrig\MatrixFunctions::multiply($matrixData1, $matrixData2);
     }
@@ -456,7 +456,7 @@ 
      *
      * @return array|float|string Rounded Number, or a string containing an error
      */
-    public static function MROUND($number, $multiple): string|int|float|array
+    public static function MROUND($number, $multiple): string | int | float | array
     {
         return MathTrig\Round::multiple($number, $multiple);
     }
@@ -492,7 +492,7 @@ 
      *
      * @return array|float|int|string Rounded Number, or a string containing an error
      */
-    public static function ODD($number): string|int|float|array
+    public static function ODD($number): string | int | float | array
     {
         return MathTrig\Round::odd($number);
     }
@@ -572,7 +572,7 @@ 
      *
      * @return array|int|string Random number
      */
-    public static function RAND($min = 0, $max = 0): string|int|array
+    public static function RAND($min = 0, $max = 0): string | int | array
     {
         return MathTrig\Random::randBetween($min, $max);
     }
@@ -591,7 +591,7 @@ 
      *
      * @return array|string Roman numeral, or a string containing an error
      */
-    public static function ROMAN($aValue, $style = 0): string|array
+    public static function ROMAN($aValue, $style = 0): string | array
     {
         return MathTrig\Roman::evaluate($aValue, $style);
     }
@@ -610,7 +610,7 @@ 
      *
      * @return array|float|string Rounded Number, or a string containing an error
      */
-    public static function ROUNDUP($number, $digits): string|float|array
+    public static function ROUNDUP($number, $digits): string | float | array
     {
         return MathTrig\Round::up($number, $digits);
     }
@@ -629,7 +629,7 @@ 
      *
      * @return array|float|string Rounded Number, or a string containing an error
      */
-    public static function ROUNDDOWN($number, $digits): string|float|array
+    public static function ROUNDDOWN($number, $digits): string | float | array
     {
         return MathTrig\Round::down($number, $digits);
     }
@@ -650,7 +650,7 @@ 
      *
      * @return array|float|string The result, or a string containing an error
      */
-    public static function SERIESSUM($x, $n, $m, ...$args): string|float|int|array
+    public static function SERIESSUM($x, $n, $m, ...$args): string | float | int | array
     {
         return MathTrig\SeriesSum::evaluate($x, $n, $m, ...$args);
     }
@@ -669,7 +669,7 @@ 
      *
      * @return array|int|string sign value, or a string containing an error
      */
-    public static function SIGN($number): string|int|array
+    public static function SIGN($number): string | int | array
     {
         return MathTrig\Sign::evaluate($number);
     }
@@ -699,7 +699,7 @@ 
      *
      * @return array|float|string Square Root of Number * Pi, or a string containing an error
      */
-    public static function SQRTPI($number): string|float|array
+    public static function SQRTPI($number): string | float | array
     {
         return MathTrig\Sqrt::pi($number);
     }
@@ -807,7 +807,7 @@ 
      *
      * @return float|string The result, or a string containing an error
      */
-    public static function SUMPRODUCT(...$args): string|int|float
+    public static function SUMPRODUCT(...$args): string | int | float
     {
         return MathTrig\Sum::product(...$args);
     }
@@ -1077,7 +1077,7 @@ 
      *
      * @return array|float|string Rounded number
      */
-    public static function builtinROUND($number, $precision): string|float|array
+    public static function builtinROUND($number, $precision): string | float | array
     {
         return MathTrig\Round::round($number, $precision);
     }
@@ -1095,7 +1095,7 @@ 
      *
      * @return array|float|int|string Rounded number
      */
-    public static function builtinABS($number): string|int|float|array
+    public static function builtinABS($number): string | int | float | array
     {
         return MathTrig\Absolute::evaluate($number);
     }
@@ -1221,7 +1221,7 @@ 
      *
      * @return array|float|string Rounded number
      */
-    public static function builtinCOS($number): string|float|array
+    public static function builtinCOS($number): string | float | array
     {
         return MathTrig\Trig\Cosine::cos($number);
     }
@@ -1239,7 +1239,7 @@ 
      *
      * @return array|float|string Rounded number
      */
-    public static function builtinCOSH($number): string|float|array
+    public static function builtinCOSH($number): string | float | array
     {
         return MathTrig\Trig\Cosine::cosh($number);
     }
@@ -1257,7 +1257,7 @@ 
      *
      * @return array|float|string Rounded number
      */
-    public static function builtinDEGREES($number): string|float|array
+    public static function builtinDEGREES($number): string | float | array
     {
         return MathTrig\Angle::toDegrees($number);
     }
@@ -1275,7 +1275,7 @@ 
      *
      * @return array|float|string Rounded number
      */
-    public static function builtinEXP($number): string|float|array
+    public static function builtinEXP($number): string | float | array
     {
         return MathTrig\Exp::evaluate($number);
     }
@@ -1293,7 +1293,7 @@ 
      *
      * @return array|float|string Rounded number
      */
-    public static function builtinLN($number): string|float|array
+    public static function builtinLN($number): string | float | array
     {
         return MathTrig\Logarithms::natural($number);
     }
@@ -1311,7 +1311,7 @@ 
      *
      * @return array|float|string Rounded number
      */
-    public static function builtinLOG10($number): string|float|array
+    public static function builtinLOG10($number): string | float | array
     {
         return MathTrig\Logarithms::base10($number);
     }
@@ -1329,7 +1329,7 @@ 
      *
      * @return array|float|string Rounded number
      */
-    public static function builtinRADIANS($number): string|float|array
+    public static function builtinRADIANS($number): string | float | array
     {
         return MathTrig\Angle::toRadians($number);
     }
@@ -1347,7 +1347,7 @@ 
      *
      * @return array|float|string sine
      */
-    public static function builtinSIN($number): string|float|array
+    public static function builtinSIN($number): string | float | array
     {
         return MathTrig\Trig\Sine::sin($number);
     }
@@ -1365,7 +1365,7 @@ 
      *
      * @return array|float|string Rounded number
      */
-    public static function builtinSINH($number): string|float|array
+    public static function builtinSINH($number): string | float | array
     {
         return MathTrig\Trig\Sine::sinh($number);
     }
@@ -1419,7 +1419,7 @@ 
      *
      * @return array|float|string Rounded number
      */
-    public static function builtinTANH($number): string|float|array
+    public static function builtinTANH($number): string | float | array
     {
         return MathTrig\Trig\Tangent::tanh($number);
     }

src/PhpSpreadsheet/Calculation/Calculation.php

Spacing +5 added lines, -5 removed lines

@@ -3999,7 +3999,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(', '))'];
@@ -4102,7 +4102,7 @@ 
      *
      * @return array<int, mixed>|false
      */
-    private function internalParseFormula($formula, ?Cell $cell = null): bool|array
+    private function internalParseFormula($formula, ?Cell $cell = null): bool | array
     {
         if (($formula = $this->convertMatrixReferences(trim($formula))) === false) {
             return false;
@@ -5251,7 +5251,7 @@ 
      * @param mixed $operand1
      * @param mixed $operand2
      */
-    private function executeArrayComparison($operand1, $operand2, string $operation, Stack &$stack, bool $recursingArrays): array
+    private function executeArrayComparison($operand1, $operand2, string $operation, Stack & $stack, bool $recursingArrays): array
     {
         $result = [];
         if (!is_array($operand2)) {
@@ -5294,7 +5294,7 @@ 
      * @param mixed $operand1
      * @param mixed $operand2
      */
-    private function executeBinaryComparisonOperation($operand1, $operand2, string $operation, Stack &$stack, bool $recursingArrays = false): array|bool
+    private function executeBinaryComparisonOperation($operand1, $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))) {
@@ -5524,7 +5524,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 = [];

src/PhpSpreadsheet/Calculation/Financial/Helpers.php

Spacing +1 added lines, -1 removed lines

@@ -24,7 +24,7 @@
      *
      * @return int|string Result, or a string containing an error
      */
-    public static function daysPerYear($year, $basis = 0): string|int
+    public static function daysPerYear($year, $basis = 0): string | int
     {
         if (!is_numeric($basis)) {
             return ExcelError::NAN();