PHPOffice / PhpSpreadsheet

src/PhpSpreadsheet/Calculation/Calculation.php

Spacing +13 added lines, -13 removed lines

@@ -214,7 +214,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];
     }
@@ -3314,9 +3314,9 @@ 
         return $formula;
     }
 
-    private static ?array $functionReplaceFromExcel;
+    private static ? array $functionReplaceFromExcel;
 
-    private static ?array $functionReplaceToLocale;
+    private static ? array $functionReplaceToLocale;
 
     public function translateFormulaToLocale(string $formula): string
     {
@@ -3351,9 +3351,9 @@ 
         );
     }
 
-    private static ?array $functionReplaceFromLocale;
+    private static ? array $functionReplaceFromLocale;
 
-    private static ?array $functionReplaceToExcel;
+    private static ? array $functionReplaceToExcel;
 
     public function translateFormulaToEnglish(string $formula): string
     {
@@ -3538,7 +3538,7 @@ 
      *
      * @param string $formula Formula to parse
      */
-    public function parseFormula(string $formula): array|bool
+    public function parseFormula(string $formula): array | bool
     {
         $formula = preg_replace_callback(
             self::CALCULATION_REGEXP_CELLREF_SPILL,
@@ -3941,7 +3941,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(', '))'];
@@ -4036,7 +4036,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;
@@ -5210,7 +5210,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)) {
@@ -5249,7 +5249,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))) {
@@ -5266,7 +5266,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 (
@@ -5483,7 +5483,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 = [];
@@ -5624,7 +5624,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)) {

tests/PhpSpreadsheetTests/Cell/StringableObject.php

Spacing +2 added lines, -2 removed lines

@@ -6,9 +6,9 @@
 
 class StringableObject
 {
-    private int|string $value;
+    private int | string $value;
 
-    public function __construct(int|string $value = 'abc')
+    public function __construct(int | string $value = 'abc')
     {
         $this->value = $value;
     }

src/PhpSpreadsheet/Reader/Xlsx.php

Spacing +4 added lines, -4 removed lines

@@ -2013,26 +2013,26 @@
         }
     }
 
-    private static function getArrayItem(null|array|bool|SimpleXMLElement $array, int|string $key = 0): mixed
+    private static function getArrayItem(null | array | bool | SimpleXMLElement $array, int | string $key = 0): mixed
     {
         return ($array === null || is_bool($array)) ? null : ($array[$key] ?? null);
     }
 
-    private static function getArrayItemString(null|array|bool|SimpleXMLElement $array, int|string $key = 0): string
+    private static function getArrayItemString(null | array | bool | SimpleXMLElement $array, int | string $key = 0): string
     {
         $retVal = self::getArrayItem($array, $key);
 
         return ($retVal === null || is_scalar($retVal) || $retVal instanceof Stringable) ? ((string) $retVal) : '';
     }
 
-    private static function getArrayItemIntOrSxml(null|array|bool|SimpleXMLElement $array, int|string $key = 0): int|SimpleXMLElement
+    private static function getArrayItemIntOrSxml(null | array | bool | SimpleXMLElement $array, int | string $key = 0): int | SimpleXMLElement
     {
         $retVal = self::getArrayItem($array, $key);
 
         return (is_int($retVal) || $retVal instanceof SimpleXMLElement) ? $retVal : 0;
     }
 
-    private static function dirAdd(null|SimpleXMLElement|string $base, null|SimpleXMLElement|string $add): string
+    private static function dirAdd(null | SimpleXMLElement | string $base, null | SimpleXMLElement | string $add): string
     {
         $base = (string) $base;
         $add = (string) $add;

src/PhpSpreadsheet/Reader/Csv.php

Spacing +1 added lines, -1 removed lines

@@ -681,7 +681,7 @@
         string $separator = ',',
         string $enclosure = '"',
         ?string $escape = null
-    ): array|false {
+    ): array | false {
         $escape = $escape ?? self::$defaultEscapeCharacter;
         if (PHP_VERSION_ID >= 80400 && $escape !== '') {
             return @fgetcsv($stream, $length, $separator, $enclosure, $escape);

src/PhpSpreadsheet/Writer/Xls.php

Spacing +4 added lines, -4 removed lines

@@ -376,7 +376,7 @@ 
         }
     }
 
