View GitHub Repository PhpSpreadsheet

Schedule Inspection
Subscribe
Completed
Pull Request — develop (#47)
by
unknown
10:56
created
Status
Category
Toggle Patches
docs/Examples/Calculations/Database/DVAR.php 1 patch
Indentation   +10 added lines, -10 removed lines patch added patch discarded remove patch 
@@ -31,17 +31,17 @@
 
 block discarded – undo
31 31
32 32 
 // Add some data
33 33 
 $database = [['Tree',  'Height', 'Age', 'Yield', 'Profit'],
34 
-                   ['Apple',  18,       20,    14,      105.00],
35 
-                   ['Pear',   12,       12,    10,       96.00],
36 
-                   ['Cherry', 13,       14,     9,      105.00],
37 
-                   ['Apple',  14,       15,    10,       75.00],
38 
-                   ['Pear',    9,        8,     8,       76.80],
39 
-                   ['Apple',   8,        9,     6,       45.00],
40 
-                 ];
34 
+                    ['Apple',  18,       20,    14,      105.00],
35 
+                    ['Pear',   12,       12,    10,       96.00],
36 
+                    ['Cherry', 13,       14,     9,      105.00],
37 
+                    ['Apple',  14,       15,    10,       75.00],
38 
+                    ['Pear',    9,        8,     8,       76.80],
39 
+                    ['Apple',   8,        9,     6,       45.00],
40 
+                    ];
41 41 
 $criteria = [['Tree',      'Height', 'Age', 'Yield', 'Profit', 'Height'],
42 
-                   ['="=Apple"', '>10',    null,  null,    null,     '<16'],
43 
-                   ['="=Pear"',  null,     null,  null,    null,     null],
44 
-                 ];
42 
+                    ['="=Apple"', '>10',    null,  null,    null,     '<16'],
43 
+                    ['="=Pear"',  null,     null,  null,    null,     null],
44 
+                    ];
45 45
46 46 
 $worksheet->fromArray($criteria, null, 'A1');
47 47 
 $worksheet->fromArray($database, null, 'A4');
Please login to merge, or discard this patch.
docs/Examples/Calculations/Database/DMAX.php 1 patch
Indentation   +10 added lines, -10 removed lines patch added patch discarded remove patch 
@@ -31,17 +31,17 @@
 
 block discarded – undo
31 31
32 32 
 // Add some data
33 33 
 $database = [['Tree',  'Height', 'Age', 'Yield', 'Profit'],
34 
-                   ['Apple',  18,       20,    14,      105.00],
35 
-                   ['Pear',   12,       12,    10,       96.00],
36 
-                   ['Cherry', 13,       14,     9,      105.00],
37 
-                   ['Apple',  14,       15,    10,       75.00],
38 
-                   ['Pear',    9,        8,     8,       76.80],
39 
-                   ['Apple',   8,        9,     6,       45.00],
40 
-                 ];
34 
+                    ['Apple',  18,       20,    14,      105.00],
35 
+                    ['Pear',   12,       12,    10,       96.00],
36 
+                    ['Cherry', 13,       14,     9,      105.00],
37 
+                    ['Apple',  14,       15,    10,       75.00],
38 
+                    ['Pear',    9,        8,     8,       76.80],
39 
+                    ['Apple',   8,        9,     6,       45.00],
40 
+                    ];
41 41 
 $criteria = [['Tree',      'Height', 'Age', 'Yield', 'Profit', 'Height'],
42 
-                   ['="=Apple"', '>10',    null,  null,    null,     '<16'],
43 
-                   ['="=Pear"',  null,     null,  null,    null,     null],
44 
-                 ];
42 
+                    ['="=Apple"', '>10',    null,  null,    null,     '<16'],
43 
+                    ['="=Pear"',  null,     null,  null,    null,     null],
44 
+                    ];
45 45
46 46 
 $worksheet->fromArray($criteria, null, 'A1');
47 47 
 $worksheet->fromArray($database, null, 'A4');
Please login to merge, or discard this patch.
docs/Examples/Calculations/Database/DCOUNT.php 1 patch
Indentation   +10 added lines, -10 removed lines patch added patch discarded remove patch 
@@ -31,17 +31,17 @@
 
 block discarded – undo
