PHPOffice / PhpSpreadsheet

src/PhpSpreadsheet/Calculation/Internal/ExcelArrayPseudoFunctions.php

Spacing +1 added lines, -1 removed lines

@@ -40,7 +40,7 @@
     }
 
     /** @return array<mixed>|string */
-    public static function anchorArray(string $cellReference, Cell $cell): array|string
+    public static function anchorArray(string $cellReference, Cell $cell): array | string
     {
         //$coordinate = $cell->getCoordinate();
         $worksheet = $cell->getWorksheet();

src/PhpSpreadsheet/Calculation/Logical/Operations.php

Spacing +2 added lines, -2 removed lines

@@ -110,7 +110,7 @@ 
      *         If an array of values is passed as an argument, then the returned result will also be an array
      *            with the same dimensions
      */
-    public static function NOT(mixed $logical = false): array|bool|string
+    public static function NOT(mixed $logical = false): array | bool | string
     {
         if (is_array($logical)) {
             return self::evaluateSingleArgumentArray([self::class, __FUNCTION__], $logical);
@@ -131,7 +131,7 @@ 
     }
 
     /** @param mixed[] $args */
-    private static function countTrueValues(array $args, callable $func): bool|string
+    private static function countTrueValues(array $args, callable $func): bool | string
     {
         $trueValueCount = 0;
         $count = 0;

src/PhpSpreadsheet/Calculation/Statistical/Trends.php

Spacing +6 added lines, -6 removed lines

@@ -76,7 +76,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();
@@ -102,7 +102,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);
@@ -190,7 +190,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);
@@ -217,7 +217,7 @@ 
      *
      * @return array<mixed>|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);
@@ -278,7 +278,7 @@ 
      *
      * @return array<mixed>|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);
@@ -389,7 +389,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/Financial/CashFlow/Variable/Periodic.php

Spacing +3 added lines, -3 removed lines

@@ -29,7 +29,7 @@ 
      *                                    calculate the internal rate of return.
      * @param mixed $guess A number that you guess is close to the result of IRR
      */
