PHPOffice / PhpSpreadsheet

src/PhpSpreadsheet/Calculation/Financial/CashFlow/Constant/Periodic/Interest.php

Spacing +4 added lines, -4 removed lines

@@ -37,7 +37,7 @@ 
         mixed $presentValue,
         mixed $futureValue = 0,
         mixed $type = FinancialConstants::PAYMENT_END_OF_PERIOD
-    ): string|float {
+    ): string | float {
         $interestRate = Functions::flattenSingleValue($interestRate);
         $period = Functions::flattenSingleValue($period);
         $numberOfPeriods = Functions::flattenSingleValue($numberOfPeriods);
@@ -87,7 +87,7 @@ 
      * @param mixed $numberOfPeriods is the number of payments for the annuity
      * @param mixed $principleRemaining is the loan amount or present value of the payments
      */
-    public static function schedulePayment(mixed $interestRate, mixed $period, mixed $numberOfPeriods, mixed $principleRemaining): string|float
+    public static function schedulePayment(mixed $interestRate, mixed $period, mixed $numberOfPeriods, mixed $principleRemaining): string | float
     {
         $interestRate = Functions::flattenSingleValue($interestRate);
         $period = Functions::flattenSingleValue($period);
@@ -156,7 +156,7 @@ 
         mixed $futureValue = 0.0,
         mixed $type = FinancialConstants::PAYMENT_END_OF_PERIOD,
         mixed $guess = 0.1
-    ): string|float {
+    ): string | float {
         $numberOfPeriods = Functions::flattenSingleValue($numberOfPeriods);
         $payment = Functions::flattenSingleValue($payment);
         $presentValue = Functions::flattenSingleValue($presentValue);
@@ -193,7 +193,7 @@ 
         return $close ? $rate : ExcelError::NAN();
     }
 
-    private static function rateNextGuess(float $rate, float $numberOfPeriods, float $payment, float $presentValue, float $futureValue, int $type): string|float
+    private static function rateNextGuess(float $rate, float $numberOfPeriods, float $payment, float $presentValue, float $futureValue, int $type): string | float
     {
         if ($rate == 0.0) {
             return ExcelError::NAN();

src/PhpSpreadsheet/Reader/Xls.php

Spacing +1 added lines, -1 removed lines

@@ -4648,7 +4648,7 @@
      * It can also happen that the REF structure uses the -1 (FFFF) code to indicate deleted sheets,
      * in which case an Exception is thrown.
      */
-    protected function readSheetRangeByRefIndex(int $index): string|false
+    protected function readSheetRangeByRefIndex(int $index): string | false
     {
         if (isset($this->ref[$index])) {
             $type = $this->externalBooks[$this->ref[$index]['externalBookIndex']]['type'];

src/PhpSpreadsheet/Reader/Xls/ConditionalFormatting.php

Spacing +2 added lines, -2 removed lines

@@ -299,7 +299,7 @@ 
     {
     }*/
 
-    private function readCFFormula(string $recordData, int $offset, int $size, Xls $xls): float|int|string|null
+    private function readCFFormula(string $recordData, int $offset, int $size, Xls $xls): float | int | string | null
     {
         try {
             $formula = substr($recordData, $offset, $size);
@@ -316,7 +316,7 @@ 
         }
     }
 
-    private function setCFRules(array $cellRanges, string $type, string $operator, null|float|int|string $formula1, null|float|int|string $formula2, Style $style, bool $noFormatSet, Xls $xls): void
+    private function setCFRules(array $cellRanges, string $type, string $operator, null | float | int | string $formula1, null | float | int | string $formula2, Style $style, bool $noFormatSet, Xls $xls): void
     {
         foreach ($cellRanges as $cellRange) {
             $conditional = new Conditional();

src/PhpSpreadsheet/Reader/XlsBase.php

Spacing +4 added lines, -4 removed lines

@@ -110,10 +110,10 @@ 
     // should be consistent with Writer\Xls\Style\CellBorder
     final const BORDER_STYLE_MAP = [
         Border::BORDER_NONE, // => 0x00,
-        Border::BORDER_THIN,  // => 0x01,
+        Border::BORDER_THIN, // => 0x01,
         Border::BORDER_MEDIUM, // => 0x02,
         Border::BORDER_DASHED, // => 0x03,
-        Border::BORDER_DOTTED,  // => 0x04,
+        Border::BORDER_DOTTED, // => 0x04,
         Border::BORDER_THICK, // => 0x05,
         Border::BORDER_DOUBLE, // => 0x06,
         Border::BORDER_HAIR, // => 0x07,
@@ -275,7 +275,7 @@ 
      *
      * @param string $data Binary string that is at least 8 bytes long
      */
-    protected static function extractNumber(string $data): int|float
+    protected static function extractNumber(string $data): int | float
     {
         $rknumhigh = self::getInt4d($data, 4);
         $rknumlow = self::getInt4d($data, 0);
@@ -300,7 +300,7 @@ 
         return $value;
     }
 
-    protected static function getIEEE754(int $rknum): float|int
+    protected static function getIEEE754(int $rknum): float | int
     {
         if (($rknum & 0x02) != 0) {
             $value = $rknum >> 2;

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
     {
         $year = (int) $year;
 
@@ -62,7 +62,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);
@@ -128,7 +128,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) {
@@ -161,7 +161,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) {
@@ -178,7 +178,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) {
@@ -223,7 +223,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) {
@@ -280,7 +280,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/Reader/Xml.php

Spacing +1 added lines, -1 removed lines

@@ -108,7 +108,7 @@
     }
 
     /** @return false|SimpleXMLElement */
-    private function trySimpleXMLLoadStringPrivate(string $filename, string $fileOrString = 'file'): SimpleXMLElement|bool
+    private function trySimpleXMLLoadStringPrivate(string $filename, string $fileOrString = 'file'): SimpleXMLElement | bool
     {
         $this->xmlFailMessage = "Cannot load invalid XML $fileOrString: " . $filename;
         $xml = false;

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/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[] = [