PHPOffice / PhpSpreadsheet

src/PhpSpreadsheet/Style/NumberFormat/Formatter.php

Spacing +1 added lines, -1 removed lines

@@ -116,7 +116,7 @@
      *
      * @return string Formatted string
      */
-    public static function toFormattedString($value, string $format, null|array|callable $callBack = null): string
+    public static function toFormattedString($value, string $format, null | array | callable $callBack = null): string
     {
         while (is_array($value)) {
             $value = array_shift($value);

src/PhpSpreadsheet/Calculation/MathTrig/Random.php

Spacing +4 added lines, -4 removed lines

@@ -15,7 +15,7 @@ 
      *
      * @return float|int Random number
      */
-    public static function rand(): int|float
+    public static function rand(): int | float
     {
         return mt_rand(0, 10000000) / 10000000;
     }
@@ -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 randBetween(mixed $min, mixed $max): array|string|int
+    public static function randBetween(mixed $min, mixed $max): array | string | int
     {
         if (is_array($min) || is_array($max)) {
             return self::evaluateArrayArguments([self::class, __FUNCTION__], $min, $max);
@@ -67,7 +67,7 @@ 
      *
      * @return array|string The resulting array, or a string containing an error
      */
-    public static function randArray(mixed $rows = 1, mixed $columns = 1, mixed $min = 0, mixed $max = 1, bool $wholeNumber = false): string|array
+    public static function randArray(mixed $rows = 1, mixed $columns = 1, mixed $min = 0, mixed $max = 1, bool $wholeNumber = false): string | array
     {
         try {
             $rows = (int) Helpers::validateNumericNullSubstitution($rows, 1);
@@ -86,7 +86,7 @@ 
 
         return array_chunk(
             array_map(
-                fn (): int|float => $wholeNumber
+                fn (): int | float => $wholeNumber
                         ? mt_rand((int) $min, (int) $max)
                         : (mt_rand() / mt_getrandmax()) * ($max - $min) + $min,
                 array_fill(0, $rows * $columns, $min)

src/PhpSpreadsheet/Cell/DataValidator.php

Spacing +1 added lines, -1 removed lines

@@ -74,7 +74,7 @@
         return $formula;
     }
 
-    private function numericOperator(DataValidation $dataValidation, int|float $cellValue, Cell $cell): bool
+    private function numericOperator(DataValidation $dataValidation, int | float $cellValue, Cell $cell): bool
     {
         $operator = $dataValidation->getOperator();
         $formula1 = self::evaluateNumericFormula(

tests/PhpSpreadsheetTests/Document/PropertiesTest.php

Spacing +3 added lines, -3 removed lines

@@ -46,7 +46,7 @@ 
     }
 
     #[DataProvider('providerCreationTime')]
-    public function testSetCreated(null|int $expectedCreationTime, null|int|string $created): void
+    public function testSetCreated(null | int $expectedCreationTime, null | int | string $created): void
     {
         if ($expectedCreationTime === null) {
             do {
@@ -80,7 +80,7 @@ 
     }
 
     #[DataProvider('providerModifiedTime')]
-    public function testSetModified(mixed $expectedModifiedTime, null|int|string $modified): void
+    public function testSetModified(mixed $expectedModifiedTime, null | int | string $modified): void
     {
         if ($expectedModifiedTime === null) {
             do {
@@ -162,7 +162,7 @@ 
     }
 
     #[DataProvider('providerCustomProperties')]
-    public function testSetCustomProperties(mixed $expectedType, mixed $expectedValue, string $propertyName, null|bool|float|int|string $propertyValue, ?string $propertyType = null): void
+    public function testSetCustomProperties(mixed $expectedType, mixed $expectedValue, string $propertyName, null | bool | float | int | string $propertyValue, ?string $propertyType = null): void
     {
         if ($propertyType === null) {
             $this->properties->setCustomProperty($propertyName, $propertyValue);

tests/PhpSpreadsheetTests/Calculation/Functions/LookupRef/IndirectTest.php

Spacing +1 added lines, -1 removed lines

@@ -132,7 +132,7 @@
     }
 
     #[DataProvider('providerRelative')]
-    public function testR1C1Relative(string|int|null $expectedResult, string $address): void
+    public function testR1C1Relative(string | int | null $expectedResult, string $address): void
     {
         $this->setArrayAsValue();
         $sheet = $this->getSheet();

tests/PhpSpreadsheetTests/Calculation/Functions/LookupRef/IndexOnSpreadsheetTest.php

Spacing +1 added lines, -1 removed lines

@@ -9,7 +9,7 @@
 class IndexOnSpreadsheetTest extends AllSetupTeardown
 {
     #[DataProvider('providerINDEXonSpreadsheet')]
-    public function testIndexOnSpreadsheet(mixed $expectedResult, array $matrix, null|int|string $rowNum = null, null|int|string $colNum = null): void
+    public function testIndexOnSpreadsheet(mixed $expectedResult, array $matrix, null | int | string $rowNum = null, null | int | string $colNum = null): void
     {
         $this->mightHaveException($expectedResult);
         $this->setArrayAsValue();

tests/PhpSpreadsheetTests/Calculation/Functions/Logical/AndTest.php

Spacing +1 added lines, -1 removed lines

@@ -21,7 +21,7 @@
     }
 
     #[DataProvider('providerANDLiteral')]
-    public function testANDLiteral(bool|string $expectedResult, float|int|string $formula): void
+    public function testANDLiteral(bool | string $expectedResult, float | int | string $formula): void
     {
         $sheet = $this->getSheet();
         $sheet->getCell('A1')->setValue("=AND($formula)");

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(mixed $values, mixed $dates, mixed $guess = self::DEFAULT_GUESS): float|string
+    public static function rate(mixed $values, mixed $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(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);
     }
@@ -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) {
@@ -240,7 +240,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);
         $values = Functions::flattenArray($values);

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(mixed $periods = 0.0, mixed $presentValue = 0.0, mixed $futureValue = 0.0): string|float
+    public static function interestRate(mixed $periods = 0.0, mixed $presentValue = 0.0, mixed $futureValue = 0.0): string | float
     {
         $periods = Functions::flattenSingleValue($periods);
         $presentValue = Functions::flattenSingleValue($presentValue);