PHPOffice / PhpSpreadsheet

tests/PhpSpreadsheetTests/Shared/DateTest.php

Spacing +6 added lines, -6 removed lines

@@ -52,7 +52,7 @@ 
     /**
      * @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.');
@@ -71,7 +71,7 @@ 
     /**
      * @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);
 
@@ -87,7 +87,7 @@ 
     /**
      * @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);
 
@@ -121,7 +121,7 @@ 
     /**
      * @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.');
@@ -140,7 +140,7 @@ 
     /**
      * @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);
 
@@ -170,7 +170,7 @@ 
     /**
      * @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 (is_numeric($expectedResult) && ($expectedResult > PHP_INT_MAX || $expectedResult < PHP_INT_MIN)) {
             self::markTestSkipped('Test invalid on 32-bit system.');

src/PhpSpreadsheet/Calculation/Engineering/BitWise.php

Spacing +6 added lines, -6 removed lines

@@ -17,7 +17,7 @@ 
      *
      * @return int[]
      */
-    private static function splitNumber(float|int $number): array
+    private static function splitNumber(float | int $number): array
     {
         return [(int) floor($number / self::SPLIT_DIVISOR), (int) fmod($number, self::SPLIT_DIVISOR)];
     }
@@ -36,7 +36,7 @@ 
      * @return array|int|string 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 BITAND(null|array|bool|float|int|string $number1, null|array|bool|float|int|string $number2): array|string|int|float
