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/Worksheet.php

Spacing +2 added lines, -2 removed lines

@@ -2948,8 +2948,8 @@
     private function writeCFRule(Conditional $conditional): void
     {
         $record = 0x01B1; // Record identifier
-        $type = null;  //  Type of the CF
-        $operatorType = null;   //  Comparison operator
+        $type = null; //  Type of the CF
+        $operatorType = null; //  Comparison operator
 
         if ($conditional->getConditionType() == Conditional::CONDITION_EXPRESSION) {
             $type = 0x02;

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 = [

src/PhpSpreadsheet/Worksheet/BaseDrawing.php

Spacing +1 added lines, -2 removed lines

@@ -132,8 +132,7 @@
         $this->shadow = new Drawing\Shadow();
         $this->type = IMAGETYPE_UNKNOWN;
 
-        // Set image index
-        ++self::$imageCounter;
+        // Set image index++self::$imageCounter;
         $this->imageIndex = self::$imageCounter;
     }