PHPOffice / PhpSpreadsheet

src/PhpSpreadsheet/Calculation/Financial/CashFlow/Constant/Periodic/Interest.php

Spacing +4 added lines, -4 removed lines

@@ -37,7 +37,7 @@ 
         mixed $presentValue,
         mixed $futureValue = 0,
         mixed $type = FinancialConstants::PAYMENT_END_OF_PERIOD
-    ): string|float {
+    ): string | float {
         $interestRate = Functions::flattenSingleValue($interestRate);
         $period = Functions::flattenSingleValue($period);
         $numberOfPeriods = Functions::flattenSingleValue($numberOfPeriods);
@@ -87,7 +87,7 @@ 
      * @param mixed $numberOfPeriods is the number of payments for the annuity
      * @param mixed $principleRemaining is the loan amount or present value of the payments
      */
-    public static function schedulePayment(mixed $interestRate, mixed $period, mixed $numberOfPeriods, mixed $principleRemaining): string|float
+    public static function schedulePayment(mixed $interestRate, mixed $period, mixed $numberOfPeriods, mixed $principleRemaining): string | float
     {
         $interestRate = Functions::flattenSingleValue($interestRate);
         $period = Functions::flattenSingleValue($period);
@@ -156,7 +156,7 @@ 
         mixed $futureValue = 0.0,
         mixed $type = FinancialConstants::PAYMENT_END_OF_PERIOD,
         mixed $guess = 0.1
-    ): string|float {
+    ): string | float {
         $numberOfPeriods = Functions::flattenSingleValue($numberOfPeriods);
         $payment = Functions::flattenSingleValue($payment);
         $presentValue = Functions::flattenSingleValue($presentValue);
@@ -193,7 +193,7 @@ 
         return $close ? $rate : ExcelError::NAN();
     }
 
-    private static function rateNextGuess(float $rate, int $numberOfPeriods, float $payment, float $presentValue, float $futureValue, int $type): string|float
+    private static function rateNextGuess(float $rate, int $numberOfPeriods, float $payment, float $presentValue, float $futureValue, int $type): string | float
     {
         if ($rate == 0.0) {
             return ExcelError::NAN();

src/PhpSpreadsheet/Calculation/Financial/CashFlow/Constant/Periodic/Cumulative.php

Spacing +2 added lines, -2 removed lines

@@ -37,7 +37,7 @@ 
         mixed $start,
         mixed $end,
         mixed $type = FinancialConstants::PAYMENT_END_OF_PERIOD
-    ): string|float|int {
+    ): string | float | int {
         $rate = Functions::flattenSingleValue($rate);
         $periods = Functions::flattenSingleValue($periods);
         $presentValue = Functions::flattenSingleValue($presentValue);
@@ -102,7 +102,7 @@ 
         mixed $start,
         mixed $end,
         mixed $type = FinancialConstants::PAYMENT_END_OF_PERIOD
-    ): string|float|int {
+    ): string | float | int {
         $rate = Functions::flattenSingleValue($rate);
         $periods = Functions::flattenSingleValue($periods);
         $presentValue = Functions::flattenSingleValue($presentValue);

src/PhpSpreadsheet/Calculation/Financial/CashFlow/Constant/Periodic.php

Spacing +3 added lines, -3 removed lines

@@ -35,7 +35,7 @@ 
         mixed $payment = 0.0,
         mixed $presentValue = 0.0,
         mixed $type = FinancialConstants::PAYMENT_END_OF_PERIOD
-    ): string|float {
+    ): string | float {
         $rate = Functions::flattenSingleValue($rate);
         $numberOfPeriods = Functions::flattenSingleValue($numberOfPeriods);
         $payment = ($payment === null) ? 0.0 : Functions::flattenSingleValue($payment);
@@ -74,7 +74,7 @@ 
         mixed $payment = 0.0,
         mixed $futureValue = 0.0,
         mixed $type = FinancialConstants::PAYMENT_END_OF_PERIOD
-    ): string|float {
+    ): string | float {
         $rate = Functions::flattenSingleValue($rate);
         $numberOfPeriods = Functions::flattenSingleValue($numberOfPeriods);
         $payment = ($payment === null) ? 0.0 : Functions::flattenSingleValue($payment);
@@ -180,7 +180,7 @@ 
         float $presentValue,
         float $futureValue,
         int $type
-    ): string|float {
+    ): string | float {
         if ($rate != 0.0) {
             if ($presentValue == 0.0) {
                 return ExcelError::NAN();

src/PhpSpreadsheet/Calculation/Financial/InterestRate.php

Spacing +2 added lines, -2 removed lines

@@ -20,7 +20,7 @@ 
      * @param mixed $nominalRate Nominal interest rate as a float
      * @param mixed $periodsPerYear Integer number of compounding payments per year
      */
-    public static function effective(mixed $nominalRate = 0, mixed $periodsPerYear = 0): string|float
+    public static function effective(mixed $nominalRate = 0, mixed $periodsPerYear = 0): string | float
     {
         $nominalRate = Functions::flattenSingleValue($nominalRate);
         $periodsPerYear = Functions::flattenSingleValue($periodsPerYear);
@@ -49,7 +49,7 @@ 
      *
      * @return float|string Result, or a string containing an error
      */
-    public static function nominal(mixed $effectiveRate = 0, mixed $periodsPerYear = 0): string|float
+    public static function nominal(mixed $effectiveRate = 0, mixed $periodsPerYear = 0): string | float
     {
         $effectiveRate = Functions::flattenSingleValue($effectiveRate);
         $periodsPerYear = Functions::flattenSingleValue($periodsPerYear);

src/PhpSpreadsheet/Calculation/MathTrig.php

Spacing +28 added lines, -28 removed lines

@@ -53,7 +53,7 @@ 
      *
      * @return array|float|string the inverse tangent of the specified x- and y-coordinates, or a string containing an error
      */
-    public static function ATAN2($xCoordinate = null, $yCoordinate = null): string|float|array
+    public static function ATAN2($xCoordinate = null, $yCoordinate = null): string | float | array
     {
         return MathTrig\Trig\Tangent::atan2($xCoordinate, $yCoordinate);
     }
@@ -76,7 +76,7 @@ 
      *
      * @return array|string the text representation with the given radix (base)
      */
-    public static function BASE($number, $radix, $minLength = null): string|array
+    public static function BASE($number, $radix, $minLength = null): string | array
     {
         return MathTrig\Base::evaluate($number, $radix, $minLength);
     }
@@ -149,7 +149,7 @@ 
      *
      * @return array|float|string Rounded Number, or a string containing an error
      */
-    public static function EVEN($number): string|float|array
+    public static function EVEN($number): string | float | array
     {
         return MathTrig\Round::even($number);
     }
@@ -361,7 +361,7 @@ 
      *
      * @return array|float|string The result, or a string containing an error
      */
-    public static function logBase($number, $base = 10): string|float|array
+    public static function logBase($number, $base = 10): string | float | array
     {
         return MathTrig\Logarithms::withBase($number, $base);
     }
@@ -403,7 +403,7 @@ 
      *
      * @return array|string The result, or a string containing an error
      */
-    public static function MINVERSE($matrixValues): string|array
+    public static function MINVERSE($matrixValues): string | array
     {
         return MathTrig\MatrixFunctions::inverse($matrixValues);
     }
@@ -420,7 +420,7 @@ 
      *
      * @return array|string The result, or a string containing an error
      */
-    public static function MMULT($matrixData1, $matrixData2): string|array
+    public static function MMULT($matrixData1, $matrixData2): string | array
     {
         return MathTrig\MatrixFunctions::multiply($matrixData1, $matrixData2);
     }
@@ -456,7 +456,7 @@ 
      *
      * @return array|float|string Rounded Number, or a string containing an error
      */
-    public static function MROUND($number, $multiple): string|int|float|array
+    public static function MROUND($number, $multiple): string | int | float | array
     {
         return MathTrig\Round::multiple($number, $multiple);
     }
@@ -492,7 +492,7 @@ 
      *
      * @return array|float|int|string Rounded Number, or a string containing an error
      */
-    public static function ODD($number): string|int|float|array
+    public static function ODD($number): string | int | float | array
     {
         return MathTrig\Round::odd($number);
     }
@@ -569,7 +569,7 @@ 
      *
      * @return array|int|string Random number
      */
-    public static function RAND($min = 0, $max = 0): string|int|array
+    public static function RAND($min = 0, $max = 0): string | int | array
     {
         return MathTrig\Random::randBetween($min, $max);
     }
@@ -588,7 +588,7 @@ 
      *
      * @return array|string Roman numeral, or a string containing an error
      */
-    public static function ROMAN(mixed $aValue, mixed $style = 0): string|array
+    public static function ROMAN(mixed $aValue, mixed $style = 0): string | array
     {
         return MathTrig\Roman::evaluate($aValue, $style);
     }
@@ -607,7 +607,7 @@ 
      *
      * @return array|float|string Rounded Number, or a string containing an error
      */
-    public static function ROUNDUP($number, $digits): string|float|array
+    public static function ROUNDUP($number, $digits): string | float | array
     {
         return MathTrig\Round::up($number, $digits);
     }
@@ -626,7 +626,7 @@ 
      *
      * @return array|float|string Rounded Number, or a string containing an error
      */
-    public static function ROUNDDOWN($number, $digits): string|float|array
+    public static function ROUNDDOWN($number, $digits): string | float | array
     {
         return MathTrig\Round::down($number, $digits);
     }
@@ -647,7 +647,7 @@ 
      *
      * @return array|float|string The result, or a string containing an error
      */
-    public static function SERIESSUM(mixed $x, mixed $n, mixed $m, ...$args): string|float|int|array
+    public static function SERIESSUM(mixed $x, mixed $n, mixed $m, ...$args): string | float | int | array
     {
         return MathTrig\SeriesSum::evaluate($x, $n, $m, ...$args);
     }
@@ -666,7 +666,7 @@ 
      *
      * @return array|int|string sign value, or a string containing an error
      */
-    public static function SIGN($number): string|int|array
+    public static function SIGN($number): string | int | array
     {
         return MathTrig\Sign::evaluate($number);
     }
@@ -696,7 +696,7 @@ 
      *
      * @return array|float|string Square Root of Number * Pi, or a string containing an error
      */
-    public static function SQRTPI($number): string|float|array
+    public static function SQRTPI($number): string | float | array
     {
         return MathTrig\Sqrt::pi($number);
     }
@@ -804,7 +804,7 @@ 
      *
      * @return float|string The result, or a string containing an error
      */
-    public static function SUMPRODUCT(mixed ...$args): string|int|float
+    public static function SUMPRODUCT(mixed ...$args): string | int | float
     {
         return MathTrig\Sum::product(...$args);
     }
@@ -1074,7 +1074,7 @@ 
      *
      * @return array|float|string Rounded number
      */
-    public static function builtinROUND($number, $precision): string|float|array
+    public static function builtinROUND($number, $precision): string | float | array
     {
         return MathTrig\Round::round($number, $precision);
     }
@@ -1092,7 +1092,7 @@ 
      *
      * @return array|float|int|string Rounded number
      */
-    public static function builtinABS($number): string|int|float|array
+    public static function builtinABS($number): string | int | float | array
     {
         return MathTrig\Absolute::evaluate($number);
     }
@@ -1218,7 +1218,7 @@ 
      *
      * @return array|float|string Rounded number
      */
-    public static function builtinCOS($number): string|float|array
+    public static function builtinCOS($number): string | float | array
     {
         return MathTrig\Trig\Cosine::cos($number);
     }
@@ -1236,7 +1236,7 @@ 
      *
      * @return array|float|string Rounded number
      */
-    public static function builtinCOSH($number): string|float|array
+    public static function builtinCOSH($number): string | float | array
     {
         return MathTrig\Trig\Cosine::cosh($number);
     }
@@ -1254,7 +1254,7 @@ 
      *
      * @return array|float|string Rounded number
      */
-    public static function builtinDEGREES($number): string|float|array
+    public static function builtinDEGREES($number): string | float | array
     {
         return MathTrig\Angle::toDegrees($number);
     }
@@ -1272,7 +1272,7 @@ 
      *
      * @return array|float|string Rounded number
      */
-    public static function builtinEXP($number): string|float|array
+    public static function builtinEXP($number): string | float | array
     {
         return MathTrig\Exp::evaluate($number);
     }
@@ -1290,7 +1290,7 @@ 
      *
      * @return array|float|string Rounded number
      */
-    public static function builtinLN(mixed $number): string|float|array
+    public static function builtinLN(mixed $number): string | float | array
     {
         return MathTrig\Logarithms::natural($number);
     }
@@ -1308,7 +1308,7 @@ 
      *
      * @return array|float|string Rounded number
      */
-    public static function builtinLOG10(mixed $number): string|float|array
+    public static function builtinLOG10(mixed $number): string | float | array
     {
         return MathTrig\Logarithms::base10($number);
     }
@@ -1326,7 +1326,7 @@ 
      *
      * @return array|float|string Rounded number
      */
-    public static function builtinRADIANS($number): string|float|array
+    public static function builtinRADIANS($number): string | float | array
     {
         return MathTrig\Angle::toRadians($number);
     }
@@ -1344,7 +1344,7 @@ 
      *
      * @return array|float|string sine
      */
-    public static function builtinSIN($number): string|float|array
+    public static function builtinSIN($number): string | float | array
     {
         return MathTrig\Trig\Sine::sin($number);
     }
@@ -1362,7 +1362,7 @@ 
      *
      * @return array|float|string Rounded number
      */
-    public static function builtinSINH($number): string|float|array
+    public static function builtinSINH($number): string | float | array
     {
         return MathTrig\Trig\Sine::sinh($number);
     }
@@ -1416,7 +1416,7 @@ 
      *
      * @return array|float|string Rounded number
      */
-    public static function builtinTANH($number): string|float|array
+    public static function builtinTANH($number): string | float | array
     {
         return MathTrig\Trig\Tangent::tanh($number);
     }

src/PhpSpreadsheet/Calculation/Engineering/Erf.php

Spacing +1 added lines, -1 removed lines

@@ -35,7 +35,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 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);

src/PhpSpreadsheet/Calculation/Engineering/BesselJ.php

Spacing +1 added lines, -1 removed lines

@@ -34,7 +34,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 BESSELJ(mixed $x, mixed $ord): array|string|float
+    public static function BESSELJ(mixed $x, mixed $ord): array | string | float
     {
         if (is_array($x) || is_array($ord)) {
             return self::evaluateArrayArguments([self::class, __FUNCTION__], $x, $ord);

src/PhpSpreadsheet/Calculation/Engineering/BesselK.php

Spacing +1 added lines, -1 removed lines

@@ -32,7 +32,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 BESSELK(mixed $x, mixed $ord): array|string|float
+    public static function BESSELK(mixed $x, mixed $ord): array | string | float
     {
         if (is_array($x) || is_array($ord)) {
             return self::evaluateArrayArguments([self::class, __FUNCTION__], $x, $ord);

src/PhpSpreadsheet/Calculation/Engineering/Complex.php

Spacing +3 added lines, -3 removed lines

@@ -32,7 +32,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 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);
@@ -74,7 +74,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);
@@ -104,7 +104,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);