View GitHub Repository PhpSpreadsheet

Schedule Inspection
Subscribe
Completed
Push — develop ( 93e220...f99eb8 )
by Adrien
22:43
created
Status
Category
Toggle Patches
docs/Examples/Calculations/Database/DCOUNT.php 2 patches
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.
Spacing   +10 added lines, -10 removed lines patch added patch discarded remove patch 
@@ -30,17 +30,17 @@
 
 block discarded – undo
30 30 
 $worksheet = $spreadsheet->getActiveSheet();
31 31
32 32 
 // Add some data
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],
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 40 
                  ];
41 
-$criteria = [['Tree',      'Height', 'Age', 'Yield', 'Profit', 'Height'],
42 
-                   ['="=Apple"', '>10',    null,  null,    null,     '<16'],
43 
-                   ['="=Pear"',  null,     null,  null,    null,     null],
41 
+$criteria = [['Tree', 'Height', 'Age', 'Yield', 'Profit', 'Height'],
42 
+                   ['="=Apple"', '>10', null, null, null, '<16'],
43 
+                   ['="=Pear"', null, null, null, null, null],
44 44 
                  ];
45 45
46 46 
 $worksheet->fromArray($criteria, null, 'A1');
Please login to merge, or discard this patch.
docs/Examples/Calculations/Database/DPRODUCT.php 2 patches
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.
Spacing   +10 added lines, -10 removed lines patch added patch discarded remove patch 
@@ -30,17 +30,17 @@
 
 block discarded – undo
30 30 
 $worksheet = $spreadsheet->getActiveSheet();
31 31
32 32 
 // Add some data
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],
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 40 
                  ];
41 
-$criteria = [['Tree',      'Height', 'Age', 'Yield', 'Profit', 'Height'],
42 
-                   ['="=Apple"', '>10',    null,  null,    null,     '<16'],
43 
-                   ['="=Pear"',  null,     null,  null,    null,     null],
41 
+$criteria = [['Tree', 'Height', 'Age', 'Yield', 'Profit', 'Height'],
42 
+                   ['="=Apple"', '>10', null, null, null, '<16'],
43 
+                   ['="=Pear"', null, null, null, null, null],
44 44 
                  ];
45 45
46 46 
 $worksheet->fromArray($criteria, null, 'A1');
Please login to merge, or discard this patch.
docs/Examples/Calculations/index.php 1 patch
Spacing   +2 added lines, -2 removed lines patch added patch discarded remove patch 
@@ -36,9 +36,9 @@
 
 block discarded – undo
36 36 
             $h1Text = $out[1];
37 37 
             $h2Text = (preg_match($h2Pattern, $fileData, $out)) ? $out[1] : '';
38 38
39 
-            echo '<a href="',$exampleFile,'">',$h1Text,'</a><br />';
39 
+            echo '<a href="', $exampleFile, '">', $h1Text, '</a><br />';
40 40 
             if ($h2Text > '') {
41 
-                echo $h2Text,'<br />';
41 
+                echo $h2Text, '<br />';
42 42 
             }
43 43 
         }
44 44 
     }
Please login to merge, or discard this patch.
src/PhpSpreadsheet/Writer/Xls/Font.php 1 patch
Spacing   +5 added lines, -5 removed lines patch added patch discarded remove patch 
@@ -82,9 +82,9 @@  discard block
 
 block discarded – undo
82 82 
         $bFamily = 0; // Font family
83 83 
         $bCharSet = \PhpOffice\PhpSpreadsheet\Shared\Font::getCharsetFromFontName($this->font->getName()); // Character set
84 84
85 
-        $record = 0x31;        // Record identifier
86 
-        $reserved = 0x00;    // Reserved
87 
-        $grbit = 0x00;        // Font attributes
85 
+        $record = 0x31; // Record identifier
86 
+        $reserved = 0x00; // Reserved
87 
+        $grbit = 0x00; // Font attributes
88 88 
         if ($this->font->getItalic()) {
89 89 
             $grbit |= 0x02;
90 90 
         }
 
@@ -132,10 +132,10 @@  discard block
 
 block discarded – undo
132 132 
     private static function mapBold($bold)
133 133 
     {
134 134 
         if ($bold) {
135 
-            return 0x2BC;  //  700 = Bold font weight
135 
+            return 0x2BC; //  700 = Bold font weight
136 136 
         }
137 137
138 
-        return 0x190;      //  400 = Normal font weight
138 
+        return 0x190; //  400 = Normal font weight
139 139 
     }
