PHPOffice / PhpSpreadsheet

tests/PhpSpreadsheetTests/Calculation/CustomFunction.php

Spacing +1 added lines, -1 removed lines

@@ -9,7 +9,7 @@
 
 class CustomFunction
 {
-    public static function fourthPower(mixed $number): float|int|string
+    public static function fourthPower(mixed $number): float | int | string
     {
         try {
             $number = Helpers::validateNumericNullBool($number);

src/PhpSpreadsheet/Reader/Xlsx.php

Spacing +4 added lines, -4 removed lines

@@ -2029,26 +2029,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 StringHelper::convertToString($retVal, false);
     }
 
-    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;

tests/PhpSpreadsheetTests/Reader/Xlsx/MySpreadsheet.php

Spacing +1 added lines, -1 removed lines

@@ -8,7 +8,7 @@
 
 class MySpreadsheet extends Spreadsheet
 {
-    public function calcSquare(string $cellAddress): float|int|string
+    public function calcSquare(string $cellAddress): float | int | string
     {
         $value = $this->getActiveSheet()
             ->getCell($cellAddress)

src/PhpSpreadsheet/Reader/Html.php

Spacing +3 added lines, -3 removed lines

@@ -254,7 +254,7 @@ 
      *
      * @param-out string $cellContent In one case, it can be bool
      */
-    protected function flushCell(Worksheet $sheet, string $column, int|string $row, mixed &$cellContent, array $attributeArray): void
+    protected function flushCell(Worksheet $sheet, string $column, int | string $row, mixed &$cellContent, array $attributeArray): void
     {
         if (is_string($cellContent)) {
             //    Simple String content
@@ -304,7 +304,7 @@ 
     /** @var array<int, array<int, string>> */
     private static array $falseTrueArray = [];
 
-    private static function convertBoolean(?string $cellContent): bool|string
+    private static function convertBoolean(?string $cellContent): bool | string
     {
         if ($cellContent === '1') {
             return true;
@@ -892,7 +892,7 @@ 
      * TODO :
      * - Implement to other propertie, such as border
      */
-    private function applyInlineStyle(Worksheet &$sheet, int $row, string $column, array $attributeArray): void
+    private function applyInlineStyle(Worksheet & $sheet, int $row, string $column, array $attributeArray): void
     {
         if (!isset($attributeArray['style'])) {
             return;

src/PhpSpreadsheet/Writer/Html.php

Spacing +2 added lines, -2 removed lines

@@ -1406,7 +1406,7 @@ 
         }
     }
 
-    private function generateRowCellData(Worksheet $worksheet, null|Cell|string $cell, array|string &$cssClass): string
+    private function generateRowCellData(Worksheet $worksheet, null | Cell | string $cell, array | string &$cssClass): string
     {
         $cellData = ' ';
         if ($cell instanceof Cell) {
@@ -1487,7 +1487,7 @@ 
         string $cellData,
         int $colSpan,
         int $rowSpan,
-        array|string $cssClass,
+        array | string $cssClass,
         int $colNum,
         int $sheetIndex,
         int $row,

src/PhpSpreadsheet/Calculation/Financial/Helpers.php

Spacing +1 added lines, -1 removed lines

@@ -24,7 +24,7 @@
      *
      * @return int|string Result, or a string containing an error
      */
-    public static function daysPerYear(mixed $year, $basis = 0): string|int
+    public static function daysPerYear(mixed $year, $basis = 0): string | int
     {
         if (!is_int($year) && !is_string($year)) {
             return ExcelError::VALUE();

src/PhpSpreadsheet/Calculation/Financial/CashFlow/Variable/NonPeriodic.php

Spacing +5 added lines, -5 removed lines

@@ -31,7 +31,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(mixed $values, $dates, mixed $guess = self::DEFAULT_GUESS): float|string
+    public static function rate(mixed $values, $dates, mixed $guess = self::DEFAULT_GUESS): float | string
     {
         $rslt = self::xirrPart1($values, $dates);
         /** @var array $dates */
@@ -119,7 +119,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(mixed $rate, mixed $values, mixed $dates): float|string
+    public static function presentValue(mixed $rate, mixed $values, mixed $dates): float | string
     {
         return self::xnpvOrdered($rate, $values, $dates, true);
     }
@@ -178,7 +178,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) {
@@ -207,7 +207,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) {
@@ -244,7 +244,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);
         if (!is_numeric($rate)) {

src/PhpSpreadsheet/Calculation/DateTimeExcel/Helpers.php

Spacing +8 added lines, -8 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;
 
@@ -64,7 +64,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);
@@ -132,7 +132,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) {
@@ -165,7 +165,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) {
@@ -182,7 +182,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) {
@@ -227,7 +227,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) {
@@ -284,12 +284,12 @@ 
      *
      * @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];
     }
 
-    public static function floatOrInt(mixed $value): float|int
+    public static function floatOrInt(mixed $value): float | int
     {
         $result = Functions::scalar($value);
 

tests/PhpSpreadsheetTests/Calculation/Functions/DateTime/DateTest.php

Spacing +1 added lines, -1 removed lines

@@ -38,7 +38,7 @@
     }
 
     #[DataProvider('providerDATE')]
-    public function testDirectCallToDATE(float|string $expectedResult, int|string $year, null|bool|float|int|string $month, float|int|string $day): void
+    public function testDirectCallToDATE(float | string $expectedResult, int | string $year, null | bool | float | int | string $month, float | int | string $day): void
     {
         $result = Date::fromYMD($year, $month, $day);
         self::assertSame($expectedResult, $result);