PHPOffice / PhpSpreadsheet

src/PhpSpreadsheet/Calculation/Statistical/Conditional.php

Spacing +8 added lines, -8 removed lines

@@ -29,7 +29,7 @@ 
      * @param null|array|string $condition the criteria that defines which cells will be checked
      * @param mixed $averageRange Data values
      */
-    public static function AVERAGEIF(mixed $range, null|array|string $condition, mixed $averageRange = []): null|int|float|string
+    public static function AVERAGEIF(mixed $range, null | array | string $condition, mixed $averageRange = []): null | int | float | string
     {
         if (!is_array($range) || !is_array($averageRange) || array_key_exists(0, $range) || array_key_exists(0, $averageRange)) {
             $refError = ExcelError::REF();
@@ -55,7 +55,7 @@ 
      *
      * @param mixed $args Pairs of Ranges and Criteria
      */
-    public static function AVERAGEIFS(mixed ...$args): null|int|float|string
+    public static function AVERAGEIFS(mixed ...$args): null | int | float | string
     {
         if (empty($args)) {
             return 0.0;
@@ -85,7 +85,7 @@ 
      * @param mixed $range Data values, expect array
      * @param null|array|string $condition the criteria that defines which cells will be counted
      */
-    public static function COUNTIF(mixed $range, null|array|string $condition): string|int
+    public static function COUNTIF(mixed $range, null | array | string $condition): string | int
     {
         if (
             !is_array($range)
@@ -119,7 +119,7 @@ 
      *
      * @param mixed $args Pairs of Ranges and Criteria
      */
-    public static function COUNTIFS(mixed ...$args): int|string
+    public static function COUNTIFS(mixed ...$args): int | string
     {
         if (empty($args)) {
             return 0;
@@ -143,7 +143,7 @@ 
      *
      * @param mixed $args Pairs of Ranges and Criteria
      */
-    public static function MAXIFS(mixed ...$args): null|float|string
+    public static function MAXIFS(mixed ...$args): null | float | string
     {
         if (empty($args)) {
             return 0.0;
@@ -165,7 +165,7 @@ 
      *
      * @param mixed $args Pairs of Ranges and Criteria
      */
-    public static function MINIFS(mixed ...$args): null|float|string
+    public static function MINIFS(mixed ...$args): null | float | string
     {
         if (empty($args)) {
             return 0.0;
@@ -188,7 +188,7 @@ 
      * @param mixed $range Data values, expecting array
      * @param mixed $sumRange Data values, expecting array
      */
-    public static function SUMIF(mixed $range, mixed $condition, mixed $sumRange = []): null|float|string
+    public static function SUMIF(mixed $range, mixed $condition, mixed $sumRange = []): null | float | string
     {
         if (
             !is_array($range)
@@ -219,7 +219,7 @@ 
      *
      * @param mixed $args Pairs of Ranges and Criteria
      */
-    public static function SUMIFS(mixed ...$args): null|float|string
+    public static function SUMIFS(mixed ...$args): null | float | string
     {
         if (empty($args)) {
             return 0.0;

tests/PhpSpreadsheetTests/Calculation/Functions/Engineering/Oct2DecTest.php

Spacing +2 added lines, -2 removed lines

@@ -29,7 +29,7 @@ 
     }
 
     #[DataProvider('providerOCT2DEC')]
-    public function testDirectCallToOCT2DEC(mixed $expectedResult, bool|string $value): void
+    public function testDirectCallToOCT2DEC(mixed $expectedResult, bool | string $value): void
     {
         $result = ConvertOctal::toDecimal($value);
         self::assertSame($expectedResult, $result);
@@ -98,7 +98,7 @@ 
     }
 
     #[DataProvider('providerOCT2DECOds')]
-    public function testOCT2DECOds(mixed $expectedResult, bool|string $value): void
+    public function testOCT2DECOds(mixed $expectedResult, bool | string $value): void
     {
         Functions::setCompatibilityMode(
             Functions::COMPATIBILITY_OPENOFFICE

tests/PhpSpreadsheetTests/Calculation/Functions/Engineering/Bin2DecTest.php

Spacing +2 added lines, -2 removed lines

@@ -29,7 +29,7 @@ 
     }
 
     #[DataProvider('providerBIN2DEC')]
-    public function testDirectCallToBIN2DEC(float|int|string $expectedResult, bool|int|string $arg1): void
+    public function testDirectCallToBIN2DEC(float | int | string $expectedResult, bool | int | string $arg1): void
     {
         $result = ConvertBinary::toDecimal($arg1);
         self::assertSame($expectedResult, $result);
@@ -98,7 +98,7 @@ 
     }
 
     #[DataProvider('providerBIN2DECOds')]
-    public function testBIN2DECOds(float|int|string $expectedResult, bool $arg1): void
+    public function testBIN2DECOds(float | int | string $expectedResult, bool $arg1): void
     {
         Functions::setCompatibilityMode(
             Functions::COMPATIBILITY_OPENOFFICE

tests/PhpSpreadsheetTests/Calculation/Functions/Engineering/Hex2DecTest.php

Spacing +2 added lines, -2 removed lines

@@ -29,7 +29,7 @@ 
     }
 
     #[DataProvider('providerHEX2DEC')]
-    public function testDirectCallToHEX2DEC(mixed $expectedResult, bool|float|int|string $value): void
+    public function testDirectCallToHEX2DEC(mixed $expectedResult, bool | float | int | string $value): void
     {
         $result = ConvertHex::toDecimal($value);
         self::assertSame($expectedResult, $result);
@@ -98,7 +98,7 @@ 
     }
 
     #[DataProvider('providerHEX2DECOds')]
-    public function testHEX2DECOds(mixed $expectedResult, bool|float|int|string $value): void
+    public function testHEX2DECOds(mixed $expectedResult, bool | float | int | string $value): void
     {
         Functions::setCompatibilityMode(
             Functions::COMPATIBILITY_OPENOFFICE

tests/PhpSpreadsheetTests/Calculation/CustomFunction.php

Spacing +1 added lines, -1 removed lines

@@ -9,7 +9,7 @@
 
 class CustomFunction
 {
-    public static function fourthPower(mixed $number): float|int|string
+    public static function fourthPower(mixed $number): float | int | string
     {
         try {
             $number = Helpers::validateNumericNullBool($number);

tests/PhpSpreadsheetTests/Reader/Xlsx/MySpreadsheet.php

Spacing +1 added lines, -1 removed lines

@@ -8,7 +8,7 @@
 
 class MySpreadsheet extends Spreadsheet
 {
-    public function calcSquare(string $cellAddress): float|int|string
+    public function calcSquare(string $cellAddress): float | int | string
     {
         $value = $this->getActiveSheet()
             ->getCell($cellAddress)

src/PhpSpreadsheet/Calculation/Financial/Helpers.php

Spacing +1 added lines, -1 removed lines

@@ -24,7 +24,7 @@
      *
      * @return int|string Result, or a string containing an error
      */
-    public static function daysPerYear(mixed $year, $basis = 0): string|int
+    public static function daysPerYear(mixed $year, $basis = 0): string | int
     {
         if (!is_int($year) && !is_string($year)) {
             return ExcelError::VALUE();

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 $dates */
@@ -119,7 +119,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);
     }
@@ -178,7 +178,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) {
@@ -207,7 +207,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) {
@@ -244,7 +244,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/DateTimeExcel/Helpers.php

Spacing +8 added lines, -8 removed lines

@@ -17,7 +17,7 @@ 
      *
      * @return bool TRUE if the year is a leap year, otherwise FALSE
      */
-    public static function isLeapYear(int|string $year): bool
+    public static function isLeapYear(int | string $year): bool
     {
         $year = (int) $year;
 
@@ -64,7 +64,7 @@ 
      *
      * @return float|string Excel date/time serial value, or string if error
      */
-    public static function getTimeValue(string $timeValue): string|float
+    public static function getTimeValue(string $timeValue): string | float
     {
         $saveReturnDateType = Functions::getReturnDateType();
         Functions::setReturnDateType(Functions::RETURNDATE_EXCEL);
@@ -132,7 +132,7 @@ 
     /**
      * Return result in one of three formats.
      */
-    public static function returnIn3FormatsArray(array $dateArray, bool $noFrac = false): DateTime|float|int
+    public static function returnIn3FormatsArray(array $dateArray, bool $noFrac = false): DateTime | float | int
     {
         $retType = Functions::getReturnDateType();
         if ($retType === Functions::RETURNDATE_PHP_DATETIME_OBJECT) {
@@ -165,7 +165,7 @@ 
     /**
      * Return result in one of three formats.
      */
-    public static function returnIn3FormatsFloat(float $excelDateValue): float|int|DateTime
+    public static function returnIn3FormatsFloat(float $excelDateValue): float | int | DateTime
     {
         $retType = Functions::getReturnDateType();
         if ($retType === Functions::RETURNDATE_EXCEL) {
@@ -182,7 +182,7 @@ 
     /**
      * Return result in one of three formats.
      */
-    public static function returnIn3FormatsObject(DateTime $PHPDateObject): DateTime|float|int
+    public static function returnIn3FormatsObject(DateTime $PHPDateObject): DateTime | float | int
     {
         $retType = Functions::getReturnDateType();
         if ($retType === Functions::RETURNDATE_PHP_DATETIME_OBJECT) {
@@ -227,7 +227,7 @@ 
     /**
      * Many functions accept null argument treated as 0.
      */
-    public static function validateNumericNull(mixed $number): int|float
+    public static function validateNumericNull(mixed $number): int | float
     {
         $number = Functions::flattenSingleValue($number);
         if ($number === null) {
@@ -284,12 +284,12 @@ 
      *
      * @param array|false $dateArray
      */
-    private static function forceArray(array|bool $dateArray): array
+    private static function forceArray(array | bool $dateArray): array
     {
         return is_array($dateArray) ? $dateArray : ['error_count' => 1];
     }
 
-    public static function floatOrInt(mixed $value): float|int
+    public static function floatOrInt(mixed $value): float | int
     {
         $result = Functions::scalar($value);