PHPOffice / PhpSpreadsheet

src/PhpSpreadsheet/Calculation/LookupRef/ChooseRowsEtc.php

Spacing +7 added lines, -7 removed lines

@@ -34,7 +34,7 @@ 
      *
      * @return mixed[]|string
      */
-    public static function chooseCols(mixed $input, mixed ...$args): array|string
+    public static function chooseCols(mixed $input, mixed ...$args): array | string
     {
         if (!is_array($input)) {
             $input = [[$input]];
@@ -51,7 +51,7 @@ 
      *
      * @return mixed[]|string
      */
-    public static function chooseRows(mixed $input, mixed ...$args): array|string
+    public static function chooseRows(mixed $input, mixed ...$args): array | string
     {
         if (!is_array($input)) {
             $input = [[$input]];
@@ -80,7 +80,7 @@ 
         return $outputArray;
     }
 
-    private static function dropRows(array $array, mixed $offset): array|string
+    private static function dropRows(array $array, mixed $offset): array | string
     {
         if ($offset === null) {
             return $array;
@@ -112,7 +112,7 @@ 
      *
      * @return mixed[]|string
      */
-    public static function drop(mixed $input, mixed $rows = null, mixed $columns = null): array|string
+    public static function drop(mixed $input, mixed $rows = null, mixed $columns = null): array | string
     {
         if (!is_array($input)) {
             $input = [[$input]];
@@ -134,7 +134,7 @@ 
         return self::transpose($outputArray3);
     }
 
-    private static function takeRows(array $array, mixed $offset): array|string
+    private static function takeRows(array $array, mixed $offset): array | string
     {
         if ($offset === null) {
             return $array;
@@ -165,7 +165,7 @@ 
      *
      * @return mixed[]|string
      */
-    public static function take(mixed $input, mixed $rows, mixed $columns = null): array|string
+    public static function take(mixed $input, mixed $rows, mixed $columns = null): array | string
     {
         if (!is_array($input)) {
             $input = [[$input]];
@@ -197,7 +197,7 @@ 
      *
      * @return mixed[]|string
      */
-    public static function expand(mixed $input, mixed $rows, mixed $columns = null, mixed $pad = '#N/A'): array|string
+    public static function expand(mixed $input, mixed $rows, mixed $columns = null, mixed $pad = '#N/A'): array | string
     {
         if (!is_array($input)) {
             $input = [[$input]];

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

tests/PhpSpreadsheetTests/Shared/DateTest.php

Spacing +6 added lines, -6 removed lines

@@ -52,7 +52,7 @@ 
     }
 
     #[\PHPUnit\Framework\Attributes\DataProvider('providerDateTimeExcelToTimestamp1900')]
-    public function testDateTimeExcelToTimestamp1900(float|int $expectedResult, float|int $excelDateTimeValue): void
+    public function testDateTimeExcelToTimestamp1900(float | int $expectedResult, float | int $excelDateTimeValue): void
     {
         if ($expectedResult > PHP_INT_MAX || $expectedResult < PHP_INT_MIN) {
             self::markTestSkipped('Test invalid on 32-bit system.');
@@ -69,7 +69,7 @@ 
     }
 
     #[\PHPUnit\Framework\Attributes\DataProvider('providerDateTimeTimestampToExcel1900')]
-    public function testDateTimeTimestampToExcel1900(float|int $expectedResult, float|int|string $unixTimestamp): void
+    public function testDateTimeTimestampToExcel1900(float | int $expectedResult, float | int | string $unixTimestamp): void
     {
         Date::setExcelCalendar(Date::CALENDAR_WINDOWS_1900);
 
@@ -83,7 +83,7 @@ 
     }
 
     #[\PHPUnit\Framework\Attributes\DataProvider('providerDateTimeDateTimeToExcel')]
-    public function testDateTimeDateTimeToExcel(float|int $expectedResult, DateTimeInterface $dateTimeObject): void
+    public function testDateTimeDateTimeToExcel(float | int $expectedResult, DateTimeInterface $dateTimeObject): void
     {
         Date::setExcelCalendar(Date::CALENDAR_WINDOWS_1900);
 
@@ -114,7 +114,7 @@ 
     }
 
     #[\PHPUnit\Framework\Attributes\DataProvider('providerDateTimeExcelToTimestamp1904')]
-    public function testDateTimeExcelToTimestamp1904(float|int $expectedResult, float|int $excelDateTimeValue): void
+    public function testDateTimeExcelToTimestamp1904(float | int $expectedResult, float | int $excelDateTimeValue): void
     {
         if ($expectedResult > PHP_INT_MAX || $expectedResult < PHP_INT_MIN) {
             self::markTestSkipped('Test invalid on 32-bit system.');
@@ -131,7 +131,7 @@ 
     }
 
     #[\PHPUnit\Framework\Attributes\DataProvider('providerDateTimeTimestampToExcel1904')]
-    public function testDateTimeTimestampToExcel1904(mixed $expectedResult, float|int|string $unixTimestamp): void
+    public function testDateTimeTimestampToExcel1904(mixed $expectedResult, float | int | string $unixTimestamp): void
     {
         Date::setExcelCalendar(Date::CALENDAR_MAC_1904);
 
@@ -157,7 +157,7 @@ 
     }
 
     #[\PHPUnit\Framework\Attributes\DataProvider('providerDateTimeExcelToTimestamp1900Timezone')]
-    public function testDateTimeExcelToTimestamp1900Timezone(float|int $expectedResult, float|int $excelDateTimeValue, string $timezone): void
+    public function testDateTimeExcelToTimestamp1900Timezone(float | int $expectedResult, float | int $excelDateTimeValue, string $timezone): void
     {
         if ($expectedResult > PHP_INT_MAX || $expectedResult < PHP_INT_MIN) {
             self::markTestSkipped('Test invalid on 32-bit system.');