PHPOffice / PhpSpreadsheet

src/PhpSpreadsheet/Style/ConditionalFormatting/ConditionalFormatValueObject.php

Spacing +4 added lines, -4 removed lines

@@ -6,11 +6,11 @@ 
 {
     private string $type;
 
-    private null|float|int|string $value;
+    private null | float | int | string $value;
 
     private ?string $cellFormula;
 
-    public function __construct(string $type, null|float|int|string $value = null, ?string $cellFormula = null)
+    public function __construct(string $type, null | float | int | string $value = null, ?string $cellFormula = null)
     {
         $this->type = $type;
         $this->value = $value;
@@ -29,12 +29,12 @@ 
         return $this;
     }
 
-    public function getValue(): null|float|int|string
+    public function getValue(): null | float | int | string
     {
         return $this->value;
     }
 
-    public function setValue(null|float|int|string $value): self
+    public function setValue(null | float | int | string $value): self
     {
         $this->value = $value;
 

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/Calculation.php

Spacing +13 added lines, -13 removed lines

@@ -208,7 +208,7 @@ 
         return array_key_exists($key, self::$excelConstants);
     }
 
-    public static function getExcelConstants(string $key): bool|null
+    public static function getExcelConstants(string $key): bool | null
     {
         return self::$excelConstants[$key];
     }
@@ -3273,10 +3273,10 @@ 
     }
 
     /** @var ?array */
-    private static ?array $functionReplaceFromExcel;
+    private static ? array $functionReplaceFromExcel;
 
     /** @var ?array */
-    private static ?array $functionReplaceToLocale;
+    private static ? array $functionReplaceToLocale;
 
     /**
      * @deprecated 1.30.0 use translateFormulaToLocale() instead
@@ -3322,10 +3322,10 @@ 
     }
 
     /** @var ?array */
-    private static ?array $functionReplaceFromLocale;
+    private static ? array $functionReplaceFromLocale;
 
     /** @var ?array */
-    private static ?array $functionReplaceToExcel;
+    private static ? array $functionReplaceToExcel;
 
     /**
      * @deprecated 1.30.0 use translateFormulaToEnglish() instead
@@ -3533,7 +3533,7 @@ 
      *
      * @param string $formula Formula to parse
      */
-    public function parseFormula(string $formula): array|bool
+    public function parseFormula(string $formula): array | bool
     {
         //    Basic validation that this is indeed a formula
         //    We return an empty array if not
@@ -3927,7 +3927,7 @@ 
     /**
      * @return false|string False indicates an error
      */
-    private function convertMatrixReferences(string $formula): false|string
+    private function convertMatrixReferences(string $formula): false | string
     {
         static $matrixReplaceFrom = [self::FORMULA_OPEN_MATRIX_BRACE, ';', self::FORMULA_CLOSE_MATRIX_BRACE];
         static $matrixReplaceTo = ['MKMATRIX(MKMATRIX(', '),MKMATRIX(', '))'];
@@ -4022,7 +4022,7 @@ 
     /**
      * @return array<int, mixed>|false
      */
-    private function internalParseFormula(string $formula, ?Cell $cell = null): bool|array
+    private function internalParseFormula(string $formula, ?Cell $cell = null): bool | array
     {
         if (($formula = $this->convertMatrixReferences(trim($formula))) === false) {
             return false;
@@ -5153,7 +5153,7 @@ 
         return true;
     }
 
-    private function executeArrayComparison(mixed $operand1, mixed $operand2, string $operation, Stack &$stack, bool $recursingArrays): array
+    private function executeArrayComparison(mixed $operand1, mixed $operand2, string $operation, Stack & $stack, bool $recursingArrays): array
     {
         $result = [];
         if (!is_array($operand2)) {
@@ -5192,7 +5192,7 @@ 
         return $result;
     }
 
-    private function executeBinaryComparisonOperation(mixed $operand1, mixed $operand2, string $operation, Stack &$stack, bool $recursingArrays = false): array|bool
+    private function executeBinaryComparisonOperation(mixed $operand1, mixed $operand2, string $operation, Stack & $stack, bool $recursingArrays = false): array | bool
     {
         //    If we're dealing with matrix operations, we want a matrix result
         if ((is_array($operand1)) || (is_array($operand2))) {
@@ -5209,7 +5209,7 @@ 
         return $result;
     }
 
-    private function executeNumericBinaryOperation(mixed $operand1, mixed $operand2, string $operation, Stack &$stack): mixed
+    private function executeNumericBinaryOperation(mixed $operand1, mixed $operand2, string $operation, Stack & $stack): mixed
     {
         //    Validate the two operands
         if (
@@ -5414,7 +5414,7 @@ 
      *
      * @return array|string Array of values in range if range contains more than one element. Otherwise, a single value is returned.
      */
-    public function extractNamedRange(string &$range = 'A1', ?Worksheet $worksheet = null, bool $resetLog = true): string|array
+    public function extractNamedRange(string &$range = 'A1', ?Worksheet $worksheet = null, bool $resetLog = true): string | array
     {
         // Return value
         $returnValue = [];
@@ -5555,7 +5555,7 @@ 
     /**
      * Add cell reference if needed while making sure that it is the last argument.
      */
-    private function addCellReference(array $args, bool $passCellReference, array|string $functionCall, ?Cell $cell = null): array
+    private function addCellReference(array $args, bool $passCellReference, array | string $functionCall, ?Cell $cell = null): array
     {
         if ($passCellReference) {
             if (is_array($functionCall)) {

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;