+    public static function BITAND(null | array | bool | float | int | string $number1, null | array | bool | float | int | string $number2): array | string | int | float
     {
         if (is_array($number1) || is_array($number2)) {
             return self::evaluateArrayArguments([self::class, __FUNCTION__], $number1, $number2);
@@ -68,7 +68,7 @@ 
      * @return array|int|string 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 BITOR(null|array|bool|float|int|string $number1, null|array|bool|float|int|string $number2): array|string|int|float
+    public static function BITOR(null | array | bool | float | int | string $number1, null | array | bool | float | int | string $number2): array | string | int | float
     {
         if (is_array($number1) || is_array($number2)) {
             return self::evaluateArrayArguments([self::class, __FUNCTION__], $number1, $number2);
@@ -101,7 +101,7 @@ 
      * @return array|int|string 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 BITXOR(null|array|bool|float|int|string $number1, null|array|bool|float|int|string $number2): array|string|int|float
+    public static function BITXOR(null | array | bool | float | int | string $number1, null | array | bool | float | int | string $number2): array | string | int | float
     {
         if (is_array($number1) || is_array($number2)) {
             return self::evaluateArrayArguments([self::class, __FUNCTION__], $number1, $number2);
@@ -134,7 +134,7 @@ 
      * @return array|float|string 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 BITLSHIFT(null|array|bool|float|int|string $number, null|array|bool|float|int|string $shiftAmount): array|string|float
+    public static function BITLSHIFT(null | array | bool | float | int | string $number, null | array | bool | float | int | string $shiftAmount): array | string | float
     {
         if (is_array($number) || is_array($shiftAmount)) {
             return self::evaluateArrayArguments([self::class, __FUNCTION__], $number, $shiftAmount);
@@ -169,7 +169,7 @@ 
      * @return array|float|string 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 BITRSHIFT(null|array|bool|float|int|string $number, null|array|bool|float|int|string $shiftAmount): array|string|float
+    public static function BITRSHIFT(null | array | bool | float | int | string $number, null | array | bool | float | int | string $shiftAmount): array | string | float
     {
         if (is_array($number) || is_array($shiftAmount)) {
             return self::evaluateArrayArguments([self::class, __FUNCTION__], $number, $shiftAmount);

src/PhpSpreadsheet/Calculation/DateTimeExcel/Helpers.php

Spacing +7 added lines, -7 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
     {
         return (($year % 4) === 0) && (($year % 100) !== 0) || (($year % 400) === 0);
     }
@@ -60,7 +60,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);
@@ -126,7 +126,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) {
@@ -159,7 +159,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) {
@@ -176,7 +176,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) {
@@ -221,7 +221,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) {
@@ -278,7 +278,7 @@ 
      *
      * @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];
     }

src/PhpSpreadsheet/Calculation/DateTimeExcel/Current.php

Spacing +2 added lines, -2 removed lines

@@ -25,7 +25,7 @@ 
      * @return DateTime|float|int|string Excel date/time serial value, PHP date/time serial value or PHP date/time object,
      *                        depending on the value of the ReturnDateType flag
      */
-    public static function today(): DateTime|float|int|string
+    public static function today(): DateTime | float | int | string
     {
         $dti = new DateTimeImmutable();
         $dateArray = Helpers::dateParse($dti->format('c'));
@@ -50,7 +50,7 @@ 
      * @return DateTime|float|int|string Excel date/time serial value, PHP date/time serial value or PHP date/time object,
      *                        depending on the value of the ReturnDateType flag
      */
-    public static function now(): DateTime|float|int|string
+    public static function now(): DateTime | float | int | string
     {
         $dti = new DateTimeImmutable();
         $dateArray = Helpers::dateParse($dti->format('c'));

src/PhpSpreadsheet/Calculation/DateTimeExcel/Month.php

Spacing +2 added lines, -2 removed lines

@@ -34,7 +34,7 @@ 
      *         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 adjust(mixed $dateValue, array|string|bool|float|int $adjustmentMonths): DateTime|float|int|string|array
+    public static function adjust(mixed $dateValue, array | string | bool | float | int $adjustmentMonths): DateTime | float | int | string | array
     {
         if (is_array($dateValue) || is_array($adjustmentMonths)) {
             return self::evaluateArrayArguments([self::class, __FUNCTION__], $dateValue, $adjustmentMonths);
@@ -78,7 +78,7 @@ 
      *         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 lastDay(mixed $dateValue, array|float|int|bool|string $adjustmentMonths): array|string|DateTime|float|int
+    public static function lastDay(mixed $dateValue, array | float | int | bool | string $adjustmentMonths): array | string | DateTime | float | int
     {
         if (is_array($dateValue) || is_array($adjustmentMonths)) {
             return self::evaluateArrayArguments([self::class, __FUNCTION__], $dateValue, $adjustmentMonths);

src/PhpSpreadsheet/Calculation/DateTimeExcel/DateValue.php

Spacing +2 added lines, -2 removed lines

@@ -40,7 +40,7 @@ 
      *         If an array of numbers is passed as the argument, then the returned result will also be an array
      *            with the same dimensions
      */
-    public static function fromString(null|array|string|int|bool|float $dateValue): array|string|float|int|DateTime
+    public static function fromString(null | array | string | int | bool | float $dateValue): array | string | float | int | DateTime
     {
         if (is_array($dateValue)) {
             return self::evaluateSingleArgumentArray([self::class, __FUNCTION__], $dateValue);
@@ -135,7 +135,7 @@ 
      * @return DateTime|float|int|string Excel date/time serial value, PHP date/time serial value or PHP date/time object,
      *                        depending on the value of the ReturnDateType flag
      */
-    private static function finalResults(array $PHPDateArray, DateTimeImmutable $dti, int $baseYear): string|float|int|DateTime
+    private static function finalResults(array $PHPDateArray, DateTimeImmutable $dti, int $baseYear): string | float | int | DateTime
     {
         $retValue = ExcelError::Value();
         if (Helpers::dateParseSucceeded($PHPDateArray)) {

src/PhpSpreadsheet/Calculation/DateTimeExcel/WorkDay.php

Spacing +3 added lines, -3 removed lines

@@ -36,7 +36,7 @@ 
      *         If an array of values is passed for the $startDate or $endDays,arguments, then the returned result
      *            will also be an array with matching dimensions
      */
-    public static function date(mixed $startDate, array|int|string $endDays, mixed ...$dateArgs): array|float|int|DateTime|string
+    public static function date(mixed $startDate, array | int | string $endDays, mixed ...$dateArgs): array | float | int | DateTime | string
     {
         if (is_array($startDate) || is_array($endDays)) {
             return self::evaluateArrayArgumentsSubset(
@@ -73,7 +73,7 @@ 
     /**
      * Use incrementing logic to determine Workday.
      */
-    private static function incrementing(float $startDate, int $endDays, array $holidayArray): float|int|DateTime
+    private static function incrementing(float $startDate, int $endDays, array $holidayArray): float | int | DateTime
     {
         //    Adjust the start date if it falls over a weekend
         $startDoW = self::getWeekDay($startDate, 3);
@@ -132,7 +132,7 @@ 
     /**
      * Use decrementing logic to determine Workday.
      */
-    private static function decrementing(float $startDate, int $endDays, array $holidayArray): float|int|DateTime
+    private static function decrementing(float $startDate, int $endDays, array $holidayArray): float | int | DateTime
     {
         //    Adjust the start date if it falls over a weekend
         $startDoW = self::getWeekDay($startDate, 3);

src/PhpSpreadsheet/Calculation/DateTimeExcel/Date.php

Spacing +1 added lines, -1 removed lines

@@ -64,7 +64,7 @@
      *         If an array of numbers is passed as the argument, then the returned result will also be an array
      *            with the same dimensions
      */
-    public static function fromYMD(array|float|int|string $year, array|float|int|string $month, array|float|int|string $day): float|int|DateTime|string|array
+    public static function fromYMD(array | float | int | string $year, array | float | int | string $month, array | float | int | string $day): float | int | DateTime | string | array
     {
         if (is_array($year) || is_array($month) || is_array($day)) {
             return self::evaluateArrayArguments([self::class, __FUNCTION__], $year, $month, $day);

src/PhpSpreadsheet/Calculation/Statistical/MaxMinBase.php

Spacing +1 added lines, -1 removed lines

@@ -4,7 +4,7 @@
 
 abstract class MaxMinBase
 {
-    protected static function datatypeAdjustmentAllowStrings(int|float|string|bool $value): int|float
+    protected static function datatypeAdjustmentAllowStrings(int | float | string | bool $value): int | float
     {
         if (is_bool($value)) {
             return (int) $value;