-    public static function rate(mixed $values, mixed $guess = 0.1): string|float
+    public static function rate(mixed $values, mixed $guess = 0.1): string | float
     {
         if (!is_array($values)) {
             return ExcelError::VALUE();
@@ -100,7 +100,7 @@ 
      *
      * @return float|string Result, or a string containing an error
      */
-    public static function modifiedRate(mixed $values, mixed $financeRate, mixed $reinvestmentRate): string|float
+    public static function modifiedRate(mixed $values, mixed $financeRate, mixed $reinvestmentRate): string | float
     {
         if (!is_array($values)) {
             return ExcelError::DIV0();
@@ -142,7 +142,7 @@ 
      *
      * @param array<mixed> $args
      */
-    public static function presentValue(mixed $rate, ...$args): int|float
+    public static function presentValue(mixed $rate, ...$args): int | float
     {
         $returnValue = 0;
 

src/PhpSpreadsheet/Calculation/Financial/CashFlow/Variable/NonPeriodic.php

Spacing +5 added lines, -5 removed lines

@@ -31,7 +31,7 @@ 
      *                                All other dates must be later than this date, but they may occur in any order
      * @param mixed $guess        An optional guess at the expected answer
      */
-    public static function rate(mixed $values, $dates, mixed $guess = self::DEFAULT_GUESS): float|string
+    public static function rate(mixed $values, $dates, mixed $guess = self::DEFAULT_GUESS): float | string
     {
         $rslt = self::xirrPart1($values, $dates);
         /** @var array<int, float|int|numeric-string> $dates */
@@ -120,7 +120,7 @@ 
      *                         The first payment date indicates the beginning of the schedule of payments.
      *                         All other dates must be later than this date, but they may occur in any order.
      */
-    public static function presentValue(mixed $rate, mixed $values, mixed $dates): float|string
+    public static function presentValue(mixed $rate, mixed $values, mixed $dates): float | string
     {
         return self::xnpvOrdered($rate, $values, $dates, true);
     }
@@ -185,7 +185,7 @@ 
      * @param array<int, float|int|numeric-string> $values
      * @param array<int, float|int|numeric-string> $dates
      */
-    private static function xirrPart3(array $values, array $dates, float $x1, float $x2): float|string
+    private static function xirrPart3(array $values, array $dates, float $x1, float $x2): float | string
     {
         $f = self::xnpvOrdered($x1, $values, $dates, false);
         if ($f < 0.0) {
@@ -218,7 +218,7 @@ 
      * @param array<int, float|int|numeric-string> $values
      * @param array<int, float|int|numeric-string> $dates
      */
-    private static function xirrBisection(array $values, array $dates, float $x1, float $x2): string|float
+    private static function xirrBisection(array $values, array $dates, float $x1, float $x2): string | float
     {
         $rslt = ExcelError::NAN();
         for ($i = 0; $i < self::FINANCIAL_MAX_ITERATIONS; ++$i) {
@@ -255,7 +255,7 @@ 
     }
 
     /** @param array<int,float|int|numeric-string> $values> */
-    private static function xnpvOrdered(mixed $rate, mixed $values, mixed $dates, bool $ordered = true, bool $capAtNegative1 = false): float|string
+    private static function xnpvOrdered(mixed $rate, mixed $values, mixed $dates, bool $ordered = true, bool $capAtNegative1 = false): float | string
     {
         $rate = Functions::flattenSingleValue($rate);
         if (!is_numeric($rate)) {

src/PhpSpreadsheet/Calculation/Financial/Dollar.php

Spacing +2 added lines, -2 removed lines

@@ -50,7 +50,7 @@ 
      *
      * @return array<mixed>|float|string
      */
-    public static function decimal(mixed $fractionalDollar = null, mixed $fraction = 0): array|string|float
+    public static function decimal(mixed $fractionalDollar = null, mixed $fraction = 0): array | string | float
     {
         if (is_array($fractionalDollar) || is_array($fraction)) {
             return self::evaluateArrayArguments([self::class, __FUNCTION__], $fractionalDollar, $fraction);
@@ -98,7 +98,7 @@ 
      *
      * @return array<mixed>|float|string
      */
-    public static function fractional(mixed $decimalDollar = null, mixed $fraction = 0): array|string|float
+    public static function fractional(mixed $decimalDollar = null, mixed $fraction = 0): array | string | float
     {
         if (is_array($decimalDollar) || is_array($fraction)) {
             return self::evaluateArrayArguments([self::class, __FUNCTION__], $decimalDollar, $fraction);

src/PhpSpreadsheet/Calculation/Information/ErrorValue.php

Spacing +3 added lines, -3 removed lines

@@ -18,7 +18,7 @@ 
      * @return array<mixed>|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 isErr(mixed $value = ''): array|bool
+    public static function isErr(mixed $value = ''): array | bool
     {
         if (is_array($value)) {
             return self::evaluateSingleArgumentArray([self::class, __FUNCTION__], $value);
@@ -36,7 +36,7 @@ 
      * @return array<mixed>|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 isError(mixed $value = '', bool $tryNotImplemented = false): array|bool
+    public static function isError(mixed $value = '', bool $tryNotImplemented = false): array | bool
     {
         if (is_array($value)) {
             return self::evaluateSingleArgumentArray([self::class, __FUNCTION__], $value);
@@ -61,7 +61,7 @@ 
      * @return array<mixed>|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 isNa(mixed $value = ''): array|bool
+    public static function isNa(mixed $value = ''): array | bool
     {
         if (is_array($value)) {
             return self::evaluateSingleArgumentArray([self::class, __FUNCTION__], $value);

src/PhpSpreadsheet/Calculation/Information/Value.php

Spacing +8 added lines, -8 removed lines

@@ -24,7 +24,7 @@ 
      * @return array<mixed>|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);
@@ -73,7 +73,7 @@ 
      * @return array<mixed>|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);
@@ -98,7 +98,7 @@ 
      * @return array<mixed>|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);
@@ -123,7 +123,7 @@ 
      * @return array<mixed>|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);
@@ -145,7 +145,7 @@ 
      * @return array<mixed>|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);
@@ -163,7 +163,7 @@ 
      * @return array<mixed>|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);
@@ -181,7 +181,7 @@ 
      * @return array<mixed>|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);
@@ -198,7 +198,7 @@ 
      *
      * @return array<mixed>|bool|string
      */
-    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/Information/ExcelError.php

Spacing +1 added lines, -1 removed lines

@@ -42,7 +42,7 @@
      *
      * @return array<mixed>|int|string
      */
-    public static function type(mixed $value = ''): array|int|string
+    public static function type(mixed $value = ''): array | int | string
     {
         if (is_array($value)) {
             return self::evaluateSingleArgumentArray([self::class, __FUNCTION__], $value);