@@ -136,6 +136,11 @@ discard block |
||
136 | 136 | return (string) 100 - $alpha . '000'; |
137 | 137 | } |
138 | 138 | |
139 | + /** |
|
140 | + * @param string $color |
|
141 | + * @param integer $alpha |
|
142 | + * @param string $type |
|
143 | + */ |
|
139 | 144 | protected function setColorProperties($color, $alpha, $type) |
140 | 145 | { |
141 | 146 | return [ |
@@ -145,6 +150,9 @@ discard block |
||
145 | 150 | ]; |
146 | 151 | } |
147 | 152 | |
153 | + /** |
|
154 | + * @param string $array_kay_selector |
|
155 | + */ |
|
148 | 156 | protected function getLineStyleArrowSize($array_selector, $array_kay_selector) |
149 | 157 | { |
150 | 158 | $sizes = [ |
@@ -162,6 +170,9 @@ discard block |
||
162 | 170 | return $sizes[$array_selector][$array_kay_selector]; |
163 | 171 | } |
164 | 172 | |
173 | + /** |
|
174 | + * @param integer $shadow_presets_option |
|
175 | + */ |
|
165 | 176 | protected function getShadowPresetsMap($shadow_presets_option) |
166 | 177 | { |
167 | 178 | $presets_options = [ |
@@ -316,6 +316,10 @@ |
||
316 | 316 | return $this->yBestFitValues; |
317 | 317 | } |
318 | 318 | |
319 | + /** |
|
320 | + * @param double $sumY2 |
|
321 | + * @param boolean $const |
|
322 | + */ |
|
319 | 323 | protected function calculateGoodnessOfFit($sumX, $sumY, $sumX2, $sumY2, $sumXY, $meanX, $meanY, $const) |
320 | 324 | { |
321 | 325 | $SSres = $SScov = $SScor = $SStot = $SSsex = 0.0; |
@@ -567,6 +567,11 @@ |
||
567 | 567 | return ['method' => 'filterTestInCustomDataSet', 'arguments' => ['filterRules' => $ruleValues, 'join' => AutoFilter\Column::AUTOFILTER_COLUMN_JOIN_AND]]; |
568 | 568 | } |
569 | 569 | |
570 | + /** |
|
571 | + * @param integer $columnID |
|
572 | + * @param integer $startRow |
|
573 | + * @param string $ruleType |
|
574 | + */ |
|
570 | 575 | private function calculateTopTenValue($columnID, $startRow, $endRow, $ruleType, $ruleValue) |
571 | 576 | { |
572 | 577 | $range = $columnID . $startRow . ':' . $columnID . $endRow; |
@@ -140,8 +140,8 @@ |
||
140 | 140 | } |
141 | 141 | |
142 | 142 | $hashTablesArray = ['stylesConditionalHashTable', 'fillHashTable', 'fontHashTable', |
143 | - 'bordersHashTable', 'numFmtHashTable', 'drawingHashTable', |
|
144 | - 'styleHashTable', |
|
143 | + 'bordersHashTable', 'numFmtHashTable', 'drawingHashTable', |
|
144 | + 'styleHashTable', |
|
145 | 145 | ]; |
146 | 146 | |
147 | 147 | // Set HashTable variables |
@@ -1147,14 +1147,14 @@ |
||
1147 | 1147 | |
1148 | 1148 | // Pack the main data stream |
1149 | 1149 | $data = pack('vvvv', $row1, $row2, $col1, $col2) . |
1150 | - $unknown1 . |
|
1151 | - $link_type . |
|
1152 | - $unknown2 . |
|
1153 | - $up_count . |
|
1154 | - $dir_short_len . |
|
1155 | - $dir_short . |
|
1156 | - $unknown3 . |
|
1157 | - $stream_len; /*. |
|
1150 | + $unknown1 . |
|
1151 | + $link_type . |
|
1152 | + $unknown2 . |
|
1153 | + $up_count . |
|
1154 | + $dir_short_len . |
|
1155 | + $dir_short . |
|
1156 | + $unknown3 . |
|
1157 | + $stream_len; /*. |
|
1158 | 1158 | $dir_long_len . |
1159 | 1159 | $unknown4 . |
1160 | 1160 | $dir_long . |
@@ -223,10 +223,12 @@ discard block |
||
223 | 223 | * @param int &$str_unique Total number of unique strings |
224 | 224 | * @param array &$str_table String Table |
225 | 225 | * @param array &$colors Colour Table |
226 | - * @param mixed $parser The formula parser created for the Workbook |
|
226 | + * @param Parser $parser The formula parser created for the Workbook |
|
227 | 227 | * @param bool $preCalculateFormulas Flag indicating whether formulas should be calculated or just written |
228 | 228 | * @param string $phpSheet The worksheet to write |
229 | 229 | * @param \PhpOffice\PhpSpreadsheet\Worksheet $phpSheet |
230 | + * @param integer $str_total |
|
231 | + * @param integer $str_unique |
|
230 | 232 | */ |
231 | 233 | public function __construct(&$str_total, &$str_unique, &$str_table, &$colors, $parser, $preCalculateFormulas, $phpSheet) |
232 | 234 | { |
@@ -624,7 +626,7 @@ discard block |
||
624 | 626 | * @param int $row Zero indexed row |
625 | 627 | * @param int $col Zero indexed column |
626 | 628 | * @param float $num The number to write |
627 | - * @param mixed $xfIndex The optional XF format |
|
629 | + * @param integer $xfIndex The optional XF format |
|
628 | 630 | * |
629 | 631 | * @return int |
630 | 632 | */ |
@@ -733,7 +735,7 @@ discard block |
||
733 | 735 | * @param int $row Zero indexed row |
734 | 736 | * @param int $col Zero indexed column |
735 | 737 | * @param string $str The string to write |
736 | - * @param mixed $xfIndex The XF format index for the cell |
|
738 | + * @param integer $xfIndex The XF format index for the cell |
|
737 | 739 | * |
738 | 740 | * @return int |
739 | 741 | */ |
@@ -800,7 +802,7 @@ discard block |
||
800 | 802 | * |
801 | 803 | * @param int $row Zero indexed row |
802 | 804 | * @param int $col Zero indexed column |
803 | - * @param mixed $xfIndex The XF format index |
|
805 | + * @param integer $xfIndex The XF format index |
|
804 | 806 | */ |
805 | 807 | public function writeBlank($row, $col, $xfIndex) |
806 | 808 | { |
@@ -847,7 +849,7 @@ discard block |
||
847 | 849 | * @param int $row Zero indexed row |
848 | 850 | * @param int $col Zero indexed column |
849 | 851 | * @param string $formula The formula text string |
850 | - * @param mixed $xfIndex The XF format index |
|
852 | + * @param integer $xfIndex The XF format index |
|
851 | 853 | * @param mixed $calculatedValue Calculated value |
852 | 854 | * |
853 | 855 | * @return int |
@@ -2327,8 +2329,8 @@ discard block |
||
2327 | 2329 | * @param mixed $bitmap The bitmap filename or GD-image resource |
2328 | 2330 | * @param int $x the horizontal position (offset) of the image inside the cell |
2329 | 2331 | * @param int $y the vertical position (offset) of the image inside the cell |
2330 | - * @param float $scale_x The horizontal scale |
|
2331 | - * @param float $scale_y The vertical scale |
|
2332 | + * @param integer $scale_x The horizontal scale |
|
2333 | + * @param integer $scale_y The vertical scale |
|
2332 | 2334 | */ |
2333 | 2335 | public function insertBitmap($row, $col, $bitmap, $x = 0, $y = 0, $scale_x = 1, $scale_y = 1) |
2334 | 2336 | { |
@@ -33,7 +33,7 @@ discard block |
||
33 | 33 | $testDates = [[3, 15], [13, 15], [15, 15, 15], [3, 15, 30], |
34 | 34 | [15, 15, 15], [5], [9, 15, 0], [9, 15, -1], |
35 | 35 | [13, -14, -15], [0, 0, -1], |
36 | - ]; |
|
36 | + ]; |
|
37 | 37 | $testDateCount = count($testDates); |
38 | 38 | |
39 | 39 | $worksheet->fromArray($testDates, null, 'A1', true); |
@@ -43,8 +43,8 @@ discard block |
||
43 | 43 | $worksheet->setCellValue('E' . $row, '=D' . $row); |
44 | 44 | } |
45 | 45 | $worksheet->getStyle('E1:E' . $testDateCount) |
46 | - ->getNumberFormat() |
|
47 | - ->setFormatCode('hh:mm:ss'); |
|
46 | + ->getNumberFormat() |
|
47 | + ->setFormatCode('hh:mm:ss'); |
|
48 | 48 | |
49 | 49 | echo '<hr />'; |
50 | 50 |
@@ -30,9 +30,9 @@ |
||
30 | 30 | $worksheet = $spreadsheet->getActiveSheet(); |
31 | 31 | |
32 | 32 | // Add some data |
33 | -$testDates = [[3, 15], [13, 15], [15, 15, 15], [3, 15, 30], |
|
34 | - [15, 15, 15], [5], [9, 15, 0], [9, 15, -1], |
|
35 | - [13, -14, -15], [0, 0, -1], |
|
33 | +$testDates = [[3, 15], [13, 15], [15, 15, 15], [3, 15, 30], |
|
34 | + [15, 15, 15], [5], [9, 15, 0], [9, 15, -1], |
|
35 | + [13, -14, -15], [0, 0, -1], |
|
36 | 36 | ]; |
37 | 37 | $testDateCount = count($testDates); |
38 | 38 |
@@ -34,7 +34,7 @@ discard block |
||
34 | 34 | '2012-Oct-31', '5th November', 'January 1st', 'April 2012', |
35 | 35 | '17-03', '03-2012', '29 Feb 2011', '03-05-07', |
36 | 36 | '03-MAY-07', '03-13-07', |
37 | - ]; |
|
37 | + ]; |
|
38 | 38 | $testDateCount = count($testDates); |
39 | 39 | |
40 | 40 | for ($row = 1; $row <= $testDateCount; ++$row) { |
@@ -44,8 +44,8 @@ discard block |
||
44 | 44 | } |
45 | 45 | |
46 | 46 | $worksheet->getStyle('C1:C' . $testDateCount) |
47 | - ->getNumberFormat() |
|
48 | - ->setFormatCode('yyyy-mmm-dd'); |
|
47 | + ->getNumberFormat() |
|
48 | + ->setFormatCode('yyyy-mmm-dd'); |
|
49 | 49 | |
50 | 50 | echo '<hr />'; |
51 | 51 |
@@ -30,10 +30,10 @@ |
||
30 | 30 | $worksheet = $spreadsheet->getActiveSheet(); |
31 | 31 | |
32 | 32 | // Add some data |
33 | -$testDates = ['26 March 2012', '29 Feb 2012', 'April 1, 2012', '25/12/2012', |
|
34 | - '2012-Oct-31', '5th November', 'January 1st', 'April 2012', |
|
35 | - '17-03', '03-2012', '29 Feb 2011', '03-05-07', |
|
36 | - '03-MAY-07', '03-13-07', |
|
33 | +$testDates = ['26 March 2012', '29 Feb 2012', 'April 1, 2012', '25/12/2012', |
|
34 | + '2012-Oct-31', '5th November', 'January 1st', 'April 2012', |
|
35 | + '17-03', '03-2012', '29 Feb 2011', '03-05-07', |
|
36 | + '03-MAY-07', '03-13-07', |
|
37 | 37 | ]; |
38 | 38 | $testDateCount = count($testDates); |
39 | 39 |
@@ -31,7 +31,7 @@ discard block |
||
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 |
||
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 |
@@ -30,7 +30,7 @@ |
||
30 | 30 | $worksheet = $spreadsheet->getActiveSheet(); |
31 | 31 | |
32 | 32 | // Add some data |
33 | -$testDates = ['3:15', '13:15', '15:15:15', '3:15 AM', '3:15 PM', '5PM', '9:15AM', '13:15AM', |
|
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 |
@@ -35,7 +35,7 @@ discard block |
||
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 |
||
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 |
@@ -30,11 +30,11 @@ |
||
30 | 30 | $worksheet = $spreadsheet->getActiveSheet(); |
31 | 31 | |
32 | 32 | // Add some data |
33 | -$testDates = [[2012, 3, 26], [2012, 2, 29], [2012, 4, 1], [2012, 12, 25], |
|
34 | - [2012, 10, 31], [2012, 11, 5], [2012, 1, 1], [2012, 3, 17], |
|
35 | - [2011, 2, 29], [7, 5, 3], [2012, 13, 1], [2012, 11, 45], |
|
36 | - [2012, 0, 0], [2012, 1, 0], [2012, 0, 1], |
|
37 | - [2012, -2, 2], [2012, 2, -2], [2012, -2, -2], |
|
33 | +$testDates = [[2012, 3, 26], [2012, 2, 29], [2012, 4, 1], [2012, 12, 25], |
|
34 | + [2012, 10, 31], [2012, 11, 5], [2012, 1, 1], [2012, 3, 17], |
|
35 | + [2011, 2, 29], [7, 5, 3], [2012, 13, 1], [2012, 11, 45], |
|
36 | + [2012, 0, 0], [2012, 1, 0], [2012, 0, 1], |
|
37 | + [2012, -2, 2], [2012, 2, -2], [2012, -2, -2], |
|
38 | 38 | ]; |
39 | 39 | $testDateCount = count($testDates); |
40 | 40 |