-    private function processMemoryDrawing(BstoreContainer &$bstoreContainer, MemoryDrawing $drawing, string $renderingFunctionx): void
+    private function processMemoryDrawing(BstoreContainer & $bstoreContainer, MemoryDrawing $drawing, string $renderingFunctionx): void
     {
         switch ($renderingFunctionx) {
             case MemoryDrawing::RENDERING_JPEG:
@@ -408,7 +408,7 @@ 
 
     private static int $two = 2; // phpstan silliness
 
-    private function processDrawing(BstoreContainer &$bstoreContainer, Drawing $drawing): void
+    private function processDrawing(BstoreContainer & $bstoreContainer, Drawing $drawing): void
     {
         $blipType = 0;
         $blipData = '';
@@ -465,7 +465,7 @@ 
         }
     }
 
-    private function processBaseDrawing(BstoreContainer &$bstoreContainer, BaseDrawing $drawing): void
+    private function processBaseDrawing(BstoreContainer & $bstoreContainer, BaseDrawing $drawing): void
     {
         if ($drawing instanceof Drawing && $drawing->getPath() !== '') {
             $this->processDrawing($bstoreContainer, $drawing);
@@ -752,7 +752,7 @@ 
         return $data;
     }
 
-    private function writeSummaryPropOle(float|int $dataProp, int &$dataSection_NumProps, array &$dataSection, int $sumdata, int $typdata): void
+    private function writeSummaryPropOle(float | int $dataProp, int &$dataSection_NumProps, array &$dataSection, int $sumdata, int $typdata): void
     {
         if ($dataProp) {
             $dataSection[] = [

src/PhpSpreadsheet/Calculation/MathTrig/Trunc.php

Spacing +1 added lines, -1 removed lines

@@ -25,7 +25,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 evaluate(array|float|string|null $value = 0, array|float|int|string $digits = 0): array|float|string
+    public static function evaluate(array | float | string | null $value = 0, array | float | int | string $digits = 0): array | float | string
     {
         if (is_array($value) || is_array($digits)) {
             return self::evaluateArrayArguments([self::class, __FUNCTION__], $value, $digits);

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(array $values, array $dates, mixed $guess = self::DEFAULT_GUESS): float|string
+    public static function rate(array $values, array $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(array|float $rate, array $values, array $dates): float|string
+    public static function presentValue(array | float $rate, array $values, array $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);

tests/PhpSpreadsheetTests/Style/NumberFormat/Wizard/DurationTest.php

Spacing +1 added lines, -1 removed lines

@@ -14,7 +14,7 @@
      * @param string[] $formatBlocks
      */
     #[\PHPUnit\Framework\Attributes\DataProvider('providerTime')]
-    public function testTime(string $expectedResult, string|array|null $separators = null, array $formatBlocks = []): void
+    public function testTime(string $expectedResult, string | array | null $separators = null, array $formatBlocks = []): void
     {
         $wizard = new Duration($separators, ...$formatBlocks);
         self::assertSame($expectedResult, (string) $wizard);

tests/PhpSpreadsheetTests/Style/NumberFormat/Wizard/TimeTest.php

Spacing +1 added lines, -1 removed lines

@@ -14,7 +14,7 @@
      * @param string[] $formatBlocks
      */
     #[\PHPUnit\Framework\Attributes\DataProvider('providerTime')]
-    public function testTime(string $expectedResult, string|array|null $separators = null, array $formatBlocks = []): void
+    public function testTime(string $expectedResult, string | array | null $separators = null, array $formatBlocks = []): void
     {
         $wizard = new Time($separators, ...$formatBlocks);
         self::assertSame($expectedResult, (string) $wizard);