140 140
141 141 
     /**
Please login to merge, or discard this patch.
src/PhpSpreadsheet/Chart/DataSeriesValues.php 1 patch
Doc Comments   +2 added lines, -2 removed lines patch added patch discarded remove patch 
@@ -79,10 +79,10 @@
 
 block discarded – undo
79 79 
     /**
80 80 
      * Create a new DataSeriesValues object.
81 81 
      *
82 
-     * @param mixed $dataType
82 
+     * @param string $dataType
83 83 
      * @param string $dataSource
84 84 
      * @param null|mixed $formatCode
85 
-     * @param mixed $pointCount
85 
+     * @param integer $pointCount
86 86 
      * @param mixed $dataValues
87 87 
      * @param null|mixed $marker
88 88 
      */
Please login to merge, or discard this patch.
src/PhpSpreadsheet/Worksheet.php 1 patch
Doc Comments   +10 added lines, -10 removed lines patch added patch discarded remove patch 
@@ -590,7 +590,7 @@  discard block
 
 block discarded – undo
590 590 
      *
591 591 
      * @throws Exception
592 592 
      *
593 
-     * @return false|Chart
593 
+     * @return null|Chart
594 594 
      */
595 595 
     public function getChartByIndex($index = null)
596 596 
     {
 
@@ -1153,7 +1153,7 @@  discard block
 
 block discarded – undo
1153 1153 
      * Set a cell value.
1154 1154 
      *
1155 1155 
      * @param string $pCoordinate Coordinate of the cell
1156 
-     * @param mixed $pValue Value of the cell
1156 
+     * @param string $pValue Value of the cell
1157 1157 
      * @param string $pDataType Explicit data type
1158 1158 
      * @param bool $returnCell Return the worksheet (false, default) or the cell (true)
1159 1159 
      *
 
@@ -1237,8 +1237,8 @@  discard block
 
 block discarded – undo
1237 1237 
     /**
1238 1238 
      * Get cell at a specific coordinate by using numeric cell coordinates.
1239 1239 
      *
1240 
-     * @param string $pColumn Numeric column coordinate of the cell
1241 
-     * @param string $pRow Numeric row coordinate of the cell
1240 
+     * @param integer $pColumn Numeric column coordinate of the cell
1241 
+     * @param integer $pRow Numeric row coordinate of the cell
1242 1242 
      * @param bool $createIfNotExists Flag indicating whether a new cell should be created if it doesn't
1243 1243 
      *                                       already exist, or a null should be returned instead
1244 1244 
      *
 
@@ -1348,8 +1348,8 @@  discard block
 
 block discarded – undo
1348 1348 
     /**
1349 1349 
      * Cell at a specific coordinate by using numeric cell coordinates exists?
1350 1350 
      *
1351 
-     * @param string $pColumn Numeric column coordinate of the cell
1352 
-     * @param string $pRow Numeric row coordinate of the cell
1351 
+     * @param integer $pColumn Numeric column coordinate of the cell
1352 
+     * @param integer $pRow Numeric row coordinate of the cell
1353 1353 
      *
1354 1354 
      * @return bool
1355 1355 
      */
 
@@ -1362,7 +1362,7 @@  discard block
 
 block discarded – undo
1362 1362 
      * Get row dimension at a specific row.
1363 1363 
      *
1364 1364 
      * @param int $pRow Numeric index of the row
1365 
-     * @param mixed $create
1365 
+     * @param boolean $create
1366 1366 
      *
1367 1367 
      * @return Worksheet\RowDimension
1368 1368 
      */
 
@@ -1388,7 +1388,7 @@  discard block
 
 block discarded – undo
1388 1388 
      * Get column dimension at a specific column.
1389 1389 
      *
1390 1390 
      * @param string $pColumn String index of the column
1391 
-     * @param mixed $create
1391 
+     * @param boolean $create
1392 1392 
      *
1393 1393 
      * @return Worksheet\ColumnDimension
1394 1394 
      */
 
@@ -1934,7 +1934,7 @@  discard block
 
 block discarded – undo
1934 1934 
     /**
1935 1935 
      * Set AutoFilter.
1936 1936 
      *
1937 
-     * @param Worksheet\AutoFilter|string $pValue
1937 
+     * @param string $pValue
1938 1938 
      *            A simple string containing a Cell range like 'A1:E10' is permitted for backward compatibility
1939 1939 
      *
1940 1940 
      * @throws Exception
 
@@ -2996,7 +2996,7 @@  discard block
 
 block discarded – undo
2996 2996 
      *
2997 2997 
      * @throws Exception
2998 2998 
      *
2999 
-     * @return objWorksheet
2999 
+     * @return Worksheet
3000 3000 
      */
3001 3001 
     public function setCodeName($pValue = null)
3002 3002 
     {
Please login to merge, or discard this patch.