PHPOffice / PhpSpreadsheet

src/PhpSpreadsheet/Worksheet/Worksheet.php

Spacing +16 added lines, -16 removed lines

@@ -1110,7 +1110,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);
@@ -1135,7 +1135,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);
@@ -1156,7 +1156,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));
 
@@ -1302,7 +1302,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);
@@ -1388,7 +1388,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);
 
@@ -1595,7 +1595,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));
 
@@ -1692,7 +1692,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));
 
@@ -1812,7 +1812,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));
 
@@ -1865,7 +1865,7 @@ 
      *
      * @return $this
      */
-    public function protectCells(AddressRange|CellAddress|int|string|array $range, string $password, bool $alreadyHashed = false): static
+    public function protectCells(AddressRange | CellAddress | int | string | array $range, string $password, bool $alreadyHashed = false): static
     {
         $range = Functions::trimSheetFromCellReference(Validations::validateCellOrCellRange($range));
 
@@ -1886,7 +1886,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));
 
@@ -1927,7 +1927,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;
@@ -2072,7 +2072,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,
@@ -2582,7 +2582,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));
 
@@ -2607,7 +2607,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): Comment
+    public function getComment(CellAddress | string | array $cellCoordinate): Comment
     {
         $cellAddress = Functions::trimSheetFromCellReference(Validations::validateCellAddress($cellCoordinate));
 
@@ -2670,7 +2670,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);
@@ -3100,7 +3100,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): array|null|string
+    public static function extractSheetTitle(?string $range, bool $returnRange = false): array | null | string
     {
         if (empty($range)) {
             return $returnRange ? [null, null] : null;

src/PhpSpreadsheet/Worksheet/AutoFilter.php

Spacing +4 added lines, -4 removed lines

@@ -53,7 +53,7 @@ 
      *              or passing in an array of [$fromColumnIndex, $fromRow, $toColumnIndex, $toRow] (e.g. [3, 5, 6, 8]),
      *              or an AddressRange object.
      */
-    public function __construct(AddressRange|string|array $range = '', ?Worksheet $worksheet = null)
+    public function __construct(AddressRange | string | array $range = '', ?Worksheet $worksheet = null)
     {
         if ($range !== '') {
             [, $range] = Worksheet::extractSheetTitle(Validations::validateCellRange($range), true);
@@ -71,7 +71,7 @@ 
     /**
      * Get AutoFilter Parent Worksheet.
      */
-    public function getParent(): null|Worksheet
+    public function getParent(): null | Worksheet
     {
         return $this->workSheet;
     }
@@ -105,7 +105,7 @@ 
      *              or passing in an array of [$fromColumnIndex, $fromRow, $toColumnIndex, $toRow] (e.g. [3, 5, 6, 8]),
      *              or an AddressRange object.
      */
-    public function setRange(AddressRange|string|array $range = ''): self
+    public function setRange(AddressRange | string | array $range = ''): self
     {
         $this->evaluated = false;
         // extract coordinate
@@ -233,7 +233,7 @@ 
      *
      * @return $this
      */
-    public function setColumn(AutoFilter\Column|string $columnObjectOrString): static
+    public function setColumn(AutoFilter\Column | string $columnObjectOrString): static
     {
         $this->evaluated = false;
         if ((is_string($columnObjectOrString)) && (!empty($columnObjectOrString))) {

src/PhpSpreadsheet/Worksheet/Table.php

Spacing +3 added lines, -3 removed lines

@@ -69,7 +69,7 @@ 
      *              or an AddressRange object.
      * @param string $name (e.g. Table1)
      */
-    public function __construct(AddressRange|string|array $range = '', string $name = '')
+    public function __construct(AddressRange | string | array $range = '', string $name = '')
     {
         $this->style = new TableStyle();
         $this->autoFilter = new AutoFilter($range);
@@ -272,7 +272,7 @@ 
      *              or passing in an array of [$fromColumnIndex, $fromRow, $toColumnIndex, $toRow] (e.g. [3, 5, 6, 8]),
      *              or an AddressRange object.
      */
-    public function setRange(AddressRange|string|array $range = ''): self
+    public function setRange(AddressRange | string | array $range = ''): self
     {
         // extract coordinate
         if ($range !== '') {
@@ -437,7 +437,7 @@ 
      * @param string|Table\Column $columnObjectOrString
      *            A simple string containing a Column ID like 'A' is permitted
      */
-    public function setColumn(string|Table\Column $columnObjectOrString): self
+    public function setColumn(string | Table\Column $columnObjectOrString): self
     {
         if ((is_string($columnObjectOrString)) && (!empty($columnObjectOrString))) {
             $column = $columnObjectOrString;

src/PhpSpreadsheet/Worksheet/PageBreak.php

Spacing +1 added lines, -1 removed lines

@@ -17,7 +17,7 @@
     /**
      * @param array{0: int, 1: int}|CellAddress|string $coordinate
      */
-    public function __construct(int $breakType, CellAddress|string|array $coordinate, int $maxColOrRow = -1)
+    public function __construct(int $breakType, CellAddress | string | array $coordinate, int $maxColOrRow = -1)
     {
         $coordinate = Functions::trimSheetFromCellReference(Validations::validateCellAddress($coordinate));
         $this->breakType = $breakType;

src/PhpSpreadsheet/Worksheet/Validations.php

Spacing +3 added lines, -3 removed lines

@@ -15,7 +15,7 @@ 
      * @param null|array{0: int, 1: int}|CellAddress|string $cellAddress 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 static function validateCellAddress(null|CellAddress|string|array $cellAddress): string
+    public static function validateCellAddress(null | CellAddress | string | array $cellAddress): string
     {
         if (is_string($cellAddress)) {
             [$worksheet, $address] = Worksheet::extractSheetTitle($cellAddress, true);
@@ -40,7 +40,7 @@ 
      *               or as an array of [$fromColumnIndex, $fromRow, $toColumnIndex, $toRow] (e.g. [3, 5, 6, 12]),
      *               or as a CellAddress or AddressRange object.
      */
-    public static function validateCellOrCellRange(AddressRange|CellAddress|int|string|array $cellRange): string
+    public static function validateCellOrCellRange(AddressRange | CellAddress | int | string | array $cellRange): string
     {
         if (is_string($cellRange) || is_numeric($cellRange)) {
             // Convert a single column reference like 'A' to 'A:A',
@@ -63,7 +63,7 @@ 
      *               or as an array of [$fromColumnIndex, $fromRow, $toColumnIndex, $toRow] (e.g. [3, 5, 6, 12]),
      *               or as an AddressRange object.
      */
-    public static function validateCellRange(AddressRange|string|array $cellRange): string
+    public static function validateCellRange(AddressRange | string | array $cellRange): string
     {
         if (is_string($cellRange)) {
             [$worksheet, $addressRange] = Worksheet::extractSheetTitle($cellRange, true);

src/PhpSpreadsheet/Reader/Xlsx/ConditionalStyles.php

Spacing +1 added lines, -1 removed lines

@@ -282,7 +282,7 @@
         return $dataBar;
     }
 
-    private function readColorScale(SimpleXMLElement|stdClass $cfRule): ConditionalColorScale
+    private function readColorScale(SimpleXMLElement | stdClass $cfRule): ConditionalColorScale
     {
         $colorScale = new ConditionalColorScale();
         $types = [];

samples/Chart33a/33_Chart_create_line_dateaxis.php

Spacing +4 added lines, -4 removed lines

@@ -181,7 +181,7 @@ 
     true, // plotVisibleOnly
     DataSeries::EMPTY_AS_GAP, // displayBlanksAs
     null, // xAxisLabel
-    $yAxisLabel,  // yAxisLabel
+    $yAxisLabel, // yAxisLabel
     // added xAxis for correct date display
     $xAxis, // xAxis
     $yAxis, // yAxis
@@ -291,13 +291,13 @@ 
     null, // minor_tick_mark
     $dateMinMax['min'], // minimum calculate this from the earliest data: 'Data!$A$2'
     $dateMinMax['max'], // maximum calculate this from the last data:     'Data!$A$'.($nrows+1)
-    $tickMarkInterval,  // majorUnit determines tickmarks & Gridlines ?
+    $tickMarkInterval, // majorUnit determines tickmarks & Gridlines ?
     null, // minorUnit
     null, // textRotation
     null, // hidden
     'days', // baseTimeUnit
     'months', // majorTimeUnit,
-    'months',   // minorTimeUnit
+    'months', // minorTimeUnit
 );
 
 $yAxisLabel = new Title('Value ($k)');
@@ -317,7 +317,7 @@ 
     true, // plotVisibleOnly
     DataSeries::EMPTY_AS_GAP, // displayBlanksAs
     null, // xAxisLabel
-    $yAxisLabel,  // yAxisLabel
+    $yAxisLabel, // yAxisLabel
     // added xAxis for correct date display
     $xAxis, // xAxis
     $yAxis, // yAxis

samples/Chart33b/33_Chart_create_scatter5_trendlines.php

Spacing +2 added lines, -2 removed lines

@@ -155,7 +155,7 @@ 
     true, // plotVisibleOnly
     DataSeries::EMPTY_AS_GAP, // displayBlanksAs
     null, // xAxisLabel
-    $yAxisLabel,  // yAxisLabel
+    $yAxisLabel, // yAxisLabel
     // added xAxis for correct date display
     $xAxis, // xAxis
     //  $yAxis, // yAxis
@@ -251,7 +251,7 @@ 
     true, // plotVisibleOnly
     DataSeries::EMPTY_AS_GAP, // displayBlanksAs
     null, // xAxisLabel
-    $yAxisLabel,  // yAxisLabel
+    $yAxisLabel, // yAxisLabel
     // added xAxis for correct date display
     $xAxis, // xAxis
     //  $yAxis, // yAxis

samples/Chart33b/33_Chart_create_scatter3.php

Spacing +1 added lines, -1 removed lines

@@ -129,7 +129,7 @@
 
 $yAxis = new ChartAxis();
 $yAxis->setLineStyleProperties(
-    2.5,     // width in points
+    2.5, // width in points
     Properties::LINE_STYLE_COMPOUND_SIMPLE,
     Properties::LINE_STYLE_DASH_DASH_DOT,
     Properties::LINE_STYLE_CAP_FLAT,