@@ -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; |
@@ -60,6 +60,9 @@ discard block |
||
60 | 60 | |
61 | 61 | private static $plotMark = 0; |
62 | 62 | |
63 | + /** |
|
64 | + * @param string $markerID |
|
65 | + */ |
|
63 | 66 | private function formatPointMarker($seriesPlot, $markerID) |
64 | 67 | { |
65 | 68 | $plotMarkKeys = array_keys(self::$markSet); |
@@ -87,6 +90,9 @@ discard block |
||
87 | 90 | return $seriesPlot; |
88 | 91 | } |
89 | 92 | |
93 | + /** |
|
94 | + * @param integer $labelCount |
|
95 | + */ |
|
90 | 96 | private function formatDataSetLabels($groupID, $datasetLabels, $labelCount, $rotation = '') |
91 | 97 | { |
92 | 98 | $datasetLabelFormatCode = $this->chart->getPlotArea()->getPlotGroupByIndex($groupID)->getPlotCategoryByIndex(0)->getFormatCode(); |
@@ -116,6 +122,9 @@ discard block |
||
116 | 122 | return $datasetLabels; |
117 | 123 | } |
118 | 124 | |
125 | + /** |
|
126 | + * @param integer $seriesCount |
|
127 | + */ |
|
119 | 128 | private function percentageSumCalculation($groupID, $seriesCount) |
120 | 129 | { |
121 | 130 | // Adjust our values to a percentage value across all series in the group |
@@ -146,6 +155,9 @@ discard block |
||
146 | 155 | return $dataValues; |
147 | 156 | } |
148 | 157 | |
158 | + /** |
|
159 | + * @param \PhpOffice\PhpSpreadsheet\Chart\Title $captionElement |
|
160 | + */ |
|
149 | 161 | private function getCaption($captionElement) |
150 | 162 | { |
151 | 163 | // Read any caption |
@@ -253,6 +265,9 @@ discard block |
||
253 | 265 | $this->renderTitle(); |
254 | 266 | } |
255 | 267 | |
268 | + /** |
|
269 | + * @param integer $groupID |
|
270 | + */ |
|
256 | 271 | private function renderPlotLine($groupID, $filled = false, $combination = false, $dimensions = '2d') |
257 | 272 | { |
258 | 273 | $grouping = $this->chart->getPlotArea()->getPlotGroupByIndex($groupID)->getPlotGrouping(); |
@@ -316,6 +331,9 @@ discard block |
||
316 | 331 | $this->graph->Add($groupPlot); |
317 | 332 | } |
318 | 333 | |
334 | + /** |
|
335 | + * @param integer $groupID |
|
336 | + */ |
|
319 | 337 | private function renderPlotBar($groupID, $dimensions = '2d') |
320 | 338 | { |
321 | 339 | $rotation = $this->chart->getPlotArea()->getPlotGroupByIndex($groupID)->getPlotDirection(); |
@@ -400,6 +418,10 @@ discard block |
||
400 | 418 | $this->graph->Add($groupPlot); |
401 | 419 | } |
402 | 420 | |
421 | + /** |
|
422 | + * @param integer $groupID |
|
423 | + * @param boolean $bubble |
|
424 | + */ |
|
403 | 425 | private function renderPlotScatter($groupID, $bubble) |
404 | 426 | { |
405 | 427 | $grouping = $this->chart->getPlotArea()->getPlotGroupByIndex($groupID)->getPlotGrouping(); |
@@ -445,6 +467,9 @@ discard block |
||
445 | 467 | } |
446 | 468 | } |
447 | 469 | |
470 | + /** |
|
471 | + * @param integer $groupID |
|
472 | + */ |
|
448 | 473 | private function renderPlotRadar($groupID) |
449 | 474 | { |
450 | 475 | $radarStyle = $this->chart->getPlotArea()->getPlotGroupByIndex($groupID)->getPlotStyle(); |
@@ -483,6 +508,9 @@ discard block |
||
483 | 508 | } |
484 | 509 | } |
485 | 510 | |
511 | + /** |
|
512 | + * @param integer $groupID |
|
513 | + */ |
|
486 | 514 | private function renderPlotContour($groupID) |
487 | 515 | { |
488 | 516 | $contourStyle = $this->chart->getPlotArea()->getPlotGroupByIndex($groupID)->getPlotStyle(); |
@@ -503,6 +531,9 @@ discard block |
||
503 | 531 | $this->graph->Add($seriesPlot); |
504 | 532 | } |
505 | 533 | |
534 | + /** |
|
535 | + * @param integer $groupID |
|
536 | + */ |
|
506 | 537 | private function renderPlotStock($groupID) |
507 | 538 | { |
508 | 539 | $seriesCount = $this->chart->getPlotArea()->getPlotGroupByIndex($groupID)->getPlotSeriesCount(); |
@@ -542,6 +573,9 @@ discard block |
||
542 | 573 | $this->graph->Add($seriesPlot); |
543 | 574 | } |
544 | 575 | |
576 | + /** |
|
577 | + * @param integer $groupCount |
|
578 | + */ |
|
545 | 579 | private function renderAreaChart($groupCount, $dimensions = '2d') |
546 | 580 | { |
547 | 581 | require_once \PhpOffice\PhpSpreadsheet\Settings::getChartRendererPath() . 'jpgraph_line.php'; |
@@ -553,6 +587,9 @@ discard block |
||
553 | 587 | } |
554 | 588 | } |
555 | 589 | |
590 | + /** |
|
591 | + * @param integer $groupCount |
|
592 | + */ |
|
556 | 593 | private function renderLineChart($groupCount, $dimensions = '2d') |
557 | 594 | { |
558 | 595 | require_once \PhpOffice\PhpSpreadsheet\Settings::getChartRendererPath() . 'jpgraph_line.php'; |
@@ -564,6 +601,9 @@ discard block |
||
564 | 601 | } |
565 | 602 | } |
566 | 603 | |
604 | + /** |
|
605 | + * @param integer $groupCount |
|
606 | + */ |
|
567 | 607 | private function renderBarChart($groupCount, $dimensions = '2d') |
568 | 608 | { |
569 | 609 | require_once \PhpOffice\PhpSpreadsheet\Settings::getChartRendererPath() . 'jpgraph_bar.php'; |
@@ -575,6 +615,9 @@ discard block |
||
575 | 615 | } |
576 | 616 | } |
577 | 617 | |
618 | + /** |
|
619 | + * @param integer $groupCount |
|
620 | + */ |
|
578 | 621 | private function renderScatterChart($groupCount) |
579 | 622 | { |
580 | 623 | require_once \PhpOffice\PhpSpreadsheet\Settings::getChartRendererPath() . 'jpgraph_scatter.php'; |
@@ -588,6 +631,9 @@ discard block |
||
588 | 631 | } |
589 | 632 | } |
590 | 633 | |
634 | + /** |
|
635 | + * @param integer $groupCount |
|
636 | + */ |
|
591 | 637 | private function renderBubbleChart($groupCount) |
592 | 638 | { |
593 | 639 | require_once \PhpOffice\PhpSpreadsheet\Settings::getChartRendererPath() . 'jpgraph_scatter.php'; |
@@ -599,6 +645,9 @@ discard block |
||
599 | 645 | } |
600 | 646 | } |
601 | 647 | |
648 | + /** |
|
649 | + * @param integer $groupCount |
|
650 | + */ |
|
602 | 651 | private function renderPieChart($groupCount, $dimensions = '2d', $doughnut = false, $multiplePlots = false) |
603 | 652 | { |
604 | 653 | require_once \PhpOffice\PhpSpreadsheet\Settings::getChartRendererPath() . 'jpgraph_pie.php'; |
@@ -675,6 +724,9 @@ discard block |
||
675 | 724 | } |
676 | 725 | } |
677 | 726 | |
727 | + /** |
|
728 | + * @param integer $groupCount |
|
729 | + */ |
|
678 | 730 | private function renderRadarChart($groupCount) |
679 | 731 | { |
680 | 732 | require_once \PhpOffice\PhpSpreadsheet\Settings::getChartRendererPath() . 'jpgraph_radar.php'; |
@@ -686,6 +738,9 @@ discard block |
||
686 | 738 | } |
687 | 739 | } |
688 | 740 | |
741 | + /** |
|
742 | + * @param integer $groupCount |
|
743 | + */ |
|
689 | 744 | private function renderStockChart($groupCount) |
690 | 745 | { |
691 | 746 | require_once \PhpOffice\PhpSpreadsheet\Settings::getChartRendererPath() . 'jpgraph_stock.php'; |
@@ -697,6 +752,10 @@ discard block |
||
697 | 752 | } |
698 | 753 | } |
699 | 754 | |
755 | + /** |
|
756 | + * @param integer $groupCount |
|
757 | + * @param string|null $dimensions |
|
758 | + */ |
|
700 | 759 | private function renderContourChart($groupCount, $dimensions) |
701 | 760 | { |
702 | 761 | require_once \PhpOffice\PhpSpreadsheet\Settings::getChartRendererPath() . 'jpgraph_contour.php'; |
@@ -708,6 +767,9 @@ discard block |
||
708 | 767 | } |
709 | 768 | } |
710 | 769 | |
770 | + /** |
|
771 | + * @param integer $groupCount |
|
772 | + */ |
|
711 | 773 | private function renderCombinationChart($groupCount, $dimensions, $outputDestination) |
712 | 774 | { |
713 | 775 | require_once \PhpOffice\PhpSpreadsheet\Settings::getChartRendererPath() . 'jpgraph_line.php'; |
@@ -119,7 +119,7 @@ |
||
119 | 119 | * |
120 | 120 | * @throws Exception |
121 | 121 | * |
122 | - * @return string |
|
122 | + * @return FormulaToken |
|
123 | 123 | */ |
124 | 124 | public function getToken($pId = 0) |
125 | 125 | { |
@@ -57,8 +57,8 @@ discard block |
||
57 | 57 | /** |
58 | 58 | * Create a new Theme. |
59 | 59 | * |
60 | - * @param mixed $themeName |
|
61 | - * @param mixed $colourSchemeName |
|
60 | + * @param string $themeName |
|
61 | + * @param string $colourSchemeName |
|
62 | 62 | * @param mixed $colourMap |
63 | 63 | */ |
64 | 64 | public function __construct($themeName, $colourSchemeName, $colourMap) |
@@ -92,7 +92,7 @@ discard block |
||
92 | 92 | /** |
93 | 93 | * Get colour Map Value by Position. |
94 | 94 | * |
95 | - * @param mixed $index |
|
95 | + * @param integer $index |
|
96 | 96 | * |
97 | 97 | * @return string |
98 | 98 | */ |
@@ -294,6 +294,11 @@ discard block |
||
294 | 294 | return isset($c->v) ? (string) $c->v : null; |
295 | 295 | } |
296 | 296 | |
297 | + /** |
|
298 | + * @param string $r |
|
299 | + * @param string $cellDataType |
|
300 | + * @param string $castBaseType |
|
301 | + */ |
|
297 | 302 | private function castToFormula($c, $r, &$cellDataType, &$value, &$calculatedValue, &$sharedFormulas, $castBaseType) |
298 | 303 | { |
299 | 304 | $cellDataType = 'f'; |
@@ -2159,6 +2164,9 @@ discard block |
||
2159 | 2164 | return preg_replace('~[^/]+/\.\./~', '', dirname($base) . "/$add"); |
2160 | 2165 | } |
2161 | 2166 | |
2167 | + /** |
|
2168 | + * @param string $style |
|
2169 | + */ |
|
2162 | 2170 | private static function toCSSArray($style) |
2163 | 2171 | { |
2164 | 2172 | $style = str_replace(["\r", "\n"], '', $style); |
@@ -168,16 +168,25 @@ discard block |
||
168 | 168 | return fread($this->fileHandle, $blockSize); |
169 | 169 | } |
170 | 170 | |
171 | + /** |
|
172 | + * @param string $data |
|
173 | + */ |
|
171 | 174 | private static function startsWithTag($data) |
172 | 175 | { |
173 | 176 | return '<' === substr(trim($data), 0, 1); |
174 | 177 | } |
175 | 178 | |
179 | + /** |
|
180 | + * @param string $data |
|
181 | + */ |
|
176 | 182 | private static function endsWithTag($data) |
177 | 183 | { |
178 | 184 | return '>' === substr(trim($data), -1, 1); |
179 | 185 | } |
180 | 186 | |
187 | + /** |
|
188 | + * @param string $data |
|
189 | + */ |
|
181 | 190 | private static function containsTags($data) |
182 | 191 | { |
183 | 192 | return strlen($data) !== strlen(strip_tags($data)); |
@@ -249,6 +258,10 @@ discard block |
||
249 | 258 | return array_pop($this->nestedColumn); |
250 | 259 | } |
251 | 260 | |
261 | + /** |
|
262 | + * @param \PhpOffice\PhpSpreadsheet\Worksheet $sheet |
|
263 | + * @param integer $row |
|
264 | + */ |
|
252 | 265 | protected function flushCell($sheet, $column, $row, &$cellContent) |
253 | 266 | { |
254 | 267 | if (is_string($cellContent)) { |
@@ -2075,7 +2075,6 @@ discard block |
||
2075 | 2075 | /** |
2076 | 2076 | * Unset an instance of this class. |
2077 | 2077 | * |
2078 | - * @param Spreadsheet $spreadsheet Injected spreadsheet identifying the instance to unset |
|
2079 | 2078 | */ |
2080 | 2079 | public function __destruct() |
2081 | 2080 | { |
@@ -2329,6 +2328,10 @@ discard block |
||
2329 | 2328 | return false; |
2330 | 2329 | } |
2331 | 2330 | |
2331 | + /** |
|
2332 | + * @param string $fromSeparator |
|
2333 | + * @param string $toSeparator |
|
2334 | + */ |
|
2332 | 2335 | public static function translateSeparator($fromSeparator, $toSeparator, $formula, &$inBraces) |
2333 | 2336 | { |
2334 | 2337 | $strlen = mb_strlen($formula); |
@@ -2672,6 +2675,9 @@ discard block |
||
2672 | 2675 | return $result; |
2673 | 2676 | } |
2674 | 2677 | |
2678 | + /** |
|
2679 | + * @param string $cellReference |
|
2680 | + */ |
|
2675 | 2681 | public function getValueFromCache($cellReference, &$cellValue) |
2676 | 2682 | { |
2677 | 2683 | // Is calculation cacheing enabled? |
@@ -2815,7 +2821,7 @@ discard block |
||
2815 | 2821 | * |
2816 | 2822 | * @param mixed &$matrix matrix operand |
2817 | 2823 | * |
2818 | - * @return int[] An array comprising the number of rows, and number of columns |
|
2824 | + * @return integer[] An array comprising the number of rows, and number of columns |
|
2819 | 2825 | */ |
2820 | 2826 | private static function getMatrixDimensions(&$matrix) |
2821 | 2827 | { |
@@ -3000,6 +3006,9 @@ discard block |
||
3000 | 3006 | } |
3001 | 3007 | } |
3002 | 3008 | |
3009 | + /** |
|
3010 | + * @param string $formula |
|
3011 | + */ |
|
3003 | 3012 | private function convertMatrixReferences($formula) |
3004 | 3013 | { |
3005 | 3014 | static $matrixReplaceFrom = ['{', ';', '}']; |
@@ -3088,6 +3097,10 @@ discard block |
||
3088 | 3097 | ]; |
3089 | 3098 | |
3090 | 3099 | // Convert infix to postfix notation |
3100 | + |
|
3101 | + /** |
|
3102 | + * @param string $formula |
|
3103 | + */ |
|
3091 | 3104 | private function _parseFormula($formula, Cell $pCell = null) |
3092 | 3105 | { |
3093 | 3106 | if (($formula = $this->convertMatrixReferences(trim($formula))) === false) { |
@@ -3824,6 +3837,9 @@ discard block |
||
3824 | 3837 | return true; |
3825 | 3838 | } |
3826 | 3839 | |
3840 | + /** |
|
3841 | + * @param string|null $cellID |
|
3842 | + */ |
|
3827 | 3843 | private function executeBinaryComparisonOperation($cellID, $operand1, $operand2, $operation, &$stack, $recursingArrays = false) |
3828 | 3844 | { |
3829 | 3845 | // If we're dealing with matrix operations, we want a matrix result |
@@ -3964,7 +3980,7 @@ discard block |
||
3964 | 3980 | |
3965 | 3981 | /** |
3966 | 3982 | * @param string $matrixFunction |
3967 | - * @param mixed $cellID |
|
3983 | + * @param string|null $cellID |
|
3968 | 3984 | * @param mixed $operand1 |
3969 | 3985 | * @param mixed $operand2 |
3970 | 3986 | * @param mixed $operation |