PHPOffice / PhpSpreadsheet

src/PhpSpreadsheet/Calculation/TextData/Format.php

Spacing +4 added lines, -4 removed lines

@@ -78,7 +78,7 @@ 
      *         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 FIXEDFORMAT(mixed $value, mixed $decimals = 2, mixed $noCommas = false): array|string
+    public static function FIXEDFORMAT(mixed $value, mixed $decimals = 2, mixed $noCommas = false): array | string
     {
         if (is_array($value) || is_array($decimals) || is_array($noCommas)) {
             return self::evaluateArrayArguments([self::class, __FUNCTION__], $value, $decimals, $noCommas);
@@ -119,7 +119,7 @@ 
      *         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 TEXTFORMAT(mixed $value, mixed $format): array|string
+    public static function TEXTFORMAT(mixed $value, mixed $format): array | string
     {
         if (is_array($value) || is_array($format)) {
             return self::evaluateArrayArguments([self::class, __FUNCTION__], $value, $format);
@@ -229,7 +229,7 @@ 
      *         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 valueToText(mixed $value, mixed $format = false): array|string
+    public static function valueToText(mixed $value, mixed $format = false): array | string
     {
         if (is_array($value) || is_array($format)) {
             return self::evaluateArrayArguments([self::class, __FUNCTION__], $value, $format);
@@ -270,7 +270,7 @@ 
      * @param mixed $groupSeparator A string with the group/thousands separator to use, defaults to locale defined value
      *                         Or can be an array of values
      */
-    public static function NUMBERVALUE(mixed $value = '', mixed $decimalSeparator = null, mixed $groupSeparator = null): array|string|float
+    public static function NUMBERVALUE(mixed $value = '', mixed $decimalSeparator = null, mixed $groupSeparator = null): array | string | float
     {
         if (is_array($value) || is_array($decimalSeparator) || is_array($groupSeparator)) {
             return self::evaluateArrayArguments([self::class, __FUNCTION__], $value, $decimalSeparator, $groupSeparator);

src/PhpSpreadsheet/Calculation/TextData/Search.php

Spacing +2 added lines, -2 removed lines

@@ -25,7 +25,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 sensitive(mixed $needle, mixed $haystack, mixed $offset = 1): array|string|int
+    public static function sensitive(mixed $needle, mixed $haystack, mixed $offset = 1): array | string | int
     {
         if (is_array($needle) || is_array($haystack) || is_array($offset)) {
             return self::evaluateArrayArguments([self::class, __FUNCTION__], $needle, $haystack, $offset);
@@ -67,7 +67,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 insensitive(mixed $needle, mixed $haystack, mixed $offset = 1): array|string|int
+    public static function insensitive(mixed $needle, mixed $haystack, mixed $offset = 1): array | string | int
     {
         if (is_array($needle) || is_array($haystack) || is_array($offset)) {
             return self::evaluateArrayArguments([self::class, __FUNCTION__], $needle, $haystack, $offset);

src/PhpSpreadsheet/Calculation/TextData/Replace.php

Spacing +2 added lines, -2 removed lines

@@ -29,7 +29,7 @@ 
      *         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 replace(mixed $oldText, mixed $start, mixed $chars, mixed $newText): array|string
+    public static function replace(mixed $oldText, mixed $start, mixed $chars, mixed $newText): array | string
     {
         if (is_array($oldText) || is_array($start) || is_array($chars) || is_array($newText)) {
             return self::evaluateArrayArguments([self::class, __FUNCTION__], $oldText, $start, $chars, $newText);
@@ -70,7 +70,7 @@ 
      *         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 substitute(mixed $text = '', mixed $fromText = '', mixed $toText = '', mixed $instance = null): array|string
+    public static function substitute(mixed $text = '', mixed $fromText = '', mixed $toText = '', mixed $instance = null): array | string
     {
         if (is_array($text) || is_array($fromText) || is_array($toText) || is_array($instance)) {
             return self::evaluateArrayArguments([self::class, __FUNCTION__], $text, $fromText, $toText, $instance);

src/PhpSpreadsheet/Calculation/TextData/CaseConvert.php

Spacing +3 added lines, -3 removed lines

@@ -21,7 +21,7 @@ 
      *         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);
@@ -44,7 +44,7 @@ 
      *         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);
@@ -67,7 +67,7 @@ 
      *         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 +5 added lines, -5 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);
@@ -184,7 +184,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);

src/PhpSpreadsheet/Calculation/TextData/Concatenate.php

Spacing +2 added lines, -2 removed lines

@@ -56,7 +56,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(mixed $delimiter = '', mixed $ignoreEmpty = true, mixed ...$args): array|string
+    public static function TEXTJOIN(mixed $delimiter = '', mixed $ignoreEmpty = true, mixed ...$args): array | string
     {
         if (is_array($delimiter) || is_array($ignoreEmpty)) {
             return self::evaluateArrayArgumentsSubset(
@@ -113,7 +113,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/Logical.php

Spacing +1 added lines, -1 removed lines

@@ -159,7 +159,7 @@
      *
      * @return array|bool|string the boolean inverse of the argument
      */
-    public static function NOT(mixed $logical = false): bool|string|array
+    public static function NOT(mixed $logical = false): bool | string | array
     {
         return Logical\Operations::NOT($logical);
     }

src/PhpSpreadsheet/Calculation/LookupRef/ExcelMatch.php

Spacing +3 added lines, -3 removed lines

@@ -32,7 +32,7 @@ 
      *
      * @return array|int|string The relative position of the found item
      */
-    public static function MATCH(mixed $lookupValue, mixed $lookupArray, mixed $matchType = self::MATCHTYPE_LARGEST_VALUE): array|string|int|float
+    public static function MATCH(mixed $lookupValue, mixed $lookupArray, mixed $matchType = self::MATCHTYPE_LARGEST_VALUE): array | string | int | float
     {
         if (is_array($lookupValue)) {
             return self::evaluateArrayArgumentsIgnore([self::class, __FUNCTION__], 1, $lookupValue, $lookupArray, $matchType);
@@ -78,7 +78,7 @@ 
         return ExcelError::NA();
     }
 
-    private static function matchFirstValue(array $lookupArray, mixed $lookupValue): int|string|null
+    private static function matchFirstValue(array $lookupArray, mixed $lookupValue): int | string | null
     {
         if (is_string($lookupValue)) {
             $valueIsString = true;
@@ -151,7 +151,7 @@ 
         return null;
     }
 
-    private static function matchSmallestValue(array $lookupArray, mixed $lookupValue): int|string|null
+    private static function matchSmallestValue(array $lookupArray, mixed $lookupValue): int | string | null
     {
         $valueKey = null;
         if (is_string($lookupValue)) {

src/PhpSpreadsheet/Calculation/LookupRef/Offset.php

Spacing +1 added lines, -1 removed lines

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