PHPOffice / PhpSpreadsheet

src/PhpSpreadsheet/Reader/SYLK.php

Spacing +2 added lines, -2 removed lines

@@ -219,8 +219,8 @@
         }
         $spreadsheet->setActiveSheetIndex($this->sheetIndex);
 
-        $fromFormats = ['\-',    '\ '];
-        $toFormats = ['-',    ' '];
+        $fromFormats = ['\-', '\ '];
+        $toFormats = ['-', ' '];
 
         // Loop through file
         $rowData = [];

src/PhpSpreadsheet/Reader/OOCalc.php

Spacing +4 added lines, -4 removed lines

@@ -626,10 +626,10 @@
                                     foreach ($temp as &$value) {
                                         //    Only replace in alternate array entries (i.e. non-quoted blocks)
                                         if ($tKey = !$tKey) {
-                                            $value = preg_replace('/\[([^\.]+)\.([^\.]+):\.([^\.]+)\]/Ui', '$1!$2:$3', $value);    //  Cell range reference in another sheet
-                                            $value = preg_replace('/\[([^\.]+)\.([^\.]+)\]/Ui', '$1!$2', $value);       //  Cell reference in another sheet
-                                            $value = preg_replace('/\[\.([^\.]+):\.([^\.]+)\]/Ui', '$1:$2', $value);    //  Cell range reference
-                                            $value = preg_replace('/\[\.([^\.]+)\]/Ui', '$1', $value);                  //  Simple cell reference
+                                            $value = preg_replace('/\[([^\.]+)\.([^\.]+):\.([^\.]+)\]/Ui', '$1!$2:$3', $value); //  Cell range reference in another sheet
+                                            $value = preg_replace('/\[([^\.]+)\.([^\.]+)\]/Ui', '$1!$2', $value); //  Cell reference in another sheet
+                                            $value = preg_replace('/\[\.([^\.]+):\.([^\.]+)\]/Ui', '$1:$2', $value); //  Cell range reference
+                                            $value = preg_replace('/\[\.([^\.]+)\]/Ui', '$1', $value); //  Simple cell reference
                                             $value = \PhpSpreadsheet\Calculation::translateSeparator(';', ',', $value, $inBraces);
                                         }
                                     }

src/PhpSpreadsheet/Shared/Excel5.php

Spacing +2 added lines, -2 removed lines

@@ -233,8 +233,8 @@
         $y1 = $offsetY;
 
         // Initialise end cell to the same as the start cell
-        $col_end = $col_start;  // Col containing lower right corner of object
-        $row_end = $row_start;  // Row containing bottom right corner of object
+        $col_end = $col_start; // Col containing lower right corner of object
+        $row_end = $row_start; // Row containing bottom right corner of object
 
         // Zero the specified offset if greater than the cell dimensions
         if ($x1 >= self::sizeCol($sheet, \PhpSpreadsheet\Cell::stringFromColumnIndex($col_start))) {

src/PhpSpreadsheet/Shared/PasswordHasher.php

Spacing +4 added lines, -4 removed lines

@@ -41,14 +41,14 @@
     public static function hashPassword($pPassword = '')
     {
         $password = 0x0000;
-        $charPos = 1;       // char position
+        $charPos = 1; // char position
 
         // split the plain text password in its component characters
         $chars = preg_split('//', $pPassword, -1, PREG_SPLIT_NO_EMPTY);
         foreach ($chars as $char) {
-            $value = ord($char) << $charPos++;    // shifted ASCII value
-            $rotated_bits = $value >> 15;                // rotated bits beyond bit 15
-            $value &= 0x7fff;                    // first 15 bits
+            $value = ord($char) << $charPos++; // shifted ASCII value
+            $rotated_bits = $value >> 15; // rotated bits beyond bit 15
+            $value &= 0x7fff; // first 15 bits
             $password ^= ($value | $rotated_bits);
         }
 

src/PhpSpreadsheet/Shared/OLE/PPS.php

Indentation +15 added lines, -15 removed lines

@@ -170,21 +170,21 @@
         $ret = str_pad($this->Name, 64, "\x00");
 
         $ret .= pack('v', strlen($this->Name) + 2)  // 66
-              . pack('c', $this->Type)              // 67
-              . pack('c', 0x00) //UK                // 68
-              . pack('V', $this->PrevPps) //Prev    // 72
-              . pack('V', $this->NextPps) //Next    // 76
-              . pack('V', $this->DirPps)  //Dir     // 80
-              . "\x00\x09\x02\x00"                  // 84
-              . "\x00\x00\x00\x00"                  // 88
-              . "\xc0\x00\x00\x00"                  // 92
-              . "\x00\x00\x00\x46"                  // 96 // Seems to be ok only for Root
-              . "\x00\x00\x00\x00"                  // 100
-              . \PhpSpreadsheet\Shared\OLE::localDateToOLE($this->Time1st)          // 108
-              . \PhpSpreadsheet\Shared\OLE::localDateToOLE($this->Time2nd)          // 116
-              . pack('V', isset($this->startBlock) ? $this->startBlock : 0)  // 120
-              . pack('V', $this->Size)               // 124
-              . pack('V', 0);                        // 128
+                . pack('c', $this->Type)              // 67
+                . pack('c', 0x00) //UK                // 68
+                . pack('V', $this->PrevPps) //Prev    // 72
+                . pack('V', $this->NextPps) //Next    // 76
+                . pack('V', $this->DirPps)  //Dir     // 80
+                . "\x00\x09\x02\x00"                  // 84
+                . "\x00\x00\x00\x00"                  // 88
+                . "\xc0\x00\x00\x00"                  // 92
+                . "\x00\x00\x00\x46"                  // 96 // Seems to be ok only for Root
+                . "\x00\x00\x00\x00"                  // 100
+                . \PhpSpreadsheet\Shared\OLE::localDateToOLE($this->Time1st)          // 108
+                . \PhpSpreadsheet\Shared\OLE::localDateToOLE($this->Time2nd)          // 116
+                . pack('V', isset($this->startBlock) ? $this->startBlock : 0)  // 120
+                . pack('V', $this->Size)               // 124
+                . pack('V', 0);                        // 128
         return $ret;
     }
 

Spacing +1 added lines, -1 removed lines

@@ -184,7 +184,7 @@
               . \PhpSpreadsheet\Shared\OLE::localDateToOLE($this->Time2nd)          // 116
               . pack('V', isset($this->startBlock) ? $this->startBlock : 0)  // 120
               . pack('V', $this->Size)               // 124
-              . pack('V', 0);                        // 128
+              . pack('V', 0); // 128
         return $ret;
     }
 

