@@ -52,6 +52,10 @@ discard block |
||
52 | 52 | return [(int) $value]; |
53 | 53 | } |
54 | 54 | |
55 | + /** |
|
56 | + * @param integer $num |
|
57 | + * @param integer $n |
|
58 | + */ |
|
55 | 59 | private static function romanCut($num, $n) |
56 | 60 | { |
57 | 61 | return ($num - ($num % $n)) / $n; |
@@ -504,7 +508,7 @@ discard block |
||
504 | 508 | * @category Mathematical and Trigonometric Functions |
505 | 509 | * |
506 | 510 | * @param float $number The positive real number for which you want the logarithm |
507 | - * @param float $base The base of the logarithm. If base is omitted, it is assumed to be 10. |
|
511 | + * @param integer $base The base of the logarithm. If base is omitted, it is assumed to be 10. |
|
508 | 512 | * |
509 | 513 | * @return float |
510 | 514 | */ |
@@ -822,8 +826,8 @@ discard block |
||
822 | 826 | * |
823 | 827 | * Computes x raised to the power y. |
824 | 828 | * |
825 | - * @param float $x |
|
826 | - * @param float $y |
|
829 | + * @param integer $x |
|
830 | + * @param integer $y |
|
827 | 831 | * |
828 | 832 | * @return float |
829 | 833 | */ |
@@ -897,7 +901,7 @@ discard block |
||
897 | 901 | * |
898 | 902 | * @param mixed $args Data values |
899 | 903 | * |
900 | - * @return float |
|
904 | + * @return integer |
|
901 | 905 | */ |
902 | 906 | public static function QUOTIENT(...$args) |
903 | 907 | { |
@@ -1035,9 +1039,6 @@ discard block |
||
1035 | 1039 | * |
1036 | 1040 | * Returns the sum of a power series |
1037 | 1041 | * |
1038 | - * @param float $x Input value to the power series |
|
1039 | - * @param float $n Initial power to which you want to raise $x |
|
1040 | - * @param float $m Step by which to increase $n for each term in the series |
|
1041 | 1042 | * @param array of mixed Data Series |
1042 | 1043 | * |
1043 | 1044 | * @return float |
@@ -1215,7 +1216,7 @@ discard block |
||
1215 | 1216 | * @param mixed $aArgs |
1216 | 1217 | * @param mixed $sumArgs |
1217 | 1218 | * |
1218 | - * @return float |
|
1219 | + * @return integer |
|
1219 | 1220 | */ |
1220 | 1221 | public static function SUMIF($aArgs, $condition, $sumArgs = []) |
1221 | 1222 | { |
@@ -1255,9 +1256,8 @@ discard block |
||
1255 | 1256 | * @category Mathematical and Trigonometric Functions |
1256 | 1257 | * |
1257 | 1258 | * @param mixed $args Data values |
1258 | - * @param string $condition the criteria that defines which cells will be summed |
|
1259 | 1259 | * |
1260 | - * @return float |
|
1260 | + * @return integer |
|
1261 | 1261 | */ |
1262 | 1262 | public static function SUMIFS(...$args) |
1263 | 1263 | { |
@@ -1446,7 +1446,7 @@ discard block |
||
1446 | 1446 | * |
1447 | 1447 | * Truncates value to the number of fractional digits by number_digits. |
1448 | 1448 | * |
1449 | - * @param float $value |
|
1449 | + * @param integer $value |
|
1450 | 1450 | * @param int $digits |
1451 | 1451 | * |
1452 | 1452 | * @return float Truncated value |
@@ -133,7 +133,7 @@ discard block |
||
133 | 133 | * @param mixed $p |
134 | 134 | * @param mixed $q |
135 | 135 | * |
136 | - * @return 0 if p<=0, q<=0 or p+q>2.55E305 to avoid errors and over/underflow |
|
136 | + * @return double if p<=0, q<=0 or p+q>2.55E305 to avoid errors and over/underflow |
|
137 | 137 | * |
138 | 138 | * @author Jaco van Kooten |
139 | 139 | */ |
@@ -159,8 +159,8 @@ discard block |
||
159 | 159 | * @author Jaco van Kooten |
160 | 160 | * |
161 | 161 | * @param mixed $x |
162 | - * @param mixed $p |
|
163 | - * @param mixed $q |
|
162 | + * @param double $p |
|
163 | + * @param double $q |
|
164 | 164 | */ |
165 | 165 | private static function betaFraction($x, $p, $q) |
166 | 166 | { |
@@ -909,8 +909,8 @@ discard block |
||
909 | 909 | * @param float $value Value at which you want to evaluate the distribution |
910 | 910 | * @param float $alpha Parameter to the distribution |
911 | 911 | * @param float $beta Parameter to the distribution |
912 | - * @param mixed $rMin |
|
913 | - * @param mixed $rMax |
|
912 | + * @param integer $rMin |
|
913 | + * @param integer $rMax |
|
914 | 914 | * |
915 | 915 | * @return float |
916 | 916 | */ |
@@ -948,8 +948,8 @@ discard block |
||
948 | 948 | * @param float $probability Probability at which you want to evaluate the distribution |
949 | 949 | * @param float $alpha Parameter to the distribution |
950 | 950 | * @param float $beta Parameter to the distribution |
951 | - * @param float $rMin Minimum value |
|
952 | - * @param float $rMax Maximum value |
|
951 | + * @param integer $rMin Minimum value |
|
952 | + * @param integer $rMax Maximum value |
|
953 | 953 | * |
954 | 954 | * @return float |
955 | 955 | */ |
@@ -2015,7 +2015,6 @@ discard block |
||
2015 | 2015 | * @category Statistical Functions |
2016 | 2016 | * |
2017 | 2017 | * @param mixed $args Data values |
2018 | - * @param int $entry Position (ordered from the largest) in the array or range of data to return |
|
2019 | 2018 | * |
2020 | 2019 | * @return float |
2021 | 2020 | */ |
@@ -2745,7 +2744,6 @@ discard block |
||
2745 | 2744 | * @category Statistical Functions |
2746 | 2745 | * |
2747 | 2746 | * @param mixed $args Data values |
2748 | - * @param float $entry Percentile value in the range 0..1, inclusive. |
|
2749 | 2747 | * |
2750 | 2748 | * @return float |
2751 | 2749 | */ |
@@ -2796,7 +2794,7 @@ discard block |
||
2796 | 2794 | * @param number the number of significant digits for the returned percentage value |
2797 | 2795 | * @param mixed $valueSet |
2798 | 2796 | * @param mixed $value |
2799 | - * @param mixed $significance |
|
2797 | + * @param integer $significance |
|
2800 | 2798 | * |
2801 | 2799 | * @return float |
2802 | 2800 | */ |
@@ -2917,7 +2915,6 @@ discard block |
||
2917 | 2915 | * @category Statistical Functions |
2918 | 2916 | * |
2919 | 2917 | * @param mixed $args Data values |
2920 | - * @param int $entry Quartile value in the range 1..3, inclusive. |
|
2921 | 2918 | * |
2922 | 2919 | * @return float |
2923 | 2920 | */ |
@@ -2950,7 +2947,7 @@ discard block |
||
2950 | 2947 | * @param mixed Order to sort the values in the value set |
2951 | 2948 | * @param mixed $value |
2952 | 2949 | * @param mixed $valueSet |
2953 | - * @param mixed $order |
|
2950 | + * @param integer $order |
|
2954 | 2951 | * |
2955 | 2952 | * @return float |
2956 | 2953 | */ |
@@ -3092,7 +3089,6 @@ discard block |
||
3092 | 3089 | * @category Statistical Functions |
3093 | 3090 | * |
3094 | 3091 | * @param mixed $args Data values |
3095 | - * @param int $entry Position (ordered from the smallest) in the array or range of data to return |
|
3096 | 3092 | * |
3097 | 3093 | * @return float |
3098 | 3094 | */ |
@@ -3556,7 +3552,6 @@ discard block |
||
3556 | 3552 | * @category Statistical Functions |
3557 | 3553 | * |
3558 | 3554 | * @param mixed $args Data values |
3559 | - * @param float $discard Percentage to discard |
|
3560 | 3555 | * |
3561 | 3556 | * @return float |
3562 | 3557 | */ |
@@ -36,7 +36,7 @@ discard block |
||
36 | 36 | * |
37 | 37 | * @param row Row number to use in the cell reference |
38 | 38 | * @param column Column number to use in the cell reference |
39 | - * @param relativity Flag indicating the type of reference to return |
|
39 | + * @param relativity integer indicating the type of reference to return |
|
40 | 40 | * 1 or omitted Absolute |
41 | 41 | * 2 Absolute row; relative column |
42 | 42 | * 3 Relative row; absolute column |
@@ -47,7 +47,7 @@ discard block |
||
47 | 47 | * @param sheetText Optional Name of worksheet to use |
48 | 48 | * @param mixed $row |
49 | 49 | * @param mixed $column |
50 | - * @param mixed $relativity |
|
50 | + * @param integer $relativity |
|
51 | 51 | * @param mixed $referenceStyle |
52 | 52 | * @param mixed $sheetText |
53 | 53 | * |
@@ -358,7 +358,7 @@ discard block |
||
358 | 358 | * |
359 | 359 | * @param cellAddress The reference from which you want to base the offset. Reference must refer to a cell or |
360 | 360 | * range of adjacent cells; otherwise, OFFSET returns the #VALUE! error value. |
361 | - * @param rows The number of rows, up or down, that you want the upper-left cell to refer to. |
|
361 | + * @param rows integer number of rows, up or down, that you want the upper-left cell to refer to. |
|
362 | 362 | * Using 5 as the rows argument specifies that the upper-left cell in the reference is |
363 | 363 | * five rows below reference. Rows can be positive (which means below the starting reference) |
364 | 364 | * or negative (which means above the starting reference). |
@@ -370,8 +370,8 @@ discard block |
||
370 | 370 | * @param height The height, in number of rows, that you want the returned reference to be. Height must be a positive number. |
371 | 371 | * @param width The width, in number of columns, that you want the returned reference to be. Width must be a positive number. |
372 | 372 | * @param null|mixed $cellAddress |
373 | - * @param mixed $rows |
|
374 | - * @param mixed $columns |
|
373 | + * @param integer $rows |
|
374 | + * @param integer $columns |
|
375 | 375 | * @param null|mixed $height |
376 | 376 | * @param null|mixed $width |
377 | 377 | * @param \PhpOffice\PhpSpreadsheet\Cell $pCell |
@@ -499,10 +499,10 @@ discard block |
||
499 | 499 | * |
500 | 500 | * @param lookup_value The value that you want to match in lookup_array |
501 | 501 | * @param lookup_array The range of cells being searched |
502 | - * @param match_type The number -1, 0, or 1. -1 means above, 0 means exact match, 1 means below. If match_type is 1 or -1, the list has to be ordered. |
|
502 | + * @param match_type integer number -1, 0, or 1. -1 means above, 0 means exact match, 1 means below. If match_type is 1 or -1, the list has to be ordered. |
|
503 | 503 | * @param mixed $lookup_value |
504 | 504 | * @param mixed $lookup_array |
505 | - * @param mixed $match_type |
|
505 | + * @param integer $match_type |
|
506 | 506 | * |
507 | 507 | * @return int The relative position of the found item |
508 | 508 | */ |
@@ -599,8 +599,8 @@ discard block |
||
599 | 599 | * @param row_num The row in array from which to return a value. If row_num is omitted, column_num is required. |
600 | 600 | * @param column_num The column in array from which to return a value. If column_num is omitted, row_num is required. |
601 | 601 | * @param mixed $arrayValues |
602 | - * @param mixed $rowNum |
|
603 | - * @param mixed $columnNum |
|
602 | + * @param integer $rowNum |
|
603 | + * @param integer $columnNum |
|
604 | 604 | * |
605 | 605 | * @return mixed the value of a specified cell or array of cells |
606 | 606 | */ |
@@ -696,11 +696,11 @@ discard block |
||
696 | 696 | * |
697 | 697 | * @param lookup_value The value that you want to match in lookup_array |
698 | 698 | * @param lookup_array The range of cells being searched |
699 | - * @param index_number The column number in table_array from which the matching value must be returned. The first column is 1. |
|
699 | + * @param index_number integer column number in table_array from which the matching value must be returned. The first column is 1. |
|
700 | 700 | * @param not_exact_match determines if you are looking for an exact match based on lookup_value |
701 | 701 | * @param mixed $lookup_value |
702 | 702 | * @param mixed $lookup_array |
703 | - * @param mixed $index_number |
|
703 | + * @param integer $index_number |
|
704 | 704 | * @param mixed $not_exact_match |
705 | 705 | * |
706 | 706 | * @return mixed The value of the found cell |
@@ -472,7 +472,7 @@ |
||
472 | 472 | * |
473 | 473 | * @param int $pValue Sheet index |
474 | 474 | * |
475 | - * @return SYLK |
|
475 | + * @return Slk |
|
476 | 476 | */ |
477 | 477 | public function setSheetIndex($pValue = 0) |
478 | 478 | { |
@@ -5118,7 +5118,7 @@ discard block |
||
5118 | 5118 | * is in one piece. |
5119 | 5119 | * Moves to next current position in data stream to start of next record different from a CONtINUE record. |
5120 | 5120 | * |
5121 | - * @return array |
|
5121 | + * @return integer|null |
|
5122 | 5122 | */ |
5123 | 5123 | private function getSplicedRecordData() |
5124 | 5124 | { |
@@ -5368,7 +5368,7 @@ discard block |
||
5368 | 5368 | * |
5369 | 5369 | * @throws Exception |
5370 | 5370 | * |
5371 | - * @return array |
|
5371 | + * @return string |
|
5372 | 5372 | */ |
5373 | 5373 | private function getNextToken($formulaData, $baseCell = 'A1') |
5374 | 5374 | { |
@@ -6945,7 +6945,7 @@ discard block |
||
6945 | 6945 | * |
6946 | 6946 | * @param string $subData |
6947 | 6947 | * |
6948 | - * @return array |
|
6948 | + * @return string |
|
6949 | 6949 | */ |
6950 | 6950 | private function readBIFF8CellRangeAddressList($subData) |
6951 | 6951 | { |
@@ -7060,7 +7060,7 @@ discard block |
||
7060 | 7060 | * |
7061 | 7061 | * @param string $arrayData |
7062 | 7062 | * |
7063 | - * @return array |
|
7063 | + * @return string |
|
7064 | 7064 | */ |
7065 | 7065 | private static function readBIFF8ConstantArray($arrayData) |
7066 | 7066 | { |
@@ -7099,7 +7099,7 @@ discard block |
||
7099 | 7099 | * |
7100 | 7100 | * @param string $valueData |
7101 | 7101 | * |
7102 | - * @return array |
|
7102 | + * @return string |
|
7103 | 7103 | */ |
7104 | 7104 | private static function readBIFF8Constant($valueData) |
7105 | 7105 | { |
@@ -187,6 +187,11 @@ |
||
187 | 187 | return $Y ^ ($X | (~$Z)); // Y XOR (X OR NOT Z) |
188 | 188 | } |
189 | 189 | |
190 | + /** |
|
191 | + * @param string[] $func |
|
192 | + * @param integer $s |
|
193 | + * @param integer $t |
|
194 | + */ |
|
190 | 195 | private static function step($func, &$A, $B, $C, $D, $M, $s, $t) |
191 | 196 | { |
192 | 197 | $A = ($A + call_user_func($func, $B, $C, $D) + $M + $t) & 0xffffffff; |
@@ -230,6 +230,9 @@ discard block |
||
230 | 230 | return $this->loadIntoExisting($pFilename, $spreadsheet); |
231 | 231 | } |
232 | 232 | |
233 | + /** |
|
234 | + * @param string $styleAttributeValue |
|
235 | + */ |
|
233 | 236 | protected static function identifyFixedStyleValue($styleList, &$styleAttributeValue) |
234 | 237 | { |
235 | 238 | $styleAttributeValue = strtolower($styleAttributeValue); |
@@ -761,6 +764,9 @@ discard block |
||
761 | 764 | return $spreadsheet; |
762 | 765 | } |
763 | 766 | |
767 | + /** |
|
768 | + * @param string $charset |
|
769 | + */ |
|
764 | 770 | protected static function convertStringEncoding($string, $charset) |
765 | 771 | { |
766 | 772 | if ($charset != 'UTF-8') { |
@@ -69,7 +69,7 @@ |
||
69 | 69 | /** |
70 | 70 | * Read the file. |
71 | 71 | * |
72 | - * @param $pFilename string Filename |
|
72 | + * @param string $pFilename string Filename |
|
73 | 73 | * |
74 | 74 | * @throws \PhpOffice\PhpSpreadsheet\Reader\Exception |
75 | 75 | */ |
@@ -101,7 +101,7 @@ |
||
101 | 101 | * |
102 | 102 | * @param string $fileName Filename for the file in zip archive |
103 | 103 | * |
104 | - * @return bool |
|
104 | + * @return integer |
|
105 | 105 | */ |
106 | 106 | public function locateName($fileName) |
107 | 107 | { |