PHPOffice / PhpSpreadsheet

tests/PhpSpreadsheetTests/Calculation/Functions/Logical/AndTest.php

Spacing +1 added lines, -1 removed lines

@@ -21,7 +21,7 @@
     }
 
     #[DataProvider('providerANDLiteral')]
-    public function testANDLiteral(bool|string $expectedResult, float|int|string $formula): void
+    public function testANDLiteral(bool | string $expectedResult, float | int | string $formula): void
     {
         $sheet = $this->getSheet();
         $sheet->getCell('A1')->setValue("=AND($formula)");

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

src/PhpSpreadsheet/Calculation/Financial/CashFlow/Single.php

Spacing +3 added lines, -3 removed lines

@@ -20,7 +20,7 @@ 
      * @param mixed $principal the present value
      * @param float[] $schedule an array of interest rates to apply
      */
-    public static function futureValue(mixed $principal, array $schedule): string|float
+    public static function futureValue(mixed $principal, array $schedule): string | float
     {
         $principal = Functions::flattenSingleValue($principal);
         $schedule = Functions::flattenArray($schedule);
@@ -50,7 +50,7 @@ 
      *
      * @return float|string Result, or a string containing an error
      */
-    public static function periods(mixed $rate, mixed $presentValue, mixed $futureValue): string|float
+    public static function periods(mixed $rate, mixed $presentValue, mixed $futureValue): string | float
     {
         $rate = Functions::flattenSingleValue($rate);
         $presentValue = Functions::flattenSingleValue($presentValue);
@@ -83,7 +83,7 @@ 
      *
      * @return float|string Result, or a string containing an error
      */
-    public static function interestRate(mixed $periods = 0.0, mixed $presentValue = 0.0, mixed $futureValue = 0.0): string|float
+    public static function interestRate(mixed $periods = 0.0, mixed $presentValue = 0.0, mixed $futureValue = 0.0): string | float
     {
         $periods = Functions::flattenSingleValue($periods);
         $presentValue = Functions::flattenSingleValue($presentValue);

src/PhpSpreadsheet/Worksheet/Worksheet.php

Spacing +16 added lines, -16 removed lines

@@ -1112,7 +1112,7 @@ 
      *
      * @return $this
      */
-    public function setCellValue(CellAddress|string|array $coordinate, mixed $value, ?IValueBinder $binder = null): static
+    public function setCellValue(CellAddress | string | array $coordinate, mixed $value, ?IValueBinder $binder = null): static
     {
         $cellAddress = Functions::trimSheetFromCellReference(Validations::validateCellAddress($coordinate));
         $this->getCell($cellAddress)->setValue($value, $binder);
@@ -1137,7 +1137,7 @@ 
      *
      * @return $this
      */
-    public function setCellValueExplicit(CellAddress|string|array $coordinate, mixed $value, string $dataType): static
+    public function setCellValueExplicit(CellAddress | string | array $coordinate, mixed $value, string $dataType): static
     {
         $cellAddress = Functions::trimSheetFromCellReference(Validations::validateCellAddress($coordinate));
         $this->getCell($cellAddress)->setValueExplicit($value, $dataType);
@@ -1158,7 +1158,7 @@ 
      *              the "active" cell, and any previous assignment becomes a disconnected reference because
      *              the active cell has changed.
      */
-    public function getCell(CellAddress|string|array $coordinate): Cell
+    public function getCell(CellAddress | string | array $coordinate): Cell
     {
         $cellAddress = Functions::trimSheetFromCellReference(Validations::validateCellAddress($coordinate));
 
@@ -1303,7 +1303,7 @@ 
      * @param array{0: int, 1: int}|CellAddress|string $coordinate Coordinate of the cell as a string, eg: 'C5';
      *               or as an array of [$columnIndex, $row] (e.g. [3, 5]), or a CellAddress object.
      */
-    public function cellExists(CellAddress|string|array $coordinate): bool
+    public function cellExists(CellAddress | string | array $coordinate): bool
     {
         $cellAddress = Validations::validateCellAddress($coordinate);
         [$sheet, $finalCoordinate] = $this->getWorksheetAndCoordinate($cellAddress);
@@ -1393,7 +1393,7 @@ 
      *              or passing in an array of [$fromColumnIndex, $fromRow, $toColumnIndex, $toRow] (e.g. [3, 5, 6, 8]),
      *              or a CellAddress or AddressRange object.
      */
-    public function getStyle(AddressRange|CellAddress|int|string|array $cellCoordinate): Style
+    public function getStyle(AddressRange | CellAddress | int | string | array $cellCoordinate): Style
     {
         $cellCoordinate = Validations::validateCellOrCellRange($cellCoordinate);
 
@@ -1635,7 +1635,7 @@ 
      *
      * @return $this
      */
-    public function setBreak(CellAddress|string|array $coordinate, int $break, int $max = -1): static
+    public function setBreak(CellAddress | string | array $coordinate, int $break, int $max = -1): static
     {
         $cellAddress = Functions::trimSheetFromCellReference(Validations::validateCellAddress($coordinate));
 
@@ -1732,7 +1732,7 @@ 
      *
      * @return $this
      */
-    public function mergeCells(AddressRange|string|array $range, string $behaviour = self::MERGE_CELL_CONTENT_EMPTY): static
+    public function mergeCells(AddressRange | string | array $range, string $behaviour = self::MERGE_CELL_CONTENT_EMPTY): static
     {
         $range = Functions::trimSheetFromCellReference(Validations::validateCellRange($range));
 
@@ -1852,7 +1852,7 @@ 
      *
      * @return $this
      */
-    public function unmergeCells(AddressRange|string|array $range): static
+    public function unmergeCells(AddressRange | string | array $range): static
     {
         $range = Functions::trimSheetFromCellReference(Validations::validateCellRange($range));
 
@@ -1905,7 +1905,7 @@ 
      *
      * @return $this
      */
-    public function protectCells(AddressRange|CellAddress|int|string|array $range, string $password = '', bool $alreadyHashed = false, string $name = '', string $securityDescriptor = ''): static
+    public function protectCells(AddressRange | CellAddress | int | string | array $range, string $password = '', bool $alreadyHashed = false, string $name = '', string $securityDescriptor = ''): static
     {
         $range = Functions::trimSheetFromCellReference(Validations::validateCellOrCellRange($range));
 
@@ -1926,7 +1926,7 @@ 
      *
      * @return $this
      */
-    public function unprotectCells(AddressRange|CellAddress|int|string|array $range): static
+    public function unprotectCells(AddressRange | CellAddress | int | string | array $range): static
     {
         $range = Functions::trimSheetFromCellReference(Validations::validateCellOrCellRange($range));
 
@@ -1967,7 +1967,7 @@ 
      *
      * @return $this
      */
-    public function setAutoFilter(AddressRange|string|array|AutoFilter $autoFilterOrRange): static
+    public function setAutoFilter(AddressRange | string | array | AutoFilter $autoFilterOrRange): static
     {
         if (is_object($autoFilterOrRange) && ($autoFilterOrRange instanceof AutoFilter)) {
             $this->autoFilter = $autoFilterOrRange;
@@ -2112,7 +2112,7 @@ 
      *
      * @return $this
      */
-    public function freezePane(null|CellAddress|string|array $coordinate, null|CellAddress|string|array $topLeftCell = null, bool $frozenSplit = false): static
+    public function freezePane(null | CellAddress | string | array $coordinate, null | CellAddress | string | array $topLeftCell = null, bool $frozenSplit = false): static
     {
         $this->panes = [
             'bottomRight' => null,
@@ -2622,7 +2622,7 @@ 
      *
      * @return $this
      */
-    public function removeComment(CellAddress|string|array $cellCoordinate): self
+    public function removeComment(CellAddress | string | array $cellCoordinate): self
     {
         $cellAddress = Functions::trimSheetFromCellReference(Validations::validateCellAddress($cellCoordinate));
 
@@ -2647,7 +2647,7 @@ 
      * @param array{0: int, 1: int}|CellAddress|string $cellCoordinate Coordinate of the cell as a string, eg: 'C5';
      *               or as an array of [$columnIndex, $row] (e.g. [3, 5]), or a CellAddress object.
      */
-    public function getComment(CellAddress|string|array $cellCoordinate, bool $attachNew = true): Comment
+    public function getComment(CellAddress | string | array $cellCoordinate, bool $attachNew = true): Comment
     {
         $cellAddress = Functions::trimSheetFromCellReference(Validations::validateCellAddress($cellCoordinate));
 
@@ -2712,7 +2712,7 @@ 
      *
      * @return $this
      */
-    public function setSelectedCells(AddressRange|CellAddress|int|string|array $coordinate): static
+    public function setSelectedCells(AddressRange | CellAddress | int | string | array $coordinate): static
     {
         if (is_string($coordinate)) {
             $coordinate = Validations::definedNameToCoordinate($coordinate, $this);
@@ -3182,7 +3182,7 @@ 
      *
      * @return ($range is non-empty-string ? ($returnRange is true ? array{0: string, 1: string} : string) : ($returnRange is true ? array{0: null, 1: null} : null))
      */
-    public static function extractSheetTitle(?string $range, bool $returnRange = false, bool $unapostrophize = false): array|null|string
+    public static function extractSheetTitle(?string $range, bool $returnRange = false, bool $unapostrophize = false): array | null | string
     {
         if (empty($range)) {
             return $returnRange ? [null, null] : null;