31 31
32 32 
 // Add some data
33 33 
 $database = [['Tree',  'Height', 'Age', 'Yield', 'Profit'],
34 
-                   ['Apple',  18,       20,    14,      105.00],
35 
-                   ['Pear',   12,       12,    10,       96.00],
36 
-                   ['Cherry', 13,       14,     9,      105.00],
37 
-                   ['Apple',  14,       15,    10,       75.00],
38 
-                   ['Pear',    9,        8,     8,       76.80],
39 
-                   ['Apple',   8,        9,     6,       45.00],
40 
-                 ];
34 
+                    ['Apple',  18,       20,    14,      105.00],
35 
+                    ['Pear',   12,       12,    10,       96.00],
36 
+                    ['Cherry', 13,       14,     9,      105.00],
37 
+                    ['Apple',  14,       15,    10,       75.00],
38 
+                    ['Pear',    9,        8,     8,       76.80],
39 
+                    ['Apple',   8,        9,     6,       45.00],
40 
+                    ];
41 41 
 $criteria = [['Tree',      'Height', 'Age', 'Yield', 'Profit', 'Height'],
42 
-                   ['="=Apple"', '>10',    null,  null,    null,     '<16'],
43 
-                   ['="=Pear"',  null,     null,  null,    null,     null],
44 
-                 ];
42 
+                    ['="=Apple"', '>10',    null,  null,    null,     '<16'],
43 
+                    ['="=Pear"',  null,     null,  null,    null,     null],
44 
+                    ];
45 45
46 46 
 $worksheet->fromArray($criteria, null, 'A1');
47 47 
 $worksheet->fromArray($database, null, 'A4');
Please login to merge, or discard this patch.
docs/Examples/Calculations/DateTime/TIME.php 1 patch
Indentation   +3 added lines, -3 removed lines patch added patch discarded remove patch 
@@ -31,7 +31,7 @@  discard block
 
 block discarded – undo
31 31
32 32 
 // Add some data
33 33 
 $testDates = ['3:15',    '13:15',    '15:15:15',    '3:15 AM',    '3:15 PM',    '5PM',    '9:15AM',    '13:15AM',
34 
-                  ];
34 
+                    ];
35 35 
 $testDateCount = count($testDates);
36 36
37 37 
 for ($row = 1; $row <= $testDateCount; ++$row) {
 
@@ -41,8 +41,8 @@  discard block
 
 block discarded – undo
41 41 
 }
42 42
43 43 
 $worksheet->getStyle('C1:C' . $testDateCount)
44 
-          ->getNumberFormat()
45 
-          ->setFormatCode('hh:mm:ss');
44 
+            ->getNumberFormat()
45 
+            ->setFormatCode('hh:mm:ss');
46 46
47 47 
 echo '<hr />';
48 48
Please login to merge, or discard this patch.
docs/Examples/Calculations/DateTime/DATEVALUE.php 1 patch
Indentation   +3 added lines, -3 removed lines patch added patch discarded remove patch 
@@ -35,7 +35,7 @@  discard block
 
 block discarded – undo
35 35 
                     [2011, 2, 29],    [7, 5, 3],        [2012, 13, 1],    [2012, 11, 45],
36 36 
                     [2012, 0, 0],    [2012, 1, 0],    [2012, 0, 1],
37 37 
                     [2012, -2, 2],    [2012, 2, -2],    [2012, -2, -2],
38 
-                  ];
38 
+                    ];
39 39 
 $testDateCount = count($testDates);
40 40
41 41 
 $worksheet->fromArray($testDates, null, 'A1', true);
 
@@ -45,8 +45,8 @@  discard block
 
 block discarded – undo
45 45 
     $worksheet->setCellValue('E' . $row, '=D' . $row);
46 46 
 }
47 47 
 $worksheet->getStyle('E1:E' . $testDateCount)
48 
-          ->getNumberFormat()
49 
-          ->setFormatCode('yyyy-mmm-dd');
48 
+            ->getNumberFormat()
49 
+            ->setFormatCode('yyyy-mmm-dd');
50 50
51 51 
 echo '<hr />';
