PHPOffice / PhpSpreadsheet

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

src/PhpSpreadsheet/Calculation/Engine/FormattedNumber.php

Spacing +3 added lines, -3 removed lines

@@ -46,7 +46,7 @@ 
      *
      * @param float|string $operand string value to test
      */
-    public static function convertToNumberIfNumeric(float|string &$operand): bool
+    public static function convertToNumberIfNumeric(float | string &$operand): bool
     {
         $thousandsSeparator = preg_quote(StringHelper::getThousandsSeparator(), '/');
         $value = preg_replace(['/(\d)' . $thousandsSeparator . '(\d)/u', '/([+-])\s+(\d)/u'], ['$1$2', '$1$2'], trim("$operand"));
@@ -88,7 +88,7 @@ 
      *
      * @param float|string $operand string value to test
      */
-    public static function convertToNumberIfPercent(float|string &$operand): bool
+    public static function convertToNumberIfPercent(float | string &$operand): bool
     {
         $thousandsSeparator = preg_quote(StringHelper::getThousandsSeparator(), '/');
         $value = preg_replace('/(\d)' . $thousandsSeparator . '(\d)/u', '$1$2', trim("$operand"));
@@ -113,7 +113,7 @@ 
      *
      * @param float|string $operand string value to test
      */
-    public static function convertToNumberIfCurrency(float|string &$operand): bool
+    public static function convertToNumberIfCurrency(float | string &$operand): bool
     {
         $currencyRegexp = self::currencyMatcherRegexp();
         $thousandsSeparator = preg_quote(StringHelper::getThousandsSeparator(), '/');