PHPOffice / PhpSpreadsheet

src/PhpSpreadsheet/Worksheet/Worksheet.php

Indentation +12 added lines, -12 removed lines

@@ -3872,19 +3872,19 @@ 
     }
 
 
-     /**
-      * Copy a row, including style, data and height
-      *
-      * @param int $from row that will be copied
-      * @param int $to row that will receive the copy
-      * @return void
-      */
-      public function copyRow($from, $to) {
+        /**
+         * Copy a row, including style, data and height
+         *
+         * @param int $from row that will be copied
+         * @param int $to row that will receive the copy
+         * @return void
+         */
+        public function copyRow($from, $to) {
         $this->getRowDimension($to)->setRowHeight($this->getRowDimension($from)->getRowHeight());
         $fromRowCellIterator = $this->getRowIterator($from,$from)->current()->getCellIterator();
         try {
-          $fromRowCellIterator->setIterateOnlyExistingCells(true);
-          foreach ($fromRowCellIterator as $fromCellIt) {
+            $fromRowCellIterator->setIterateOnlyExistingCells(true);
+            foreach ($fromRowCellIterator as $fromCellIt) {
             $fromCoordinates = $fromCellIt->getCoordinate();
             $toCellCoordinates = $fromCellIt->getColumn().$to;
             // Cache data as trying to save the cells as variables doesn't work
@@ -3896,9 +3896,9 @@ 
             $toCell->setValue($value);
             $toCell->setDataType($dataType);
             $this->duplicateStyle($style,$toCellCoordinates);
-          }
+            }
         } catch (\Exception $e) {
-          unset($e); // Do nothing, the row was empty
+            unset($e); // Do nothing, the row was empty
         }
     }
 

Spacing +19 added lines, -19 removed lines

@@ -1116,7 +1116,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);
@@ -1141,7 +1141,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);
@@ -1162,7 +1162,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));
 
@@ -1307,7 +1307,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);
@@ -1397,7 +1397,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
     {
         if (is_string($cellCoordinate)) {
             $cellCoordinate = Validations::definedNameToCoordinate($cellCoordinate, $this);
@@ -1669,7 +1669,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));
 
@@ -1766,7 +1766,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));
 
@@ -1882,7 +1882,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));
 
@@ -1935,7 +1935,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));
 
@@ -1956,7 +1956,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));
 
@@ -1997,7 +1997,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;
@@ -2142,7 +2142,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,
@@ -2652,7 +2652,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));
 
@@ -2677,7 +2677,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));
 
@@ -2742,7 +2742,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);
@@ -3246,7 +3246,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;
@@ -3881,12 +3881,12 @@ 
       */
       public function copyRow($from, $to) {
         $this->getRowDimension($to)->setRowHeight($this->getRowDimension($from)->getRowHeight());
-        $fromRowCellIterator = $this->getRowIterator($from,$from)->current()->getCellIterator();
+        $fromRowCellIterator = $this->getRowIterator($from, $from)->current()->getCellIterator();
         try {
           $fromRowCellIterator->setIterateOnlyExistingCells(true);
           foreach ($fromRowCellIterator as $fromCellIt) {
             $fromCoordinates = $fromCellIt->getCoordinate();
-            $toCellCoordinates = $fromCellIt->getColumn().$to;
+            $toCellCoordinates = $fromCellIt->getColumn() . $to;
             // Cache data as trying to save the cells as variables doesn't work
             $style = $this->getCell($fromCoordinates)->getStyle();
             $value = $this->getCell($fromCoordinates)->getValue();
@@ -3895,7 +3895,7 @@ 
             $toCell = $this->getCell($toCellCoordinates);
             $toCell->setValue($value);
             $toCell->setDataType($dataType);
-            $this->duplicateStyle($style,$toCellCoordinates);
+            $this->duplicateStyle($style, $toCellCoordinates);
           }
         } catch (\Exception $e) {
           unset($e); // Do nothing, the row was empty