52 52
Please login to merge, or discard this patch.
src/PhpSpreadsheet/Writer/Xls/Worksheet.php 1 patch
Indentation   +8 added lines, -8 removed lines patch added patch discarded remove patch 
@@ -1171,14 +1171,14 @@
 
 block discarded – undo
1171 1171
1172 1172 
         // Pack the main data stream
1173 1173 
         $data = pack('vvvv', $row1, $row2, $col1, $col2).
1174 
-                          $unknown1.
1175 
-                          $link_type.
1176 
-                          $unknown2.
1177 
-                          $up_count.
1178 
-                          $dir_short_len.
1179 
-                          $dir_short.
1180 
-                          $unknown3.
1181 
-                          $stream_len; /*.
1174 
+                            $unknown1.
1175 
+                            $link_type.
1176 
+                            $unknown2.
1177 
+                            $up_count.
1178 
+                            $dir_short_len.
1179 
+                            $dir_short.
1180 
+                            $unknown3.
1181 
+                            $stream_len; /*.
1182 1182 
                           $dir_long_len .
1183 1183 
                           $unknown4     .
1184 1184 
                           $dir_long     .
Please login to merge, or discard this patch.
src/PhpSpreadsheet/Shared/OLE/PPS.php 1 patch
Indentation   +15 added lines, -15 removed lines patch added patch discarded remove patch 
@@ -177,21 +177,21 @@
 
 block discarded – undo
177 177 
         $ret = str_pad($this->Name, 64, "\x00");
178 178
179 179 
         $ret .= pack('v', strlen($this->Name) + 2)  // 66
180 
-              .pack('c', $this->Type)              // 67
181 
-              .pack('c', 0x00) //UK                // 68
182 
-              .pack('V', $this->PrevPps) //Prev    // 72
183 
-              .pack('V', $this->NextPps) //Next    // 76
184 
-              .pack('V', $this->DirPps)  //Dir     // 80
185 
-              ."\x00\x09\x02\x00"                  // 84
186 
-              ."\x00\x00\x00\x00"                  // 88
187 
-              ."\xc0\x00\x00\x00"                  // 92
188 
-              ."\x00\x00\x00\x46"                  // 96 // Seems to be ok only for Root
189 
-              ."\x00\x00\x00\x00"                  // 100
190 
-              .\PhpOffice\PhpSpreadsheet\Shared\OLE::localDateToOLE($this->Time1st)          // 108
191 
-              .\PhpOffice\PhpSpreadsheet\Shared\OLE::localDateToOLE($this->Time2nd)          // 116
192 
-              .pack('V', isset($this->startBlock) ? $this->startBlock : 0)  // 120
193 
-              .pack('V', $this->Size)               // 124
194 
-              .pack('V', 0); // 128
180 
+                .pack('c', $this->Type)              // 67
181 
+                .pack('c', 0x00) //UK                // 68
182 
+                .pack('V', $this->PrevPps) //Prev    // 72
183 
+                .pack('V', $this->NextPps) //Next    // 76
184 
+                .pack('V', $this->DirPps)  //Dir     // 80
185 
+                ."\x00\x09\x02\x00"                  // 84
186 
+                ."\x00\x00\x00\x00"                  // 88
187 
+                ."\xc0\x00\x00\x00"                  // 92
188 
+                ."\x00\x00\x00\x46"                  // 96 // Seems to be ok only for Root
189 
+                ."\x00\x00\x00\x00"                  // 100
190 
+                .\PhpOffice\PhpSpreadsheet\Shared\OLE::localDateToOLE($this->Time1st)          // 108
191 
+                .\PhpOffice\PhpSpreadsheet\Shared\OLE::localDateToOLE($this->Time2nd)          // 116
192 
+                .pack('V', isset($this->startBlock) ? $this->startBlock : 0)  // 120
193 
+                .pack('V', $this->Size)               // 124
194 
+                .pack('V', 0); // 128
195 195 
         return $ret;
196 196 
     }
197 197
Please login to merge, or discard this patch.