PHPOffice / PhpSpreadsheet

src/PhpSpreadsheet/Shared/OLE.php

Spacing +1 added lines, -1 removed lines

@@ -266,7 +266,7 @@
     public function _readPpsWks($blockId)
     {
         $fh = $this->getStream($blockId);
-        for ($pos = 0;; $pos += 128) {
+        for ($pos = 0; ; $pos += 128) {
             fseek($fh, $pos, SEEK_SET);
             $nameUtf16 = fread($fh, 64);
             $nameLength = self::_readInt2($fh);

tests/PhpSpreadsheetTests/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/PhpSpreadsheetTests/SampleTest.php

Spacing +1 added lines, -1 removed lines

@@ -12,7 +12,7 @@
     public function testSample($sample)
     {
         // Suppress output to console
-        $this->setOutputCallback(function () {
+        $this->setOutputCallback(function() {
         });
 
         require $sample;

samples/templates/sampleSpreadsheet.php

Spacing +1 added lines, -1 removed lines

@@ -96,7 +96,7 @@
 // Merge cells
 $helper->log('Merge cells');
 $spreadsheet->getActiveSheet()->mergeCells('A18:E22');
-$spreadsheet->getActiveSheet()->mergeCells('A28:B28');  // Just to test...
+$spreadsheet->getActiveSheet()->mergeCells('A28:B28'); // Just to test...
 $spreadsheet->getActiveSheet()->unmergeCells('A28:B28'); // Just to test...
 // Protect cells
 $helper->log('Protect cells');

src/PhpSpreadsheet/Writer/Xls/Font.php

Spacing +5 added lines, -5 removed lines

@@ -85,9 +85,9 @@ 
         $bFamily = 0; // Font family
         $bCharSet = \PHPExcel\Shared\Font::getCharsetFromFontName($this->font->getName()); // Character set
 
-        $record = 0x31;        // Record identifier
-        $reserved = 0x00;    // Reserved
-        $grbit = 0x00;        // Font attributes
+        $record = 0x31; // Record identifier
+        $reserved = 0x00; // Reserved
+        $grbit = 0x00; // Font attributes
         if ($this->font->getItalic()) {
             $grbit |= 0x02;
         }
@@ -134,9 +134,9 @@ 
     private static function mapBold($bold)
     {
         if ($bold) {
-            return 0x2BC;  //  700 = Bold font weight
+            return 0x2BC; //  700 = Bold font weight
         }
-        return 0x190;      //  400 = Normal font weight
+        return 0x190; //  400 = Normal font weight
     }
 
     /**

Documentation/Examples/Calculations/Database/DCOUNT.php

Spacing +10 added lines, -10 removed lines

@@ -30,17 +30,17 @@
 $worksheet = $objPHPExcel->getActiveSheet();
 
 // Add some data
-$database = [['Tree',  'Height', 'Age', 'Yield', 'Profit'],
-                   ['Apple',  18,       20,    14,      105.00],
-                   ['Pear',   12,       12,    10,       96.00],
-                   ['Cherry', 13,       14,     9,      105.00],
-                   ['Apple',  14,       15,    10,       75.00],
-                   ['Pear',    9,        8,     8,       76.80],
-                   ['Apple',   8,        9,     6,       45.00],
+$database = [['Tree', 'Height', 'Age', 'Yield', 'Profit'],
+                   ['Apple', 18, 20, 14, 105.00],
+                   ['Pear', 12, 12, 10, 96.00],
+                   ['Cherry', 13, 14, 9, 105.00],
+                   ['Apple', 14, 15, 10, 75.00],
+                   ['Pear', 9, 8, 8, 76.80],
+                   ['Apple', 8, 9, 6, 45.00],
                  ];
-$criteria = [['Tree',      'Height', 'Age', 'Yield', 'Profit', 'Height'],
-                   ['="=Apple"', '>10',    null,  null,    null,     '<16'],
-                   ['="=Pear"',  null,     null,  null,    null,     null],
+$criteria = [['Tree', 'Height', 'Age', 'Yield', 'Profit', 'Height'],
+                   ['="=Apple"', '>10', null, null, null, '<16'],
+                   ['="=Pear"', null, null, null, null, null],
                  ];
 
 $worksheet->fromArray($criteria, null, 'A1');

Documentation/Examples/Calculations/Database/DVAR.php

Spacing +10 added lines, -10 removed lines

@@ -30,17 +30,17 @@
 $worksheet = $objPHPExcel->getActiveSheet();
 
 // Add some data
-$database = [['Tree',  'Height', 'Age', 'Yield', 'Profit'],
-                   ['Apple',  18,       20,    14,      105.00],
-                   ['Pear',   12,       12,    10,       96.00],
-                   ['Cherry', 13,       14,     9,      105.00],
-                   ['Apple',  14,       15,    10,       75.00],
-                   ['Pear',    9,        8,     8,       76.80],
-                   ['Apple',   8,        9,     6,       45.00],
+$database = [['Tree', 'Height', 'Age', 'Yield', 'Profit'],
+                   ['Apple', 18, 20, 14, 105.00],
+                   ['Pear', 12, 12, 10, 96.00],
+                   ['Cherry', 13, 14, 9, 105.00],
+                   ['Apple', 14, 15, 10, 75.00],
+                   ['Pear', 9, 8, 8, 76.80],
+                   ['Apple', 8, 9, 6, 45.00],
                  ];
-$criteria = [['Tree',      'Height', 'Age', 'Yield', 'Profit', 'Height'],
-                   ['="=Apple"', '>10',    null,  null,    null,     '<16'],
-                   ['="=Pear"',  null,     null,  null,    null,     null],
+$criteria = [['Tree', 'Height', 'Age', 'Yield', 'Profit', 'Height'],
+                   ['="=Apple"', '>10', null, null, null, '<16'],
+                   ['="=Pear"', null, null, null, null, null],
                  ];
 
 $worksheet->fromArray($criteria, null, 'A1');

Documentation/Examples/Calculations/Database/DVARP.php

Spacing +10 added lines, -10 removed lines

@@ -30,17 +30,17 @@
 $worksheet = $objPHPExcel->getActiveSheet();
 
 // Add some data
-$database = [['Tree',  'Height', 'Age', 'Yield', 'Profit'],
-                   ['Apple',  18,       20,    14,      105.00],
-                   ['Pear',   12,       12,    10,       96.00],
-                   ['Cherry', 13,       14,     9,      105.00],
-                   ['Apple',  14,       15,    10,       75.00],
-                   ['Pear',    9,        8,     8,       76.80],
-                   ['Apple',   8,        9,     6,       45.00],
+$database = [['Tree', 'Height', 'Age', 'Yield', 'Profit'],
+                   ['Apple', 18, 20, 14, 105.00],
+                   ['Pear', 12, 12, 10, 96.00],
+                   ['Cherry', 13, 14, 9, 105.00],
+                   ['Apple', 14, 15, 10, 75.00],
+                   ['Pear', 9, 8, 8, 76.80],
+                   ['Apple', 8, 9, 6, 45.00],
                  ];
-$criteria = [['Tree',      'Height', 'Age', 'Yield', 'Profit', 'Height'],
-                   ['="=Apple"', '>10',    null,  null,    null,     '<16'],
-                   ['="=Pear"',  null,     null,  null,    null,     null],
+$criteria = [['Tree', 'Height', 'Age', 'Yield', 'Profit', 'Height'],
+                   ['="=Apple"', '>10', null, null, null, '<16'],
+                   ['="=Pear"', null, null, null, null, null],
                  ];
 
 $worksheet->fromArray($criteria, null, 'A1');

Documentation/Examples/Calculations/Database/DGET.php

Spacing +10 added lines, -10 removed lines

@@ -30,17 +30,17 @@
 $worksheet = $objPHPExcel->getActiveSheet();
 
 // Add some data
-$database = [['Tree',  'Height', 'Age', 'Yield', 'Profit'],
-                   ['Apple',  18,       20,    14,      105.00],
-                   ['Pear',   12,       12,    10,       96.00],
-                   ['Cherry', 13,       14,     9,      105.00],
-                   ['Apple',  14,       15,    10,       75.00],
-                   ['Pear',    9,        8,     8,       76.80],
-                   ['Apple',   8,        9,     6,       45.00],
+$database = [['Tree', 'Height', 'Age', 'Yield', 'Profit'],
+                   ['Apple', 18, 20, 14, 105.00],
+                   ['Pear', 12, 12, 10, 96.00],
+                   ['Cherry', 13, 14, 9, 105.00],
+                   ['Apple', 14, 15, 10, 75.00],
+                   ['Pear', 9, 8, 8, 76.80],
+                   ['Apple', 8, 9, 6, 45.00],
                  ];
-$criteria = [['Tree',      'Height', 'Age', 'Yield', 'Profit', 'Height'],
-                   ['="=Apple"', '>10',    null,  null,    null,     '<16'],
-                   ['="=Pear"',  null,     null,  null,    null,     null],
+$criteria = [['Tree', 'Height', 'Age', 'Yield', 'Profit', 'Height'],
+                   ['="=Apple"', '>10', null, null, null, '<16'],
+                   ['="=Pear"', null, null, null, null, null],
                  ];
 
 $worksheet->fromArray($criteria, null, 'A1');