PHPOffice / PhpSpreadsheet

src/PhpSpreadsheet/Calculation/MathTrig/MatrixFunctions.php

Spacing +3 added lines, -3 removed lines

@@ -57,7 +57,7 @@ 
      *
      * @return array<mixed>|string The resulting array, or a string containing an error
      */
-    public static function sequence(mixed $rows = 1, mixed $columns = 1, mixed $start = 1, mixed $step = 1): string|array
+    public static function sequence(mixed $rows = 1, mixed $columns = 1, mixed $start = 1, mixed $step = 1): string | array
     {
         try {
             $rows = (int) Helpers::validateNumericNullSubstitution($rows, 1);
@@ -120,7 +120,7 @@ 
      *
      * @return array<mixed>|string The result, or a string containing an error
      */
-    public static function inverse(mixed $matrixValues): array|string
+    public static function inverse(mixed $matrixValues): array | string
     {
         try {
             $matrix = self::getMatrix($matrixValues);
@@ -143,7 +143,7 @@ 
      *
      * @return array<mixed>|string The result, or a string containing an error
      */
-    public static function multiply(mixed $matrixData1, mixed $matrixData2): array|string
+    public static function multiply(mixed $matrixData1, mixed $matrixData2): array | string
     {
         try {
             $matrixA = self::getMatrix($matrixData1);

src/PhpSpreadsheet/Calculation/TextData/Text.php

Spacing +5 added lines, -5 removed lines

@@ -23,7 +23,7 @@ 
      * @return array<mixed>|int|string If an array of values is passed for the argument, then the returned result
      *            will also be an array with matching dimensions
      */
-    public static function length(mixed $value = ''): array|int|string
+    public static function length(mixed $value = ''): array | int | string
     {
         if (is_array($value)) {
             return self::evaluateSingleArgumentArray([self::class, __FUNCTION__], $value);
@@ -51,7 +51,7 @@ 
      * @return array<mixed>|bool|string If an array of values is passed for either of the arguments, then the returned result
      *            will also be an array with matching dimensions
      */
-    public static function exact(mixed $value1, mixed $value2): array|bool|string
+    public static function exact(mixed $value1, mixed $value2): array | bool | string
     {
         if (is_array($value1) || is_array($value2)) {
             return self::evaluateArrayArguments([self::class, __FUNCTION__], $value1, $value2);
@@ -76,7 +76,7 @@ 
      * @return array<mixed>|string If an array of values is passed for the argument, then the returned result
      *            will also be an array with matching dimensions
      */
-    public static function test(mixed $testValue = ''): array|string
+    public static function test(mixed $testValue = ''): array | string
     {
         if (is_array($testValue)) {
             return self::evaluateSingleArgumentArray([self::class, __FUNCTION__], $testValue);
@@ -110,7 +110,7 @@ 
      *
      * @return array<mixed>|string the array built from the text, split by the row and column delimiters, or an error string
      */
-    public static function split(mixed $text, $columnDelimiter = null, $rowDelimiter = null, bool $ignoreEmpty = false, bool $matchMode = true, mixed $padding = '#N/A'): array|string
+    public static function split(mixed $text, $columnDelimiter = null, $rowDelimiter = null, bool $ignoreEmpty = false, bool $matchMode = true, mixed $padding = '#N/A'): array | string
     {
         $text = Functions::flattenSingleValue($text);
         if (ErrorValue::isError($text, true)) {
@@ -194,7 +194,7 @@ 
         if (is_array($delimiter) && count($valueSet) > 1) {
             /** @var array<?string> $valueSet */
             $quotedDelimiters = array_map(
-                fn (?string $delimiter): string => preg_quote($delimiter ?? '', '/'),
+                fn (?string $delimiter) : string => preg_quote($delimiter ?? '', '/'),
                 $valueSet
             );
             $delimiters = implode('|', $quotedDelimiters);

src/PhpSpreadsheet/Calculation/TextData/Extract.php

Spacing +7 added lines, -7 removed lines

@@ -24,7 +24,7 @@ 
      *         If an array of values is passed for the $value or $chars arguments, then the returned result
      *            will also be an array with matching dimensions
      */
-    public static function left(mixed $value, mixed $chars = 1): array|string
+    public static function left(mixed $value, mixed $chars = 1): array | string
     {
         if (is_array($value) || is_array($chars)) {
             return self::evaluateArrayArguments([self::class, __FUNCTION__], $value, $chars);
@@ -54,7 +54,7 @@ 
      *         If an array of values is passed for the $value, $start or $chars arguments, then the returned result
      *            will also be an array with matching dimensions
      */
-    public static function mid(mixed $value, mixed $start, mixed $chars): array|string
+    public static function mid(mixed $value, mixed $start, mixed $chars): array | string
     {
         if (is_array($value) || is_array($start) || is_array($chars)) {
             return self::evaluateArrayArguments([self::class, __FUNCTION__], $value, $start, $chars);
@@ -83,7 +83,7 @@ 
      *         If an array of values is passed for the $value or $chars arguments, then the returned result
      *            will also be an array with matching dimensions
      */
-    public static function right(mixed $value, mixed $chars = 1): array|string
+    public static function right(mixed $value, mixed $chars = 1): array | string
     {
         if (is_array($value) || is_array($chars)) {
             return self::evaluateArrayArguments([self::class, __FUNCTION__], $value, $chars);
@@ -126,7 +126,7 @@ 
      *         If an array of values is passed for any of the arguments, then the returned result
      *            will also be an array with matching dimensions
      */
-    public static function before(mixed $text, $delimiter, mixed $instance = 1, mixed $matchMode = 0, mixed $matchEnd = 0, mixed $ifNotFound = '#N/A'): array|string
+    public static function before(mixed $text, $delimiter, mixed $instance = 1, mixed $matchMode = 0, mixed $matchEnd = 0, mixed $ifNotFound = '#N/A'): array | string
     {
         if (is_array($text) || is_array($instance) || is_array($matchMode) || is_array($matchEnd) || is_array($ifNotFound)) {
             return self::evaluateArrayArgumentsIgnore([self::class, __FUNCTION__], 1, $text, $delimiter, $instance, $matchMode, $matchEnd, $ifNotFound);
@@ -190,7 +190,7 @@ 
      *         If an array of values is passed for any of the arguments, then the returned result
      *            will also be an array with matching dimensions
      */
-    public static function after(mixed $text, $delimiter, mixed $instance = 1, mixed $matchMode = 0, mixed $matchEnd = 0, mixed $ifNotFound = '#N/A'): array|string
+    public static function after(mixed $text, $delimiter, mixed $instance = 1, mixed $matchMode = 0, mixed $matchEnd = 0, mixed $ifNotFound = '#N/A'): array | string
     {
         if (is_array($text) || is_array($instance) || is_array($matchMode) || is_array($matchEnd) || is_array($ifNotFound)) {
             return self::evaluateArrayArgumentsIgnore([self::class, __FUNCTION__], 1, $text, $delimiter, $instance, $matchMode, $matchEnd, $ifNotFound);
@@ -234,7 +234,7 @@ 
      *
      * @return array<string>|string
      */
-    private static function validateTextBeforeAfter(string $text, null|array|string $delimiter, int $instance, int $matchMode, int $matchEnd, mixed $ifNotFound): array|string
+    private static function validateTextBeforeAfter(string $text, null | array | string $delimiter, int $instance, int $matchMode, int $matchEnd, mixed $ifNotFound): array | string
     {
         $flags = self::matchFlags($matchMode);
         $delimiter = self::buildDelimiter($delimiter);
@@ -271,7 +271,7 @@ 
             /** @var array<?string> */
             $delimiter = Functions::flattenArray($delimiter);
             $quotedDelimiters = array_map(
-                fn (?string $delimiter): string => preg_quote($delimiter ?? '', '/'),
+                fn (?string $delimiter) : string => preg_quote($delimiter ?? '', '/'),
                 $delimiter
             );
             $delimiters = implode('|', $quotedDelimiters);

src/PhpSpreadsheet/Calculation/Engineering/BitWise.php

Spacing +6 added lines, -6 removed lines

@@ -17,7 +17,7 @@ 
      *
      * @return int[]
      */
-    private static function splitNumber(float|int $number): array
+    private static function splitNumber(float | int $number): array
     {
         return [(int) floor($number / self::SPLIT_DIVISOR), (int) fmod($number, self::SPLIT_DIVISOR)];
     }
@@ -36,7 +36,7 @@ 
      * @return array<mixed>|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 BITAND(null|array|bool|float|int|string $number1, null|array|bool|float|int|string $number2): array|string|int|float
+    public static function BITAND(null | array | bool | float | int | string $number1, null | array | bool | float | int | string $number2): array | string | int | float
     {
         if (is_array($number1) || is_array($number2)) {
             return self::evaluateArrayArguments([self::class, __FUNCTION__], $number1, $number2);
@@ -68,7 +68,7 @@ 
      * @return array<mixed>|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 BITOR(null|array|bool|float|int|string $number1, null|array|bool|float|int|string $number2): array|string|int|float
+    public static function BITOR(null | array | bool | float | int | string $number1, null | array | bool | float | int | string $number2): array | string | int | float
     {
         if (is_array($number1) || is_array($number2)) {
             return self::evaluateArrayArguments([self::class, __FUNCTION__], $number1, $number2);
@@ -101,7 +101,7 @@ 
      * @return array<mixed>|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 BITXOR(null|array|bool|float|int|string $number1, null|array|bool|float|int|string $number2): array|string|int|float
+    public static function BITXOR(null | array | bool | float | int | string $number1, null | array | bool | float | int | string $number2): array | string | int | float
     {
         if (is_array($number1) || is_array($number2)) {
             return self::evaluateArrayArguments([self::class, __FUNCTION__], $number1, $number2);
@@ -134,7 +134,7 @@ 
      * @return array<mixed>|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 BITLSHIFT(null|array|bool|float|int|string $number, null|array|bool|float|int|string $shiftAmount): array|string|float
+    public static function BITLSHIFT(null | array | bool | float | int | string $number, null | array | bool | float | int | string $shiftAmount): array | string | float
     {
         if (is_array($number) || is_array($shiftAmount)) {
             return self::evaluateArrayArguments([self::class, __FUNCTION__], $number, $shiftAmount);
@@ -169,7 +169,7 @@ 
      * @return array<mixed>|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 BITRSHIFT(null|array|bool|float|int|string $number, null|array|bool|float|int|string $shiftAmount): array|string|float
+    public static function BITRSHIFT(null | array | bool | float | int | string $number, null | array | bool | float | int | string $shiftAmount): array | string | float
     {
         if (is_array($number) || is_array($shiftAmount)) {
             return self::evaluateArrayArguments([self::class, __FUNCTION__], $number, $shiftAmount);

src/PhpSpreadsheet/Calculation/Engineering/Complex.php

Spacing +3 added lines, -3 removed lines

@@ -31,7 +31,7 @@ 
      * @return array<mixed>|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 COMPLEX(mixed $realNumber = 0.0, mixed $imaginary = 0.0, mixed $suffix = 'i'): array|string
+    public static function COMPLEX(mixed $realNumber = 0.0, mixed $imaginary = 0.0, mixed $suffix = 'i'): array | string
     {
         if (is_array($realNumber) || is_array($imaginary) || is_array($suffix)) {
             return self::evaluateArrayArguments([self::class, __FUNCTION__], $realNumber, $imaginary, $suffix);
@@ -73,7 +73,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 IMAGINARY($complexNumber): array|string|float
+    public static function IMAGINARY($complexNumber): array | string | float
     {
         if (is_array($complexNumber)) {
             return self::evaluateSingleArgumentArray([self::class, __FUNCTION__], $complexNumber);
@@ -103,7 +103,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 IMREAL($complexNumber): array|string|float
+    public static function IMREAL($complexNumber): array | string | float
     {
         if (is_array($complexNumber)) {
             return self::evaluateSingleArgumentArray([self::class, __FUNCTION__], $complexNumber);

src/PhpSpreadsheet/Calculation/Engineering/ComplexFunctions.php

Spacing +19 added lines, -19 removed lines

@@ -25,7 +25,7 @@ 
      * @return array<mixed>|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 IMABS(array|string $complexNumber): array|float|string
+    public static function IMABS(array | string $complexNumber): array | float | string
     {
         if (is_array($complexNumber)) {
             return self::evaluateSingleArgumentArray([self::class, __FUNCTION__], $complexNumber);
@@ -55,7 +55,7 @@ 
      * @return array<mixed>|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 IMARGUMENT(array|string $complexNumber): array|float|string
+    public static function IMARGUMENT(array | string $complexNumber): array | float | string
     {
         if (is_array($complexNumber)) {
             return self::evaluateSingleArgumentArray([self::class, __FUNCTION__], $complexNumber);
@@ -88,7 +88,7 @@ 
      * @return array<mixed>|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 IMCONJUGATE(array|string $complexNumber): array|string
+    public static function IMCONJUGATE(array | string $complexNumber): array | string
     {
         if (is_array($complexNumber)) {
             return self::evaluateSingleArgumentArray([self::class, __FUNCTION__], $complexNumber);
@@ -117,7 +117,7 @@ 
      * @return array<mixed>|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 IMCOS(array|string $complexNumber): array|string
+    public static function IMCOS(array | string $complexNumber): array | string
     {
         if (is_array($complexNumber)) {
             return self::evaluateSingleArgumentArray([self::class, __FUNCTION__], $complexNumber);
@@ -146,7 +146,7 @@ 
      * @return array<mixed>|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 IMCOSH(array|string $complexNumber): array|string
+    public static function IMCOSH(array | string $complexNumber): array | string
     {
         if (is_array($complexNumber)) {
             return self::evaluateSingleArgumentArray([self::class, __FUNCTION__], $complexNumber);
@@ -175,7 +175,7 @@ 
      * @return array<mixed>|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 IMCOT(array|string $complexNumber): array|string
+    public static function IMCOT(array | string $complexNumber): array | string
     {
         if (is_array($complexNumber)) {
             return self::evaluateSingleArgumentArray([self::class, __FUNCTION__], $complexNumber);
@@ -204,7 +204,7 @@ 
      * @return array<mixed>|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 IMCSC(array|string $complexNumber): array|string
+    public static function IMCSC(array | string $complexNumber): array | string
     {
         if (is_array($complexNumber)) {
             return self::evaluateSingleArgumentArray([self::class, __FUNCTION__], $complexNumber);
@@ -233,7 +233,7 @@ 
      * @return array<mixed>|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 IMCSCH(array|string $complexNumber): array|string
+    public static function IMCSCH(array | string $complexNumber): array | string
     {
         if (is_array($complexNumber)) {
             return self::evaluateSingleArgumentArray([self::class, __FUNCTION__], $complexNumber);
@@ -262,7 +262,7 @@ 
      * @return array<mixed>|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 IMSIN(array|string $complexNumber): array|string
+    public static function IMSIN(array | string $complexNumber): array | string
     {
         if (is_array($complexNumber)) {
             return self::evaluateSingleArgumentArray([self::class, __FUNCTION__], $complexNumber);
@@ -291,7 +291,7 @@ 
      * @return array<mixed>|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 IMSINH(array|string $complexNumber): array|string
+    public static function IMSINH(array | string $complexNumber): array | string
     {
         if (is_array($complexNumber)) {
             return self::evaluateSingleArgumentArray([self::class, __FUNCTION__], $complexNumber);
@@ -320,7 +320,7 @@ 
      * @return array<mixed>|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 IMSEC(array|string $complexNumber): array|string
+    public static function IMSEC(array | string $complexNumber): array | string
     {
         if (is_array($complexNumber)) {
             return self::evaluateSingleArgumentArray([self::class, __FUNCTION__], $complexNumber);
@@ -349,7 +349,7 @@ 
      * @return array<mixed>|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 IMSECH(array|string $complexNumber): array|string
+    public static function IMSECH(array | string $complexNumber): array | string
     {
         if (is_array($complexNumber)) {
             return self::evaluateSingleArgumentArray([self::class, __FUNCTION__], $complexNumber);
@@ -378,7 +378,7 @@ 
      * @return array<mixed>|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 IMTAN(array|string $complexNumber): array|string
+    public static function IMTAN(array | string $complexNumber): array | string
     {
         if (is_array($complexNumber)) {
             return self::evaluateSingleArgumentArray([self::class, __FUNCTION__], $complexNumber);
@@ -407,7 +407,7 @@ 
      * @return array<mixed>|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 IMSQRT(array|string $complexNumber): array|string
+    public static function IMSQRT(array | string $complexNumber): array | string
     {
         if (is_array($complexNumber)) {
             return self::evaluateSingleArgumentArray([self::class, __FUNCTION__], $complexNumber);
@@ -441,7 +441,7 @@ 
      * @return array<mixed>|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 IMLN(array|string $complexNumber): array|string
+    public static function IMLN(array | string $complexNumber): array | string
     {
         if (is_array($complexNumber)) {
             return self::evaluateSingleArgumentArray([self::class, __FUNCTION__], $complexNumber);
@@ -474,7 +474,7 @@ 
      * @return array<mixed>|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 IMLOG10(array|string $complexNumber): array|string
+    public static function IMLOG10(array | string $complexNumber): array | string
     {
         if (is_array($complexNumber)) {
             return self::evaluateSingleArgumentArray([self::class, __FUNCTION__], $complexNumber);
@@ -507,7 +507,7 @@ 
      * @return array<mixed>|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 IMLOG2(array|string $complexNumber): array|string
+    public static function IMLOG2(array | string $complexNumber): array | string
     {
         if (is_array($complexNumber)) {
             return self::evaluateSingleArgumentArray([self::class, __FUNCTION__], $complexNumber);
@@ -540,7 +540,7 @@ 
      * @return array<mixed>|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 IMEXP(array|string $complexNumber): array|string
+    public static function IMEXP(array | string $complexNumber): array | string
     {
         if (is_array($complexNumber)) {
             return self::evaluateSingleArgumentArray([self::class, __FUNCTION__], $complexNumber);
@@ -571,7 +571,7 @@ 
      * @return array<mixed>|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 IMPOWER(array|string $complexNumber, array|float|int|string $realNumber): array|string
+    public static function IMPOWER(array | string $complexNumber, array | float | int | string $realNumber): array | string
     {
         if (is_array($complexNumber) || is_array($realNumber)) {
             return self::evaluateArrayArguments([self::class, __FUNCTION__], $complexNumber, $realNumber);

src/PhpSpreadsheet/Calculation/Engineering/Erf.php

Spacing +2 added lines, -2 removed lines

@@ -34,7 +34,7 @@ 
      * @return array<mixed>|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 ERF(mixed $lower, mixed $upper = null): array|float|string
+    public static function ERF(mixed $lower, mixed $upper = null): array | float | string
     {
         if (is_array($lower) || is_array($upper)) {
             return self::evaluateArrayArguments([self::class, __FUNCTION__], $lower, $upper);
@@ -83,7 +83,7 @@ 
     /**
      * Method to calculate the erf value.
      */
-    public static function erfValue(float|int|string $value): float
+    public static function erfValue(float | int | string $value): float
     {
         $value = (float) $value;
         if (abs($value) > 2.2) {

src/PhpSpreadsheet/Calculation/Engineering/ComplexOperations.php

Spacing +2 added lines, -2 removed lines

@@ -28,7 +28,7 @@ 
      * @return array<mixed>|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 IMDIV(array|string $complexDividend, array|string $complexDivisor): array|string
+    public static function IMDIV(array | string $complexDividend, array | string $complexDivisor): array | string
     {
         if (is_array($complexDividend) || is_array($complexDivisor)) {
             return self::evaluateArrayArguments([self::class, __FUNCTION__], $complexDividend, $complexDivisor);
@@ -57,7 +57,7 @@ 
      * @return array<mixed>|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 IMSUB(array|string $complexNumber1, array|string $complexNumber2): array|string
+    public static function IMSUB(array | string $complexNumber1, array | string $complexNumber2): array | string
     {
         if (is_array($complexNumber1) || is_array($complexNumber2)) {
             return self::evaluateArrayArguments([self::class, __FUNCTION__], $complexNumber1, $complexNumber2);