PHPOffice / PhpSpreadsheet

src/PhpSpreadsheet/Calculation/MathTrig/Helpers.php

Spacing +2 added lines, -2 removed lines

@@ -13,7 +13,7 @@ 
      *
      * @return float|string quotient or DIV0 if denominator is too small
      */
-    public static function verySmallDenominator(float $numerator, float $denominator): string|float
+    public static function verySmallDenominator(float $numerator, float $denominator): string | float
     {
         return (abs($denominator) < 1.0E-12) ? ExcelError::DIV0() : ($numerator / $denominator);
     }
@@ -21,7 +21,7 @@ 
     /**
      * Many functions accept null/false/true argument treated as 0/0/1.
      */
-    public static function validateNumericNullBool(mixed $number): int|float
+    public static function validateNumericNullBool(mixed $number): int | float
     {
         $number = Functions::flattenSingleValue($number);
         if ($number === null) {

src/PhpSpreadsheet/Calculation/MathTrig/Sum.php

Spacing +1 added lines, -1 removed lines

@@ -81,7 +81,7 @@
      *
      * @return float|int|string The result, or a string containing an error
      */
-    public static function product(mixed ...$args): string|int|float
+    public static function product(mixed ...$args): string | int | float
     {
         $arrayList = $args;
 

src/PhpSpreadsheet/Calculation/MathTrig/Exp.php

Spacing +1 added lines, -1 removed lines

@@ -20,7 +20,7 @@
      *         If an array of numbers is passed as the argument, then the returned result will also be an array
      *            with the same dimensions
      */
-    public static function evaluate(mixed $number): array|string|float
+    public static function evaluate(mixed $number): array | string | float
     {
         if (is_array($number)) {
             return self::evaluateSingleArgumentArray([self::class, __FUNCTION__], $number);

src/PhpSpreadsheet/Calculation/MathTrig/Round.php

Spacing +6 added lines, -6 removed lines

@@ -22,7 +22,7 @@ 
      *         If an array of numbers is passed as the argument, then the returned result will also be an array
      *            with the same dimensions
      */
-    public static function round(mixed $number, mixed $precision): array|string|float
+    public static function round(mixed $number, mixed $precision): array | string | float
     {
         if (is_array($number) || is_array($precision)) {
             return self::evaluateArrayArguments([self::class, __FUNCTION__], $number, $precision);
@@ -50,7 +50,7 @@ 
      *         If an array of numbers is passed as the argument, then the returned result will also be an array
      *            with the same dimensions
      */
-    public static function up($number, $digits): array|string|float
+    public static function up($number, $digits): array | string | float
     {
         if (is_array($number) || is_array($digits)) {
             return self::evaluateArrayArguments([self::class, __FUNCTION__], $number, $digits);
@@ -86,7 +86,7 @@ 
      *         If an array of numbers is passed as the argument, then the returned result will also be an array
      *            with the same dimensions
      */
-    public static function down($number, $digits): array|string|float
+    public static function down($number, $digits): array | string | float
     {
         if (is_array($number) || is_array($digits)) {
             return self::evaluateArrayArguments([self::class, __FUNCTION__], $number, $digits);
@@ -122,7 +122,7 @@ 
      *         If an array of numbers is passed as the argument, then the returned result will also be an array
      *            with the same dimensions
      */
-    public static function multiple(mixed $number, mixed $multiple): array|string|int|float
+    public static function multiple(mixed $number, mixed $multiple): array | string | int | float
     {
         if (is_array($number) || is_array($multiple)) {
             return self::evaluateArrayArguments([self::class, __FUNCTION__], $number, $multiple);
@@ -165,7 +165,7 @@ 
      *         If an array of numbers is passed as the argument, then the returned result will also be an array
      *            with the same dimensions
      */
-    public static function even($number): array|string|float
+    public static function even($number): array | string | float
     {
         if (is_array($number)) {
             return self::evaluateSingleArgumentArray([self::class, __FUNCTION__], $number);
@@ -191,7 +191,7 @@ 
      *         If an array of numbers is passed as the argument, then the returned result will also be an array
      *            with the same dimensions
      */
-    public static function odd($number): array|string|int|float
+    public static function odd($number): array | string | int | float
     {
         if (is_array($number)) {
             return self::evaluateSingleArgumentArray([self::class, __FUNCTION__], $number);

src/PhpSpreadsheet/Calculation/MathTrig/Operations.php

Spacing +3 added lines, -3 removed lines

@@ -23,7 +23,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 mod(mixed $dividend, mixed $divisor): array|string|float
+    public static function mod(mixed $dividend, mixed $divisor): array | string | float
     {
         if (is_array($dividend) || is_array($divisor)) {
             return self::evaluateArrayArguments([self::class, __FUNCTION__], $dividend, $divisor);
@@ -98,7 +98,7 @@ 
      *
      * @param mixed ...$args Data values
      */
-    public static function product(mixed ...$args): string|float
+    public static function product(mixed ...$args): string | float
     {
         $args = array_filter(
             Functions::flattenArray($args),
@@ -141,7 +141,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 quotient(mixed $numerator, mixed $denominator): array|string|int
+    public static function quotient(mixed $numerator, mixed $denominator): array | string | int
     {
         if (is_array($numerator) || is_array($denominator)) {
             return self::evaluateArrayArguments([self::class, __FUNCTION__], $numerator, $denominator);

src/PhpSpreadsheet/Calculation/MathTrig/Logarithms.php

Spacing +3 added lines, -3 removed lines

@@ -26,7 +26,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 withBase(mixed $number, mixed $base = 10): array|string|float
+    public static function withBase(mixed $number, mixed $base = 10): array | string | float
     {
         if (is_array($number) || is_array($base)) {
             return self::evaluateArrayArguments([self::class, __FUNCTION__], $number, $base);
@@ -56,7 +56,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 base10(mixed $number): array|string|float
+    public static function base10(mixed $number): array | string | float
     {
         if (is_array($number)) {
             return self::evaluateSingleArgumentArray([self::class, __FUNCTION__], $number);
@@ -84,7 +84,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 natural(mixed $number): array|string|float
+    public static function natural(mixed $number): array | string | float
     {
         if (is_array($number)) {
             return self::evaluateSingleArgumentArray([self::class, __FUNCTION__], $number);

src/PhpSpreadsheet/Calculation/MathTrig/Base.php

Spacing +1 added lines, -1 removed lines

@@ -29,7 +29,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 evaluate(mixed $number, mixed $radix, mixed $minLength = null): array|string
+    public static function evaluate(mixed $number, mixed $radix, mixed $minLength = null): array | string
     {
         if (is_array($number) || is_array($radix) || is_array($minLength)) {
             return self::evaluateArrayArguments([self::class, __FUNCTION__], $number, $radix, $minLength);

src/PhpSpreadsheet/Calculation/Financial.php

Spacing +14 added lines, -14 removed lines

@@ -321,7 +321,7 @@ 
      *
      * @return float|string Excel date/time serial value or error message
      */
-    public static function COUPNCD(mixed $settlement, mixed $maturity, mixed $frequency, $basis = 0): string|float
+    public static function COUPNCD(mixed $settlement, mixed $maturity, mixed $frequency, $basis = 0): string | float
     {
         return Coupons::COUPNCD($settlement, $maturity, $frequency, $basis);
     }
@@ -394,7 +394,7 @@ 
      *
      * @return float|string Excel date/time serial value or error message
      */
-    public static function COUPPCD(mixed $settlement, mixed $maturity, mixed $frequency, $basis = 0): string|float
+    public static function COUPPCD(mixed $settlement, mixed $maturity, mixed $frequency, $basis = 0): string | float
     {
         return Coupons::COUPPCD($settlement, $maturity, $frequency, $basis);
     }
@@ -572,7 +572,7 @@ 
      * @param array|float $fractional_dollar Fractional Dollar
      * @param array|int $fraction Fraction
      */
-    public static function DOLLARDE($fractional_dollar = null, $fraction = 0): string|float|array
+    public static function DOLLARDE($fractional_dollar = null, $fraction = 0): string | float | array
     {
         return Dollar::decimal($fractional_dollar, $fraction);
     }
@@ -594,7 +594,7 @@ 
      * @param array|float $decimal_dollar Decimal Dollar
      * @param array|int $fraction Fraction
      */
-    public static function DOLLARFR($decimal_dollar = null, $fraction = 0): string|float|array
+    public static function DOLLARFR($decimal_dollar = null, $fraction = 0): string | float | array
     {
         return Dollar::fractional($decimal_dollar, $fraction);
     }
@@ -615,7 +615,7 @@ 
      * @param float $nominalRate Nominal interest rate
      * @param int $periodsPerYear Number of compounding payments per year
      */
-    public static function EFFECT($nominalRate = 0, $periodsPerYear = 0): string|float
+    public static function EFFECT($nominalRate = 0, $periodsPerYear = 0): string | float
     {
         return Financial\InterestRate::effective($nominalRate, $periodsPerYear);
     }
@@ -643,7 +643,7 @@ 
      *                                0 or omitted    At the end of the period.
      *                                1                At the beginning of the period.
      */
-    public static function FV($rate = 0, $nper = 0, $pmt = 0, $pv = 0, $type = 0): string|float
+    public static function FV($rate = 0, $nper = 0, $pmt = 0, $pv = 0, $type = 0): string | float
     {
         return Financial\CashFlow\Constant\Periodic::futureValue($rate, $nper, $pmt, $pv, $type);
     }
@@ -724,7 +724,7 @@ 
      * @param float $fv Future Value
      * @param int $type Payment type: 0 = at the end of each period, 1 = at the beginning of each period
      */
-    public static function IPMT($rate, $per, $nper, $pv, $fv = 0, $type = 0): string|float
+    public static function IPMT($rate, $per, $nper, $pv, $fv = 0, $type = 0): string | float
     {
         return Financial\CashFlow\Constant\Periodic\Interest::payment($rate, $per, $nper, $pv, $fv, $type);
     }
@@ -830,7 +830,7 @@ 
      *
      * @return float|string Result, or a string containing an error
      */
-    public static function NOMINAL($effectiveRate = 0, $periodsPerYear = 0): string|float
+    public static function NOMINAL($effectiveRate = 0, $periodsPerYear = 0): string | float
     {
         return InterestRate::nominal($effectiveRate, $periodsPerYear);
     }
@@ -936,7 +936,7 @@ 
      *
      * @return float|string Result, or a string containing an error
      */
-    public static function PPMT($rate, $per, $nper, $pv, $fv = 0, $type = 0): string|float
+    public static function PPMT($rate, $per, $nper, $pv, $fv = 0, $type = 0): string | float
     {
         return Financial\CashFlow\Constant\Periodic\Payments::interestPayment($rate, $per, $nper, $pv, $fv, $type);
     }
@@ -971,7 +971,7 @@ 
      *
      * @return float|string Result, or a string containing an error
      */
-    public static function PRICE(mixed $settlement, mixed $maturity, $rate, $yield, $redemption, $frequency, $basis = 0): string|float
+    public static function PRICE(mixed $settlement, mixed $maturity, $rate, $yield, $redemption, $frequency, $basis = 0): string | float
     {
         return Securities\Price::price($settlement, $maturity, $rate, $yield, $redemption, $frequency, $basis);
     }
@@ -1054,7 +1054,7 @@ 
      *
      * @return float|string Result, or a string containing an error
      */
-    public static function PV($rate = 0, $nper = 0, $pmt = 0, $fv = 0, $type = 0): string|float
+    public static function PV($rate = 0, $nper = 0, $pmt = 0, $fv = 0, $type = 0): string | float
     {
         return Financial\CashFlow\Constant\Periodic::presentValue($rate, $nper, $pmt, $fv, $type);
     }
@@ -1206,7 +1206,7 @@ 
      *
      * @return float|string Result, or a string containing an error
      */
-    public static function TBILLEQ(mixed $settlement, mixed $maturity, mixed $discount): string|float
+    public static function TBILLEQ(mixed $settlement, mixed $maturity, mixed $discount): string | float
     {
         return TreasuryBill::bondEquivalentYield($settlement, $maturity, $discount);
     }
@@ -1229,7 +1229,7 @@ 
      *
      * @return float|string Result, or a string containing an error
      */
-    public static function TBILLPRICE(mixed $settlement, mixed $maturity, mixed $discount): string|float
+    public static function TBILLPRICE(mixed $settlement, mixed $maturity, mixed $discount): string | float
     {
         return TreasuryBill::price($settlement, $maturity, $discount);
     }
@@ -1250,7 +1250,7 @@ 
      *                                The maturity date is the date when the Treasury bill expires.
      * @param mixed $price The Treasury bill's price per $100 face value
      */
-    public static function TBILLYIELD(mixed $settlement, mixed $maturity, mixed $price): string|float
+    public static function TBILLYIELD(mixed $settlement, mixed $maturity, mixed $price): string | float
     {
         return TreasuryBill::yield($settlement, $maturity, $price);
     }

src/PhpSpreadsheet/Calculation/Statistical.php

Spacing +7 added lines, -7 removed lines

@@ -123,7 +123,7 @@ 
      * @param float $alpha Parameter to the distribution
      * @param float $beta Parameter to the distribution
      */
-    public static function BETADIST($value, $alpha, $beta, mixed $rMin = 0, mixed $rMax = 1): string|float|array
+    public static function BETADIST($value, $alpha, $beta, mixed $rMin = 0, mixed $rMax = 1): string | float | array
     {
         return Statistical\Distributions\Beta::distribution($value, $alpha, $beta, $rMin, $rMax);
     }
@@ -534,7 +534,7 @@ 
      *
      * @return array|float|string The result, or a string containing an error
      */
-    public static function GAMMAFunction($value): string|float|array
+    public static function GAMMAFunction($value): string | float | array
     {
         return Statistical\Distributions\Gamma::gamma($value);
     }
@@ -591,7 +591,7 @@ 
      *
      * @param float $value
      */
-    public static function GAMMALN($value): string|float|array
+    public static function GAMMALN($value): string | float | array
     {
         return Statistical\Distributions\Gamma::ln($value);
     }
@@ -787,7 +787,7 @@ 
      *
      * @return array|string The result, or a string containing an error
      */
-    public static function LINEST(array $yValues, $xValues = null, $const = true, $stats = false): string|array
+    public static function LINEST(array $yValues, $xValues = null, $const = true, $stats = false): string | array
     {
         return Trends::LINEST($yValues, $xValues, $const, $stats);
     }
@@ -809,7 +809,7 @@ 
      *
      * @return array|string The result, or a string containing an error
      */
-    public static function LOGEST(array $yValues, $xValues = null, $const = true, $stats = false): string|array
+    public static function LOGEST(array $yValues, $xValues = null, $const = true, $stats = false): string | array
     {
         return Trends::LOGEST($yValues, $xValues, $const, $stats);
     }
@@ -833,7 +833,7 @@ 
      *            accuracy if I can get my head round the mathematics
      *            (as described at) http://home.online.no/~pjacklam/notes/invnorm/
      */
-    public static function LOGINV($probability, $mean, $stdDev): string|float|array
+    public static function LOGINV($probability, $mean, $stdDev): string | float | array
     {
         return Statistical\Distributions\LogNormal::inverse($probability, $mean, $stdDev);
     }
@@ -1206,7 +1206,7 @@ 
      *
      * @return float|string (string if result is an error)
      */
-    public static function PERCENTRANK(mixed $valueSet, mixed $value, mixed $significance = 3): string|float
+    public static function PERCENTRANK(mixed $valueSet, mixed $value, mixed $significance = 3): string | float
     {
         return Statistical\Percentiles::PERCENTRANK($valueSet, $value, $significance);
     }