PHPOffice / PhpSpreadsheet

src/PhpSpreadsheet/Calculation/Financial/CashFlow/Single.php

Spacing +3 added lines, -3 removed lines

@@ -20,7 +20,7 @@ 
      * @param mixed $principal the present value
      * @param float[] $schedule an array of interest rates to apply
      */
-    public static function futureValue(mixed $principal, array $schedule): string|float
+    public static function futureValue(mixed $principal, array $schedule): string | float
     {
         $principal = Functions::flattenSingleValue($principal);
         $schedule = Functions::flattenArray($schedule);
@@ -50,7 +50,7 @@ 
      *
      * @return float|string Result, or a string containing an error
      */
-    public static function periods(mixed $rate, mixed $presentValue, mixed $futureValue): string|float
+    public static function periods(mixed $rate, mixed $presentValue, mixed $futureValue): string | float
     {
         $rate = Functions::flattenSingleValue($rate);
         $presentValue = Functions::flattenSingleValue($presentValue);
@@ -83,7 +83,7 @@ 
      *
      * @return float|string Result, or a string containing an error
      */
-    public static function interestRate(array|float $periods = 0.0, array|float $presentValue = 0.0, array|float $futureValue = 0.0): string|float
+    public static function interestRate(array | float $periods = 0.0, array | float $presentValue = 0.0, array | float $futureValue = 0.0): string | float
     {
         $periods = Functions::flattenSingleValue($periods);
         $presentValue = Functions::flattenSingleValue($presentValue);

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

Spacing +5 added lines, -5 removed lines

@@ -30,7 +30,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(array $values, array $dates, mixed $guess = self::DEFAULT_GUESS): float|string
+    public static function rate(array $values, array $dates, mixed $guess = self::DEFAULT_GUESS): float | string
     {
         $rslt = self::xirrPart1($values, $dates);
         if ($rslt !== '') {
@@ -117,7 +117,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(array|float $rate, array $values, array $dates): float|string
+    public static function presentValue(array | float $rate, array $values, array $dates): float | string
     {
         return self::xnpvOrdered($rate, $values, $dates, true);
     }
@@ -174,7 +174,7 @@ 
         return '';
     }
 
-    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) {
@@ -203,7 +203,7 @@ 
         return $rslt;
     }
 
-    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) {
@@ -239,7 +239,7 @@ 
         return $rslt;
     }
 
-    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);
         $values = Functions::flattenArray($values);

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();
@@ -97,7 +97,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();
@@ -136,7 +136,7 @@ 
      *
      * @param array $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/Depreciation.php

Spacing +4 added lines, -4 removed lines

@@ -33,7 +33,7 @@ 
      * @param mixed $month Number of months in the first year. If month is omitted,
      *                         it defaults to 12.
      */
-    public static function DB(mixed $cost, mixed $salvage, mixed $life, mixed $period, mixed $month = 12): string|float|int
+    public static function DB(mixed $cost, mixed $salvage, mixed $life, mixed $period, mixed $month = 12): string | float | int
     {
         $cost = Functions::flattenSingleValue($cost);
         $salvage = Functions::flattenSingleValue($salvage);
@@ -97,7 +97,7 @@ 
      *                                If factor is omitted, it is assumed to be 2 (the
      *                                double-declining balance method).
      */
-    public static function DDB(mixed $cost, mixed $salvage, mixed $life, mixed $period, mixed $factor = 2.0): float|string
+    public static function DDB(mixed $cost, mixed $salvage, mixed $life, mixed $period, mixed $factor = 2.0): float | string
     {
         $cost = Functions::flattenSingleValue($cost);
         $salvage = Functions::flattenSingleValue($salvage);
@@ -145,7 +145,7 @@ 
      *
      * @return float|string Result, or a string containing an error
      */
-    public static function SLN(mixed $cost, mixed $salvage, mixed $life): string|float
+    public static function SLN(mixed $cost, mixed $salvage, mixed $life): string | float
     {
         $cost = Functions::flattenSingleValue($cost);
         $salvage = Functions::flattenSingleValue($salvage);
@@ -178,7 +178,7 @@ 
      *
      * @return float|string Result, or a string containing an error
      */
-    public static function SYD(mixed $cost, mixed $salvage, mixed $life, mixed $period): string|float
+    public static function SYD(mixed $cost, mixed $salvage, mixed $life, mixed $period): string | float
     {
         $cost = Functions::flattenSingleValue($cost);
         $salvage = Functions::flattenSingleValue($salvage);

src/PhpSpreadsheet/Calculation/Financial/Securities/Rates.php

Spacing +2 added lines, -2 removed lines

@@ -38,7 +38,7 @@ 
         mixed $price,
         mixed $redemption,
         mixed $basis = FinancialConstants::BASIS_DAYS_PER_YEAR_NASD
-    ): float|string {
+    ): float | string {
         $settlement = Functions::flattenSingleValue($settlement);
         $maturity = Functions::flattenSingleValue($maturity);
         $price = Functions::flattenSingleValue($price);
@@ -99,7 +99,7 @@ 
         mixed $investment,
         mixed $redemption,
         mixed $basis = FinancialConstants::BASIS_DAYS_PER_YEAR_NASD
-    ): float|string {
+    ): float | string {
         $settlement = Functions::flattenSingleValue($settlement);
         $maturity = Functions::flattenSingleValue($maturity);
         $investment = Functions::flattenSingleValue($investment);

src/PhpSpreadsheet/Calculation/TextData/Format.php

Spacing +4 added lines, -4 removed lines

@@ -76,7 +76,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 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);
@@ -116,7 +116,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 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);
@@ -223,7 +223,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 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);
@@ -264,7 +264,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/Trim.php

Spacing +1 added lines, -1 removed lines

@@ -37,7 +37,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 spaces(mixed $stringValue = ''): array|string
+    public static function spaces(mixed $stringValue = ''): array | string
     {
         if (is_array($stringValue)) {
             return self::evaluateSingleArgumentArray([self::class, __FUNCTION__], $stringValue);

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);