PHPOffice / PhpSpreadsheet

src/PhpSpreadsheet/Calculation/TextData/CaseConvert.php

Spacing +3 added lines, -3 removed lines

@@ -20,7 +20,7 @@ 
      * @return array|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);
@@ -42,7 +42,7 @@ 
      * @return array|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);
@@ -64,7 +64,7 @@ 
      * @return array|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);
@@ -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);
@@ -216,7 +216,7 @@ 
         return implode('', $split);
     }
 
-    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/TextData/Replace.php

Spacing +2 added lines, -2 removed lines

@@ -28,7 +28,7 @@ 
      * @return array|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 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);
@@ -68,7 +68,7 @@ 
      * @return array|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 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/Information/Value.php

Spacing +8 added lines, -8 removed lines

@@ -23,7 +23,7 @@ 
      * @return array|bool 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 isBlank(mixed $value = null): array|bool
+    public static function isBlank(mixed $value = null): array | bool
     {
         if (is_array($value)) {
             return self::evaluateSingleArgumentArray([self::class, __FUNCTION__], $value);
@@ -71,7 +71,7 @@ 
      * @return array|bool|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 isEven(mixed $value = null): array|string|bool
+    public static function isEven(mixed $value = null): array | string | bool
     {
         if (is_array($value)) {
             return self::evaluateSingleArgumentArray([self::class, __FUNCTION__], $value);
@@ -95,7 +95,7 @@ 
      * @return array|bool|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 isOdd(mixed $value = null): array|string|bool
+    public static function isOdd(mixed $value = null): array | string | bool
     {
         if (is_array($value)) {
             return self::evaluateSingleArgumentArray([self::class, __FUNCTION__], $value);
@@ -119,7 +119,7 @@ 
      * @return array|bool 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 isNumber(mixed $value = null): array|bool
+    public static function isNumber(mixed $value = null): array | bool
     {
         if (is_array($value)) {
             return self::evaluateSingleArgumentArray([self::class, __FUNCTION__], $value);
@@ -141,7 +141,7 @@ 
      * @return array|bool 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 isLogical(mixed $value = null): array|bool
+    public static function isLogical(mixed $value = null): array | bool
     {
         if (is_array($value)) {
             return self::evaluateSingleArgumentArray([self::class, __FUNCTION__], $value);
@@ -159,7 +159,7 @@ 
      * @return array|bool 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 isText(mixed $value = null): array|bool
+    public static function isText(mixed $value = null): array | bool
     {
         if (is_array($value)) {
             return self::evaluateSingleArgumentArray([self::class, __FUNCTION__], $value);
@@ -177,7 +177,7 @@ 
      * @return array|bool 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 isNonText(mixed $value = null): array|bool
+    public static function isNonText(mixed $value = null): array | bool
     {
         if (is_array($value)) {
             return self::evaluateSingleArgumentArray([self::class, __FUNCTION__], $value);
@@ -192,7 +192,7 @@ 
      * @param mixed $cellReference The cell to check
      * @param ?Cell $cell The current cell (containing this formula)
      */
-    public static function isFormula(mixed $cellReference = '', ?Cell $cell = null): array|bool|string
+    public static function isFormula(mixed $cellReference = '', ?Cell $cell = null): array | bool | string
     {
         if ($cell === null) {
             return ExcelError::REF();

src/PhpSpreadsheet/Calculation/Statistical/Deviations.php

Spacing +3 added lines, -3 removed lines

@@ -17,7 +17,7 @@ 
      *
      * @param mixed ...$args Data values
      */
-    public static function sumSquares(mixed ...$args): string|float
+    public static function sumSquares(mixed ...$args): string | float
     {
         $aArgs = Functions::flattenArrayIndexed($args);
 
@@ -57,7 +57,7 @@ 
      *
      * @param array ...$args Data Series
      */
-    public static function kurtosis(...$args): string|int|float
+    public static function kurtosis(...$args): string | int | float
     {
         $aArgs = Functions::flattenArrayIndexed($args);
         $mean = Averages::average($aArgs);
@@ -102,7 +102,7 @@ 
      *
      * @return float|int|string The result, or a string containing an error
      */
-    public static function skew(...$args): string|int|float
+    public static function skew(...$args): string | int | float
     {
         $aArgs = Functions::flattenArrayIndexed($args);
         $mean = Averages::average($aArgs);

src/PhpSpreadsheet/Calculation/Statistical/Minimum.php

Spacing +2 added lines, -2 removed lines

@@ -18,7 +18,7 @@ 
      *
      * @param mixed ...$args Data values
      */
-    public static function min(mixed ...$args): float|int|string
+    public static function min(mixed ...$args): float | int | string
     {
         $returnValue = null;
 
@@ -55,7 +55,7 @@ 
      *
      * @param mixed ...$args Data values
      */
-    public static function minA(mixed ...$args): float|int|string
+    public static function minA(mixed ...$args): float | int | string
     {
         $returnValue = null;
 

src/PhpSpreadsheet/Calculation/Statistical/Trends.php

Spacing +6 added lines, -6 removed lines

@@ -65,7 +65,7 @@ 
      * @param mixed $yValues array of mixed Data Series Y
      * @param null|mixed $xValues array of mixed Data Series X
      */
-    public static function CORREL(mixed $yValues, $xValues = null): float|string
+    public static function CORREL(mixed $yValues, $xValues = null): float | string
     {
         if (($xValues === null) || (!is_array($yValues)) || (!is_array($xValues))) {
             return ExcelError::VALUE();
@@ -91,7 +91,7 @@ 
      * @param mixed[] $yValues array of mixed Data Series Y
      * @param mixed[] $xValues array of mixed Data Series X
      */
-    public static function COVAR(array $yValues, array $xValues): float|string
+    public static function COVAR(array $yValues, array $xValues): float | string
     {
         try {
             self::checkTrendArrays($yValues, $xValues);
@@ -178,7 +178,7 @@ 
      * @param mixed[] $yValues Data Series Y
      * @param mixed[] $xValues Data Series X
      */
-    public static function INTERCEPT(array $yValues, array $xValues): float|string
+    public static function INTERCEPT(array $yValues, array $xValues): float | string
     {
         try {
             self::checkTrendArrays($yValues, $xValues);
@@ -205,7 +205,7 @@ 
      *
      * @return array|string The result, or a string containing an error
      */
-    public static function LINEST(array $yValues, ?array $xValues = null, mixed $const = true, mixed $stats = false): string|array
+    public static function LINEST(array $yValues, ?array $xValues = null, mixed $const = true, mixed $stats = false): string | array
     {
         $const = ($const === null) ? true : (bool) Functions::flattenSingleValue($const);
         $stats = ($stats === null) ? false : (bool) Functions::flattenSingleValue($stats);
@@ -266,7 +266,7 @@ 
      *
      * @return array|string The result, or a string containing an error
      */
-    public static function LOGEST(array $yValues, ?array $xValues = null, mixed $const = true, mixed $stats = false): string|array
+    public static function LOGEST(array $yValues, ?array $xValues = null, mixed $const = true, mixed $stats = false): string | array
     {
         $const = ($const === null) ? true : (bool) Functions::flattenSingleValue($const);
         $stats = ($stats === null) ? false : (bool) Functions::flattenSingleValue($stats);
@@ -377,7 +377,7 @@ 
      * @param mixed[] $yValues Data Series Y
      * @param mixed[] $xValues Data Series X
      */
-    public static function STEYX(array $yValues, array $xValues): float|string
+    public static function STEYX(array $yValues, array $xValues): float | string
     {
         try {
             self::checkTrendArrays($yValues, $xValues);

src/PhpSpreadsheet/Calculation/Statistical/StandardDeviations.php

Spacing +3 added lines, -3 removed lines

@@ -37,7 +37,7 @@ 
      *
      * @param mixed ...$args Data values
      */
-    public static function STDEVA(mixed ...$args): float|string
+    public static function STDEVA(mixed ...$args): float | string
     {
         $result = Variances::VARA(...$args);
         if (!is_numeric($result)) {
@@ -57,7 +57,7 @@ 
      *
      * @param mixed ...$args Data values
      */
-    public static function STDEVP(mixed ...$args): float|string
+    public static function STDEVP(mixed ...$args): float | string
     {
         $result = Variances::VARP(...$args);
         if (!is_numeric($result)) {
@@ -77,7 +77,7 @@ 
      *
      * @param mixed ...$args Data values
      */
-    public static function STDEVPA(mixed ...$args): float|string
+    public static function STDEVPA(mixed ...$args): float | string
     {
         $result = Variances::VARPA(...$args);
         if (!is_numeric($result)) {

src/PhpSpreadsheet/Calculation/Statistical/Maximum.php

Spacing +2 added lines, -2 removed lines

@@ -18,7 +18,7 @@ 
      *
      * @param mixed ...$args Data values
      */
-    public static function max(mixed ...$args): float|int|string
+    public static function max(mixed ...$args): float | int | string
     {
         $returnValue = null;
 
@@ -55,7 +55,7 @@ 
      *
      * @param mixed ...$args Data values
      */
-    public static function maxA(mixed ...$args): float|int|string
+    public static function maxA(mixed ...$args): float | int | string
     {
         $returnValue = null;