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/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;
     }
 

tests/PhpSpreadsheetTests/Chart/GridlinesLineStyleTest.php

Spacing +2 added lines, -2 removed lines

@@ -151,7 +151,7 @@ 
             true, // plotVisibleOnly
             DataSeries::EMPTY_AS_GAP, // displayBlanksAs
             null, // xAxisLabel
-            $yAxisLabel,  // yAxisLabel
+            $yAxisLabel, // yAxisLabel
             null, // xAxis
             $yAxis // yAxis
         );
@@ -344,7 +344,7 @@ 
             true, // plotVisibleOnly
             DataSeries::EMPTY_AS_GAP, // displayBlanksAs
             null, // xAxisLabel
-            $yAxisLabel,  // yAxisLabel
+            $yAxisLabel, // yAxisLabel
             null, // xAxis
             null, // yAxis
             $majorGridlines,

tests/PhpSpreadsheetTests/Chart/AxisPropertiesTest.php

Spacing +1 added lines, -1 removed lines

@@ -137,7 +137,7 @@
             true, // plotVisibleOnly
             DataSeries::EMPTY_AS_GAP, // displayBlanksAs
             null, // xAxisLabel
-            $yAxisLabel,  // yAxisLabel
+            $yAxisLabel, // yAxisLabel
             $xAxis, // xAxis
             $yAxis, // yAxis
             null, //majorGridlines,