src/PhpSpreadsheet/Worksheet/BaseDrawing.php

Spacing +1 added lines, -2 removed lines

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

tests/PhpSpreadsheet/Shared/StringTest.php

Spacing +1 added lines, -1 removed lines

@@ -65,7 +65,7 @@
     public function testGetCurrencyCode()
     {
         $localeconv = localeconv();
-        $expectedResult = (!empty($localeconv['currency_symbol']) ? $localeconv['currency_symbol'] : (!empty($localeconv['int_curr_symbol']) ? $localeconv['int_curr_symbol']: '$'));
+        $expectedResult = (!empty($localeconv['currency_symbol']) ? $localeconv['currency_symbol'] : (!empty($localeconv['int_curr_symbol']) ? $localeconv['int_curr_symbol'] : '$'));
         $result = call_user_func([StringHelper::class, 'getCurrencyCode']);
         $this->assertEquals($expectedResult, $result);
     }

tests/PhpSpreadsheet/Worksheet/AutoFilter/ColumnTest.php

Indentation +4 added lines, -4 removed lines

@@ -113,7 +113,7 @@ 
     {
         $attributeSet = ['val' => 100,
                                 'maxVal' => 200,
-                             ];
+                                ];
 
         //    Setters return the instance to implement the fluent interface
         $result = $this->testAutoFilterColumnObject->setAttributes($attributeSet);
@@ -124,7 +124,7 @@ 
     {
         $attributeSet = ['val' => 100,
                                 'maxVal' => 200,
-                             ];
+                                ];
 
         $this->testAutoFilterColumnObject->setAttributes($attributeSet);
 
@@ -137,7 +137,7 @@ 
     {
         $attributeSet = ['val' => 100,
                                 'maxVal' => 200,
-                             ];
+                                ];
 
         foreach ($attributeSet as $attributeName => $attributeValue) {
             //    Setters return the instance to implement the fluent interface
@@ -150,7 +150,7 @@ 
     {
         $attributeSet = ['val' => 100,
                                 'maxVal' => 200,
-                             ];
+                                ];
 
         $this->testAutoFilterColumnObject->setAttributes($attributeSet);
 

tests/data/Shared/Date/TimestampToExcel1900.php

Spacing +11 added lines, -11 removed lines

@@ -2,15 +2,15 @@
 
 // Unix TimeStamp   Result           Comments
 return [
-    [-2147472000,  714],    //  PHP 32-bit Earliest Date        14-Dec-1901
-    [-2082931200,  1461],    //                                  31-Dec-1903
-    [-2082844800,  1462],    //  Excel 1904 Calendar Base Date   01-Jan-1904
-    [-2082758400,  1463],    //                                  02-Jan-1904
-    [-285120000,   22269],    //                                  19-Dec-1960
-    [0,            25569],    //  PHP Base Date                   01-Jan-1970
-    [408067200,    30292],    //                                  07-Dec-1982
-    [1213228800,   39611],    //                                  12-Jun-2008
-    [2147472000,   50424],    //  PHP 32-bit Latest Date          19-Jan-2038
-    [-2102494934,  1234.56789],    //                                  18-May-1903 13:37:46
-    [-1142494943,  12345.6789],    //                                  18-Oct-1933 16:17:37
+    [-2147472000, 714], //  PHP 32-bit Earliest Date        14-Dec-1901
+    [-2082931200, 1461], //                                  31-Dec-1903
+    [-2082844800, 1462], //  Excel 1904 Calendar Base Date   01-Jan-1904
+    [-2082758400, 1463], //                                  02-Jan-1904
+    [-285120000, 22269], //                                  19-Dec-1960
+    [0, 25569], //  PHP Base Date                   01-Jan-1970
+    [408067200, 30292], //                                  07-Dec-1982
+    [1213228800, 39611], //                                  12-Jun-2008
+    [2147472000, 50424], //  PHP 32-bit Latest Date          19-Jan-2038
+    [-2102494934, 1234.56789], //                                  18-May-1903 13:37:46
+    [-1142494943, 12345.6789], //                                  18-Oct-1933 16:17:37
 ];