PHPOffice / PhpSpreadsheet

tests/data/Calculation/Calculation.php

Spacing +7 added lines, -7 removed lines

@@ -35,13 +35,13 @@
     $set6 = [0, $dataArray3, '=IF(A1+B1>3,C1,0)', 'E5'];
 
     $dataArray4 = [
-        ['noflag',    0, 0],
-        [127000,    0, 0],
-        [10000,  0.03, 0],
-        [20000,  0.06, 0],
-        [40000,  0.09, 0],
-        [70000,  0.12, 0],
-        [90000,  0.03, 0],
+        ['noflag', 0, 0],
+        [127000, 0, 0],
+        [10000, 0.03, 0],
+        [20000, 0.06, 0],
+        [40000, 0.09, 0],
+        [70000, 0.12, 0],
+        [90000, 0.03, 0],
     ];
     $formula2 = '=IF(A1="flag",IF(A2<10, 0) + IF(A3<10000, 0))';
     $set7 = [false, $dataArray4, $formula2, 'E5'];

tests/data/Calculation/MathTrig/MMULT.php

Spacing +3 added lines, -3 removed lines

@@ -17,8 +17,8 @@ 
     ],
     [
         [
-            [30,  36,  42],
-            [66,  81,  96],
+            [30, 36, 42],
+            [66, 81, 96],
             [102, 126, 150],
         ],
         [
@@ -62,7 +62,7 @@ 
     ],
     [
         [
-            [62.00,  49.46],
+            [62.00, 49.46],
             [176.40, 144.50],
         ],
         [

tests/data/Calculation/LookupRef/LOOKUP.php

Spacing +5 added lines, -5 removed lines

@@ -1,7 +1,7 @@ 
 <?php
 
 return [
-    [ // Office reference example #1
+    [// Office reference example #1
         'orange',
         4.19,
         [
@@ -19,7 +19,7 @@ 
             ['blue'],
         ],
     ],
-    [ // Office reference example #2
+    [// Office reference example #2
         'yellow',
         5.75,
         [
@@ -37,7 +37,7 @@ 
             ['blue'],
         ],
     ],
-    [ // Office reference example #3
+    [// Office reference example #3
         'blue',
         7.66,
         [
@@ -55,7 +55,7 @@ 
             ['blue'],
         ],
     ],
-    [ // Office reference example #4
+    [// Office reference example #4
         '#N/A',
         0,
         [
@@ -73,7 +73,7 @@ 
             ['blue'],
         ],
     ],
-    [ // Array form test
+    [// Array form test
         'orange',
         4.2,
         [

tests/data/Calculation/LookupRef/MATCH.php

Spacing +1 added lines, -1 removed lines

@@ -94,7 +94,7 @@
         [8, 8, 3, 2],
         -1,
     ],
-    [ // Default matchtype
+    [// Default matchtype
         4, // Expected
         4, // Input
         [2, 0, 0, 3],

src/PhpSpreadsheet/Writer/Xls/Style/CellFill.php

Spacing +1 added lines, -1 removed lines

@@ -30,7 +30,7 @@
         Fill::FILL_PATTERN_GRAY125 => 0x11,
         Fill::FILL_PATTERN_GRAY0625 => 0x12,
         Fill::FILL_GRADIENT_LINEAR => 0x00, // does not exist in BIFF8
-        Fill::FILL_GRADIENT_PATH => 0x00,   // does not exist in BIFF8
+        Fill::FILL_GRADIENT_PATH => 0x00, // does not exist in BIFF8
     ];
 
     public static function style(Fill $fill): int

src/PhpSpreadsheet/Document/Properties.php

Spacing +26 added lines, -26 removed lines

@@ -457,32 +457,32 @@
     }
 
     private const PROPERTY_TYPE_ARRAY = [
-        'i' => self::PROPERTY_TYPE_INTEGER,      //    Integer
-        'i1' => self::PROPERTY_TYPE_INTEGER,     //    1-Byte Signed Integer
-        'i2' => self::PROPERTY_TYPE_INTEGER,     //    2-Byte Signed Integer
-        'i4' => self::PROPERTY_TYPE_INTEGER,     //    4-Byte Signed Integer
-        'i8' => self::PROPERTY_TYPE_INTEGER,     //    8-Byte Signed Integer
-        'int' => self::PROPERTY_TYPE_INTEGER,    //    Integer
-        'ui1' => self::PROPERTY_TYPE_INTEGER,    //    1-Byte Unsigned Integer
-        'ui2' => self::PROPERTY_TYPE_INTEGER,    //    2-Byte Unsigned Integer
-        'ui4' => self::PROPERTY_TYPE_INTEGER,    //    4-Byte Unsigned Integer
-        'ui8' => self::PROPERTY_TYPE_INTEGER,    //    8-Byte Unsigned Integer
-        'uint' => self::PROPERTY_TYPE_INTEGER,   //    Unsigned Integer
-        'f' => self::PROPERTY_TYPE_FLOAT,        //    Real Number
-        'r4' => self::PROPERTY_TYPE_FLOAT,       //    4-Byte Real Number
-        'r8' => self::PROPERTY_TYPE_FLOAT,       //    8-Byte Real Number
-        'decimal' => self::PROPERTY_TYPE_FLOAT,  //    Decimal
-        's' => self::PROPERTY_TYPE_STRING,       //    String
-        'empty' => self::PROPERTY_TYPE_STRING,   //    Empty
-        'null' => self::PROPERTY_TYPE_STRING,    //    Null
-        'lpstr' => self::PROPERTY_TYPE_STRING,   //    LPSTR
-        'lpwstr' => self::PROPERTY_TYPE_STRING,  //    LPWSTR
-        'bstr' => self::PROPERTY_TYPE_STRING,    //    Basic String
-        'd' => self::PROPERTY_TYPE_DATE,         //    Date and Time
-        'date' => self::PROPERTY_TYPE_DATE,      //    Date and Time
-        'filetime' => self::PROPERTY_TYPE_DATE,  //    File Time
-        'b' => self::PROPERTY_TYPE_BOOLEAN,      //    Boolean
-        'bool' => self::PROPERTY_TYPE_BOOLEAN,   //    Boolean
+        'i' => self::PROPERTY_TYPE_INTEGER, //    Integer
+        'i1' => self::PROPERTY_TYPE_INTEGER, //    1-Byte Signed Integer
+        'i2' => self::PROPERTY_TYPE_INTEGER, //    2-Byte Signed Integer
+        'i4' => self::PROPERTY_TYPE_INTEGER, //    4-Byte Signed Integer
+        'i8' => self::PROPERTY_TYPE_INTEGER, //    8-Byte Signed Integer
+        'int' => self::PROPERTY_TYPE_INTEGER, //    Integer
+        'ui1' => self::PROPERTY_TYPE_INTEGER, //    1-Byte Unsigned Integer
+        'ui2' => self::PROPERTY_TYPE_INTEGER, //    2-Byte Unsigned Integer
+        'ui4' => self::PROPERTY_TYPE_INTEGER, //    4-Byte Unsigned Integer
+        'ui8' => self::PROPERTY_TYPE_INTEGER, //    8-Byte Unsigned Integer
+        'uint' => self::PROPERTY_TYPE_INTEGER, //    Unsigned Integer
+        'f' => self::PROPERTY_TYPE_FLOAT, //    Real Number
+        'r4' => self::PROPERTY_TYPE_FLOAT, //    4-Byte Real Number
+        'r8' => self::PROPERTY_TYPE_FLOAT, //    8-Byte Real Number
+        'decimal' => self::PROPERTY_TYPE_FLOAT, //    Decimal
+        's' => self::PROPERTY_TYPE_STRING, //    String
+        'empty' => self::PROPERTY_TYPE_STRING, //    Empty
+        'null' => self::PROPERTY_TYPE_STRING, //    Null
+        'lpstr' => self::PROPERTY_TYPE_STRING, //    LPSTR
+        'lpwstr' => self::PROPERTY_TYPE_STRING, //    LPWSTR
+        'bstr' => self::PROPERTY_TYPE_STRING, //    Basic String
+        'd' => self::PROPERTY_TYPE_DATE, //    Date and Time
+        'date' => self::PROPERTY_TYPE_DATE, //    Date and Time
+        'filetime' => self::PROPERTY_TYPE_DATE, //    File Time
+        'b' => self::PROPERTY_TYPE_BOOLEAN, //    Boolean
+        'bool' => self::PROPERTY_TYPE_BOOLEAN, //    Boolean
     ];
 
     private const SPECIAL_TYPES = [

tests/data/Cell/SetValueExplicit.php

Spacing +1 added lines, -1 removed lines

@@ -51,7 +51,7 @@
     ],
     [
         -30879.0,
-        '1815-06-15',               // Dates outside the Excel Range should fail really
+        '1815-06-15', // Dates outside the Excel Range should fail really
         DataType::TYPE_ISO_DATE,
     ],
     [

src/PhpSpreadsheet/Worksheet/BaseDrawing.php

Spacing +1 added lines, -2 removed lines

@@ -172,8 +172,7 @@
         // Initialise values
         $this->setShadow();
 
-        // Set image index
-        ++self::$imageCounter;
+        // Set image index++self::$imageCounter;
         $this->imageIndex = self::$imageCounter;
     }
 

src/PhpSpreadsheet/Reader/Slk.php

Spacing +8 added lines, -8 removed lines

@@ -266,7 +266,7 @@ 
         $hasCalculatedValue = true;
     }
 
-    private function processCRecord(array $rowData, Spreadsheet &$spreadsheet, string &$row, string &$column): void
+    private function processCRecord(array $rowData, Spreadsheet & $spreadsheet, string &$row, string &$column): void
     {
         //    Read cell value data
         $hasCalculatedValue = false;
@@ -309,7 +309,7 @@ 
         $this->processCFinal($spreadsheet, $hasCalculatedValue, $cellDataFormula, $cellData, "$columnLetter$row");
     }
 
-    private function processCFinal(Spreadsheet &$spreadsheet, bool $hasCalculatedValue, string $cellDataFormula, string $cellData, string $coordinate): void
+    private function processCFinal(Spreadsheet & $spreadsheet, bool $hasCalculatedValue, string $cellDataFormula, string $cellData, string $coordinate): void
     {
         // Set cell value
         $spreadsheet->getActiveSheet()->getCell($coordinate)->setValue(($hasCalculatedValue) ? $cellDataFormula : $cellData);
@@ -319,7 +319,7 @@ 
         }
     }
 
-    private function processFRecord(array $rowData, Spreadsheet &$spreadsheet, string &$row, string &$column): void
+    private function processFRecord(array $rowData, Spreadsheet & $spreadsheet, string &$row, string &$column): void
     {
         //    Read cell formatting
         $formatStyle = $columnWidth = '';
@@ -387,7 +387,7 @@ 
         }
     }
 
-    private function addFormats(Spreadsheet &$spreadsheet, string $formatStyle, string $row, string $column): void
+    private function addFormats(Spreadsheet & $spreadsheet, string $formatStyle, string $row, string $column): void
     {
         if ($formatStyle && $column > '' && $row > '') {
             $columnLetter = Coordinate::stringFromColumnIndex((int) $column);
@@ -397,7 +397,7 @@ 
         }
     }
 
-    private function addFonts(Spreadsheet &$spreadsheet, string $fontStyle, string $row, string $column): void
+    private function addFonts(Spreadsheet & $spreadsheet, string $fontStyle, string $row, string $column): void
     {
         if ($fontStyle && $column > '' && $row > '') {
             $columnLetter = Coordinate::stringFromColumnIndex((int) $column);
@@ -407,7 +407,7 @@ 
         }
     }
 
-    private function addStyle(Spreadsheet &$spreadsheet, array $styleData, string $row, string $column): void
+    private function addStyle(Spreadsheet & $spreadsheet, array $styleData, string $row, string $column): void
     {
         if ((!empty($styleData)) && $column > '' && $row > '') {
             $columnLetter = Coordinate::stringFromColumnIndex((int) $column);
@@ -432,7 +432,7 @@ 
         }
     }
 
-    private function processPRecord(array $rowData, Spreadsheet &$spreadsheet): void
+    private function processPRecord(array $rowData, Spreadsheet & $spreadsheet): void
     {
         //    Read shared styles
         $formatArray = [];
@@ -485,7 +485,7 @@ 
         }
     }
 
-    private function processPFinal(Spreadsheet &$spreadsheet, array $formatArray): void
+    private function processPFinal(Spreadsheet & $spreadsheet, array $formatArray): void
     {
         if (array_key_exists('numberFormat', $formatArray)) {
             $this->formats['P' . $this->format] = $formatArray;