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/TextData/Extract.php

Spacing +6 added lines, -6 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);

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