@@ -460,7 +460,7 @@ discard block |
||
460 | 460 | * DATEVALUE(dateValue) |
461 | 461 | * |
462 | 462 | * @category Date/Time Functions |
463 | - * @param string $dateValue Text that represents a date in a Microsoft Excel date format. |
|
463 | + * @param integer $dateValue Text that represents a date in a Microsoft Excel date format. |
|
464 | 464 | * For example, "1/30/2008" or "30-Jan-2008" are text strings within |
465 | 465 | * quotation marks that represent dates. Using the default date |
466 | 466 | * system in Excel for Windows, date_text must represent a date from |
@@ -644,9 +644,9 @@ discard block |
||
644 | 644 | /** |
645 | 645 | * DATEDIF |
646 | 646 | * |
647 | - * @param mixed $startDate Excel date serial value, PHP date/time stamp, PHP DateTime object |
|
647 | + * @param integer $startDate Excel date serial value, PHP date/time stamp, PHP DateTime object |
|
648 | 648 | * or a standard date string |
649 | - * @param mixed $endDate Excel date serial value, PHP date/time stamp, PHP DateTime object |
|
649 | + * @param integer $endDate Excel date serial value, PHP date/time stamp, PHP DateTime object |
|
650 | 650 | * or a standard date string |
651 | 651 | * @param string $unit |
652 | 652 | * @return int Interval between the dates |
@@ -757,9 +757,9 @@ discard block |
||
757 | 757 | * DAYS360(startDate,endDate[,method]) |
758 | 758 | * |
759 | 759 | * @category Date/Time Functions |
760 | - * @param mixed $startDate Excel date serial value (float), PHP date timestamp (integer), |
|
760 | + * @param integer $startDate Excel date serial value (float), PHP date timestamp (integer), |
|
761 | 761 | * PHP DateTime object, or a standard date string |
762 | - * @param mixed $endDate Excel date serial value (float), PHP date timestamp (integer), |
|
762 | + * @param integer $endDate Excel date serial value (float), PHP date timestamp (integer), |
|
763 | 763 | * PHP DateTime object, or a standard date string |
764 | 764 | * @param bool $method US or European Method |
765 | 765 | * FALSE or omitted: U.S. (NASD) method. If the starting date is |
@@ -816,9 +816,9 @@ discard block |
||
816 | 816 | * YEARFRAC(startDate,endDate[,method]) |
817 | 817 | * |
818 | 818 | * @category Date/Time Functions |
819 | - * @param mixed $startDate Excel date serial value (float), PHP date timestamp (integer), |
|
819 | + * @param integer $startDate Excel date serial value (float), PHP date timestamp (integer), |
|
820 | 820 | * PHP DateTime object, or a standard date string |
821 | - * @param mixed $endDate Excel date serial value (float), PHP date timestamp (integer), |
|
821 | + * @param integer $endDate Excel date serial value (float), PHP date timestamp (integer), |
|
822 | 822 | * PHP DateTime object, or a standard date string |
823 | 823 | * @param int $method Method used for the calculation |
824 | 824 | * 0 or omitted US (NASD) 30/360 |
@@ -918,10 +918,6 @@ discard block |
||
918 | 918 | * PHP DateTime object, or a standard date string |
919 | 919 | * @param mixed $endDate Excel date serial value (float), PHP date timestamp (integer), |
920 | 920 | * PHP DateTime object, or a standard date string |
921 | - * @param mixed $holidays,... Optional series of Excel date serial value (float), PHP date |
|
922 | - * timestamp (integer), PHP DateTime object, or a standard date |
|
923 | - * strings that will be excluded from the working calendar, such |
|
924 | - * as state and federal holidays and floating holidays. |
|
925 | 921 | * @return int Interval between the dates |
926 | 922 | */ |
927 | 923 | public static function NETWORKDAYS($startDate, $endDate) |
@@ -1003,10 +999,6 @@ discard block |
||
1003 | 999 | * @param int $endDays The number of nonweekend and nonholiday days before or after |
1004 | 1000 | * startDate. A positive value for days yields a future date; a |
1005 | 1001 | * negative value yields a past date. |
1006 | - * @param mixed $holidays,... Optional series of Excel date serial value (float), PHP date |
|
1007 | - * timestamp (integer), PHP DateTime object, or a standard date |
|
1008 | - * strings that will be excluded from the working calendar, such |
|
1009 | - * as state and federal holidays and floating holidays. |
|
1010 | 1002 | * @return mixed Excel date/time serial value, PHP date/time serial value or PHP date/time object, |
1011 | 1003 | * depending on the value of the ReturnDateType flag |
1012 | 1004 | */ |
@@ -1110,7 +1102,7 @@ discard block |
||
1110 | 1102 | * Excel Function: |
1111 | 1103 | * DAY(dateValue) |
1112 | 1104 | * |
1113 | - * @param mixed $dateValue Excel date serial value (float), PHP date timestamp (integer), |
|
1105 | + * @param integer $dateValue Excel date serial value (float), PHP date timestamp (integer), |
|
1114 | 1106 | * PHP DateTime object, or a standard date string |
1115 | 1107 | * @return int Day of the month |
1116 | 1108 | */ |
@@ -1143,7 +1135,7 @@ discard block |
||
1143 | 1135 | * Excel Function: |
1144 | 1136 | * WEEKDAY(dateValue[,style]) |
1145 | 1137 | * |
1146 | - * @param mixed $dateValue Excel date serial value (float), PHP date timestamp (integer), |
|
1138 | + * @param integer $dateValue Excel date serial value (float), PHP date timestamp (integer), |
|
1147 | 1139 | * PHP DateTime object, or a standard date string |
1148 | 1140 | * @param int $style A number that determines the type of return value |
1149 | 1141 | * 1 or omitted Numbers 1 (Sunday) through 7 (Saturday). |
@@ -1219,9 +1211,9 @@ discard block |
||
1219 | 1211 | * Excel Function: |
1220 | 1212 | * WEEKNUM(dateValue[,style]) |
1221 | 1213 | * |
1222 | - * @param mixed $dateValue Excel date serial value (float), PHP date timestamp (integer), |
|
1214 | + * @param integer $dateValue Excel date serial value (float), PHP date timestamp (integer), |
|
1223 | 1215 | * PHP DateTime object, or a standard date string |
1224 | - * @param bool $method Week begins on Sunday or Monday |
|
1216 | + * @param integer $method Week begins on Sunday or Monday |
|
1225 | 1217 | * 1 or omitted Week begins on Sunday. |
1226 | 1218 | * 2 Week begins on Monday. |
1227 | 1219 | * @return int Week Number |
@@ -1267,7 +1259,7 @@ discard block |
||
1267 | 1259 | * Excel Function: |
1268 | 1260 | * MONTH(dateValue) |
1269 | 1261 | * |
1270 | - * @param mixed $dateValue Excel date serial value (float), PHP date timestamp (integer), |
|
1262 | + * @param integer $dateValue Excel date serial value (float), PHP date timestamp (integer), |
|
1271 | 1263 | * PHP DateTime object, or a standard date string |
1272 | 1264 | * @return int Month of the year |
1273 | 1265 | */ |
@@ -1299,7 +1291,7 @@ discard block |
||
1299 | 1291 | * Excel Function: |
1300 | 1292 | * YEAR(dateValue) |
1301 | 1293 | * |
1302 | - * @param mixed $dateValue Excel date serial value (float), PHP date timestamp (integer), |
|
1294 | + * @param integer $dateValue Excel date serial value (float), PHP date timestamp (integer), |
|
1303 | 1295 | * PHP DateTime object, or a standard date string |
1304 | 1296 | * @return int Year |
1305 | 1297 | */ |
@@ -1330,7 +1322,7 @@ discard block |
||
1330 | 1322 | * Excel Function: |
1331 | 1323 | * HOUR(timeValue) |
1332 | 1324 | * |
1333 | - * @param mixed $timeValue Excel date serial value (float), PHP date timestamp (integer), |
|
1325 | + * @param integer $timeValue Excel date serial value (float), PHP date timestamp (integer), |
|
1334 | 1326 | * PHP DateTime object, or a standard time string |
1335 | 1327 | * @return int Hour |
1336 | 1328 | */ |
@@ -1370,7 +1362,7 @@ discard block |
||
1370 | 1362 | * Excel Function: |
1371 | 1363 | * MINUTE(timeValue) |
1372 | 1364 | * |
1373 | - * @param mixed $timeValue Excel date serial value (float), PHP date timestamp (integer), |
|
1365 | + * @param integer $timeValue Excel date serial value (float), PHP date timestamp (integer), |
|
1374 | 1366 | * PHP DateTime object, or a standard time string |
1375 | 1367 | * @return int Minute |
1376 | 1368 | */ |
@@ -1410,7 +1402,7 @@ discard block |
||
1410 | 1402 | * Excel Function: |
1411 | 1403 | * SECOND(timeValue) |
1412 | 1404 | * |
1413 | - * @param mixed $timeValue Excel date serial value (float), PHP date timestamp (integer), |
|
1405 | + * @param integer $timeValue Excel date serial value (float), PHP date timestamp (integer), |
|
1414 | 1406 | * PHP DateTime object, or a standard time string |
1415 | 1407 | * @return int Second |
1416 | 1408 | */ |
@@ -1452,7 +1444,7 @@ discard block |
||
1452 | 1444 | * Excel Function: |
1453 | 1445 | * EDATE(dateValue,adjustmentMonths) |
1454 | 1446 | * |
1455 | - * @param mixed $dateValue Excel date serial value (float), PHP date timestamp (integer), |
|
1447 | + * @param integer $dateValue Excel date serial value (float), PHP date timestamp (integer), |
|
1456 | 1448 | * PHP DateTime object, or a standard date string |
1457 | 1449 | * @param int $adjustmentMonths The number of months before or after start_date. |
1458 | 1450 | * A positive value for months yields a future date; |
@@ -1497,7 +1489,7 @@ discard block |
||
1497 | 1489 | * Excel Function: |
1498 | 1490 | * EOMONTH(dateValue,adjustmentMonths) |
1499 | 1491 | * |
1500 | - * @param mixed $dateValue Excel date serial value (float), PHP date timestamp (integer), |
|
1492 | + * @param integer $dateValue Excel date serial value (float), PHP date timestamp (integer), |
|
1501 | 1493 | * PHP DateTime object, or a standard date string |
1502 | 1494 | * @param int $adjustmentMonths The number of months before or after start_date. |
1503 | 1495 | * A positive value for months yields a future date; |
@@ -424,7 +424,7 @@ discard block |
||
424 | 424 | |
425 | 425 | return (float) \PhpSpreadsheet\Shared\Date::formattedPHPToExcel($calendar, 1, $date, $hour, $minute, $second); |
426 | 426 | case Functions::RETURNDATE_PHP_NUMERIC: |
427 | - return (integer) \PhpSpreadsheet\Shared\Date::excelToTimestamp(\PhpSpreadsheet\Shared\Date::formattedPHPToExcel(1970, 1, 1, $hour, $minute, $second)); // -2147468400; // -2147472000 + 3600 |
|
427 | + return (integer) \PhpSpreadsheet\Shared\Date::excelToTimestamp(\PhpSpreadsheet\Shared\Date::formattedPHPToExcel(1970, 1, 1, $hour, $minute, $second)); // -2147468400; // -2147472000 + 3600 |
|
428 | 428 | case Functions::RETURNDATE_PHP_OBJECT: |
429 | 429 | $dayAdjust = 0; |
430 | 430 | if ($hour < 0) { |
@@ -1036,7 +1036,7 @@ discard block |
||
1036 | 1036 | |
1037 | 1037 | $startDoW = self::DAYOFWEEK($startDate, 3); |
1038 | 1038 | if (self::DAYOFWEEK($startDate, 3) >= 5) { |
1039 | - $startDate += ($decrementing) ? -$startDoW + 4: 7 - $startDoW; |
|
1039 | + $startDate += ($decrementing) ? -$startDoW + 4 : 7 - $startDoW; |
|
1040 | 1040 | ($decrementing) ? $endDays++ : $endDays--; |
1041 | 1041 | } |
1042 | 1042 | |
@@ -1046,7 +1046,7 @@ discard block |
||
1046 | 1046 | // Adjust the calculated end date if it falls over a weekend |
1047 | 1047 | $endDoW = self::DAYOFWEEK($endDate, 3); |
1048 | 1048 | if ($endDoW >= 5) { |
1049 | - $endDate += ($decrementing) ? -$endDoW + 4: 7 - $endDoW; |
|
1049 | + $endDate += ($decrementing) ? -$endDoW + 4 : 7 - $endDoW; |
|
1050 | 1050 | } |
1051 | 1051 | |
1052 | 1052 | // Test any extra holiday parameters |
@@ -384,7 +384,7 @@ discard block |
||
384 | 384 | * IS_EVEN |
385 | 385 | * |
386 | 386 | * @param mixed $value Value to check |
387 | - * @return bool |
|
387 | + * @return string|boolean |
|
388 | 388 | */ |
389 | 389 | public static function isEven($value = null) |
390 | 390 | { |
@@ -403,7 +403,7 @@ discard block |
||
403 | 403 | * IS_ODD |
404 | 404 | * |
405 | 405 | * @param mixed $value Value to check |
406 | - * @return bool |
|
406 | + * @return string|boolean |
|
407 | 407 | */ |
408 | 408 | public static function isOdd($value = null) |
409 | 409 | { |
@@ -75,8 +75,7 @@ discard block |
||
75 | 75 | * the value TRUE or FALSE, in which case it is evaluated as the corresponding boolean value |
76 | 76 | * |
77 | 77 | * @category Logical Functions |
78 | - * @param mixed $arg,... Data values |
|
79 | - * @return bool The logical AND of the arguments. |
|
78 | + * @return string|boolean The logical AND of the arguments. |
|
80 | 79 | */ |
81 | 80 | public static function logicalAnd() |
82 | 81 | { |
@@ -130,8 +129,7 @@ discard block |
||
130 | 129 | * the value TRUE or FALSE, in which case it is evaluated as the corresponding boolean value |
131 | 130 | * |
132 | 131 | * @category Logical Functions |
133 | - * @param mixed $arg,... Data values |
|
134 | - * @return bool The logical OR of the arguments. |
|
132 | + * @return string|boolean The logical OR of the arguments. |
|
135 | 133 | */ |
136 | 134 | public static function logicalOr() |
137 | 135 | { |
@@ -185,7 +183,7 @@ discard block |
||
185 | 183 | * |
186 | 184 | * @category Logical Functions |
187 | 185 | * @param mixed $logical A value or expression that can be evaluated to TRUE or FALSE |
188 | - * @return bool The boolean inverse of the argument. |
|
186 | + * @return boolean|string The boolean inverse of the argument. |
|
189 | 187 | */ |
190 | 188 | public static function NOT($logical = false) |
191 | 189 | { |
@@ -230,8 +228,8 @@ discard block |
||
230 | 228 | * ReturnIfFalse can be another formula. |
231 | 229 | * |
232 | 230 | * @category Logical Functions |
233 | - * @param mixed $condition Condition to evaluate |
|
234 | - * @param mixed $returnIfTrue Value to return when condition is true |
|
231 | + * @param boolean $condition Condition to evaluate |
|
232 | + * @param integer $returnIfTrue Value to return when condition is true |
|
235 | 233 | * @param mixed $returnIfFalse Optional value to return when condition is false |
236 | 234 | * @return mixed The value of returnIfTrue or returnIfFalse determined by condition |
237 | 235 | */ |
@@ -237,8 +237,8 @@ |
||
237 | 237 | */ |
238 | 238 | public static function statementIf($condition = true, $returnIfTrue = 0, $returnIfFalse = false) |
239 | 239 | { |
240 | - $condition = (is_null($condition)) ? true : (boolean) Functions::flattenSingleValue($condition); |
|
241 | - $returnIfTrue = (is_null($returnIfTrue)) ? 0 : Functions::flattenSingleValue($returnIfTrue); |
|
240 | + $condition = (is_null($condition)) ? true : (boolean) Functions::flattenSingleValue($condition); |
|
241 | + $returnIfTrue = (is_null($returnIfTrue)) ? 0 : Functions::flattenSingleValue($returnIfTrue); |
|
242 | 242 | $returnIfFalse = (is_null($returnIfFalse)) ? false : Functions::flattenSingleValue($returnIfFalse); |
243 | 243 | |
244 | 244 | return ($condition) ? $returnIfTrue : $returnIfFalse; |
@@ -124,7 +124,7 @@ discard block |
||
124 | 124 | * |
125 | 125 | * @param p require p>0 |
126 | 126 | * @param q require q>0 |
127 | - * @return 0 if p<=0, q<=0 or p+q>2.55E305 to avoid errors and over/underflow |
|
127 | + * @return double if p<=0, q<=0 or p+q>2.55E305 to avoid errors and over/underflow |
|
128 | 128 | * @author Jaco van Kooten |
129 | 129 | */ |
130 | 130 | private static function logBeta($p, $q) |
@@ -146,6 +146,8 @@ discard block |
||
146 | 146 | * Evaluates of continued fraction part of incomplete beta function. |
147 | 147 | * Based on an idea from Numerical Recipes (W.H. Press et al, 1992). |
148 | 148 | * @author Jaco van Kooten |
149 | + * @param double $p |
|
150 | + * @param double $q |
|
149 | 151 | */ |
150 | 152 | private static function betaFraction($x, $p, $q) |
151 | 153 | { |
@@ -702,7 +704,6 @@ discard block |
||
702 | 704 | * AVEDEV(value1[,value2[, ...]]) |
703 | 705 | * |
704 | 706 | * @category Statistical Functions |
705 | - * @param mixed $arg,... Data values |
|
706 | 707 | * @return float |
707 | 708 | */ |
708 | 709 | public static function AVEDEV() |
@@ -751,7 +752,6 @@ discard block |
||
751 | 752 | * AVERAGE(value1[,value2[, ...]]) |
752 | 753 | * |
753 | 754 | * @category Statistical Functions |
754 | - * @param mixed $arg,... Data values |
|
755 | 755 | * @return float |
756 | 756 | */ |
757 | 757 | public static function AVERAGE() |
@@ -792,7 +792,6 @@ discard block |
||
792 | 792 | * AVERAGEA(value1[,value2[, ...]]) |
793 | 793 | * |
794 | 794 | * @category Statistical Functions |
795 | - * @param mixed $arg,... Data values |
|
796 | 795 | * @return float |
797 | 796 | */ |
798 | 797 | public static function AVERAGEA() |
@@ -837,7 +836,6 @@ discard block |
||
837 | 836 | * AVERAGEIF(value1[,value2[, ...]],condition) |
838 | 837 | * |
839 | 838 | * @category Mathematical and Trigonometric Functions |
840 | - * @param mixed $arg,... Data values |
|
841 | 839 | * @param string $condition The criteria that defines which cells will be checked. |
842 | 840 | * @param mixed[] $averageArgs Data values |
843 | 841 | * @return float |
@@ -882,7 +880,6 @@ discard block |
||
882 | 880 | * @param float $value Value at which you want to evaluate the distribution |
883 | 881 | * @param float $alpha Parameter to the distribution |
884 | 882 | * @param float $beta Parameter to the distribution |
885 | - * @param bool $cumulative |
|
886 | 883 | * @return float |
887 | 884 | */ |
888 | 885 | public static function BETADIST($value, $alpha, $beta, $rMin = 0, $rMax = 1) |
@@ -919,9 +916,8 @@ discard block |
||
919 | 916 | * @param float $probability Probability at which you want to evaluate the distribution |
920 | 917 | * @param float $alpha Parameter to the distribution |
921 | 918 | * @param float $beta Parameter to the distribution |
922 | - * @param float $rMin Minimum value |
|
923 | - * @param float $rMax Maximum value |
|
924 | - * @param bool $cumulative |
|
919 | + * @param integer $rMin Minimum value |
|
920 | + * @param integer $rMax Maximum value |
|
925 | 921 | * @return float |
926 | 922 | */ |
927 | 923 | public static function BETAINV($probability, $alpha, $beta, $rMin = 0, $rMax = 1) |
@@ -1172,7 +1168,6 @@ discard block |
||
1172 | 1168 | * COUNT(value1[,value2[, ...]]) |
1173 | 1169 | * |
1174 | 1170 | * @category Statistical Functions |
1175 | - * @param mixed $arg,... Data values |
|
1176 | 1171 | * @return int |
1177 | 1172 | */ |
1178 | 1173 | public static function COUNT() |
@@ -1204,7 +1199,6 @@ discard block |
||
1204 | 1199 | * COUNTA(value1[,value2[, ...]]) |
1205 | 1200 | * |
1206 | 1201 | * @category Statistical Functions |
1207 | - * @param mixed $arg,... Data values |
|
1208 | 1202 | * @return int |
1209 | 1203 | */ |
1210 | 1204 | public static function COUNTA() |
@@ -1232,7 +1226,6 @@ discard block |
||
1232 | 1226 | * COUNTBLANK(value1[,value2[, ...]]) |
1233 | 1227 | * |
1234 | 1228 | * @category Statistical Functions |
1235 | - * @param mixed $arg,... Data values |
|
1236 | 1229 | * @return int |
1237 | 1230 | */ |
1238 | 1231 | public static function COUNTBLANK() |
@@ -1260,7 +1253,6 @@ discard block |
||
1260 | 1253 | * COUNTIF(value1[,value2[, ...]],condition) |
1261 | 1254 | * |
1262 | 1255 | * @category Statistical Functions |
1263 | - * @param mixed $arg,... Data values |
|
1264 | 1256 | * @param string $condition The criteria that defines which cells will be counted. |
1265 | 1257 | * @return int |
1266 | 1258 | */ |
@@ -1445,7 +1437,6 @@ discard block |
||
1445 | 1437 | * DEVSQ(value1[,value2[, ...]]) |
1446 | 1438 | * |
1447 | 1439 | * @category Statistical Functions |
1448 | - * @param mixed $arg,... Data values |
|
1449 | 1440 | * @return float |
1450 | 1441 | */ |
1451 | 1442 | public static function DEVSQ() |
@@ -1727,7 +1718,6 @@ discard block |
||
1727 | 1718 | * GEOMEAN(value1[,value2[, ...]]) |
1728 | 1719 | * |
1729 | 1720 | * @category Statistical Functions |
1730 | - * @param mixed $arg,... Data values |
|
1731 | 1721 | * @return float |
1732 | 1722 | */ |
1733 | 1723 | public static function GEOMEAN() |
@@ -1786,7 +1776,6 @@ discard block |
||
1786 | 1776 | * HARMEAN(value1[,value2[, ...]]) |
1787 | 1777 | * |
1788 | 1778 | * @category Statistical Functions |
1789 | - * @param mixed $arg,... Data values |
|
1790 | 1779 | * @return float |
1791 | 1780 | */ |
1792 | 1781 | public static function HARMEAN() |
@@ -1940,8 +1929,6 @@ discard block |
||
1940 | 1929 | * LARGE(value1[,value2[, ...]],entry) |
1941 | 1930 | * |
1942 | 1931 | * @category Statistical Functions |
1943 | - * @param mixed $arg,... Data values |
|
1944 | - * @param int $entry Position (ordered from the largest) in the array or range of data to return |
|
1945 | 1932 | * @return float |
1946 | 1933 | */ |
1947 | 1934 | public static function LARGE() |
@@ -2163,7 +2150,6 @@ discard block |
||
2163 | 2150 | * MAX(value1[,value2[, ...]]) |
2164 | 2151 | * |
2165 | 2152 | * @category Statistical Functions |
2166 | - * @param mixed $arg,... Data values |
|
2167 | 2153 | * @return float |
2168 | 2154 | */ |
2169 | 2155 | public static function MAX() |
@@ -2197,7 +2183,6 @@ discard block |
||
2197 | 2183 | * MAXA(value1[,value2[, ...]]) |
2198 | 2184 | * |
2199 | 2185 | * @category Statistical Functions |
2200 | - * @param mixed $arg,... Data values |
|
2201 | 2186 | * @return float |
2202 | 2187 | */ |
2203 | 2188 | public static function MAXA() |
@@ -2236,7 +2221,6 @@ discard block |
||
2236 | 2221 | * MAXIF(value1[,value2[, ...]],condition) |
2237 | 2222 | * |
2238 | 2223 | * @category Mathematical and Trigonometric Functions |
2239 | - * @param mixed $arg,... Data values |
|
2240 | 2224 | * @param string $condition The criteria that defines which cells will be checked. |
2241 | 2225 | * @return float |
2242 | 2226 | */ |
@@ -2275,7 +2259,6 @@ discard block |
||
2275 | 2259 | * MEDIAN(value1[,value2[, ...]]) |
2276 | 2260 | * |
2277 | 2261 | * @category Statistical Functions |
2278 | - * @param mixed $arg,... Data values |
|
2279 | 2262 | * @return float |
2280 | 2263 | */ |
2281 | 2264 | public static function MEDIAN() |
@@ -2317,7 +2300,6 @@ discard block |
||
2317 | 2300 | * MIN(value1[,value2[, ...]]) |
2318 | 2301 | * |
2319 | 2302 | * @category Statistical Functions |
2320 | - * @param mixed $arg,... Data values |
|
2321 | 2303 | * @return float |
2322 | 2304 | */ |
2323 | 2305 | public static function MIN() |
@@ -2351,7 +2333,6 @@ discard block |
||
2351 | 2333 | * MINA(value1[,value2[, ...]]) |
2352 | 2334 | * |
2353 | 2335 | * @category Statistical Functions |
2354 | - * @param mixed $arg,... Data values |
|
2355 | 2336 | * @return float |
2356 | 2337 | */ |
2357 | 2338 | public static function MINA() |
@@ -2390,7 +2371,6 @@ discard block |
||
2390 | 2371 | * MINIF(value1[,value2[, ...]],condition) |
2391 | 2372 | * |
2392 | 2373 | * @category Mathematical and Trigonometric Functions |
2393 | - * @param mixed $arg,... Data values |
|
2394 | 2374 | * @param string $condition The criteria that defines which cells will be checked. |
2395 | 2375 | * @return float |
2396 | 2376 | */ |
@@ -2466,7 +2446,6 @@ discard block |
||
2466 | 2446 | * MODE(value1[,value2[, ...]]) |
2467 | 2447 | * |
2468 | 2448 | * @category Statistical Functions |
2469 | - * @param mixed $arg,... Data values |
|
2470 | 2449 | * @return float |
2471 | 2450 | */ |
2472 | 2451 | public static function MODE() |
@@ -2569,9 +2548,9 @@ discard block |
||
2569 | 2548 | * |
2570 | 2549 | * Returns the inverse of the normal cumulative distribution for the specified mean and standard deviation. |
2571 | 2550 | * |
2572 | - * @param float $value |
|
2573 | 2551 | * @param float $mean Mean Value |
2574 | 2552 | * @param float $stdDev Standard Deviation |
2553 | + * @param double $probability |
|
2575 | 2554 | * @return float |
2576 | 2555 | */ |
2577 | 2556 | public static function NORMINV($probability, $mean, $stdDev) |
@@ -2633,8 +2612,6 @@ discard block |
||
2633 | 2612 | * PERCENTILE(value1[,value2[, ...]],entry) |
2634 | 2613 | * |
2635 | 2614 | * @category Statistical Functions |
2636 | - * @param mixed $arg,... Data values |
|
2637 | - * @param float $entry Percentile value in the range 0..1, inclusive. |
|
2638 | 2615 | * @return float |
2639 | 2616 | */ |
2640 | 2617 | public static function PERCENTILE() |
@@ -2798,8 +2775,6 @@ discard block |
||
2798 | 2775 | * QUARTILE(value1[,value2[, ...]],entry) |
2799 | 2776 | * |
2800 | 2777 | * @category Statistical Functions |
2801 | - * @param mixed $arg,... Data values |
|
2802 | - * @param int $entry Quartile value in the range 1..3, inclusive. |
|
2803 | 2778 | * @return float |
2804 | 2779 | */ |
2805 | 2780 | public static function QUARTILE() |
@@ -2960,8 +2935,6 @@ discard block |
||
2960 | 2935 | * SMALL(value1[,value2[, ...]],entry) |
2961 | 2936 | * |
2962 | 2937 | * @category Statistical Functions |
2963 | - * @param mixed $arg,... Data values |
|
2964 | - * @param int $entry Position (ordered from the smallest) in the array or range of data to return |
|
2965 | 2938 | * @return float |
2966 | 2939 | */ |
2967 | 2940 | public static function SMALL() |
@@ -3029,7 +3002,6 @@ discard block |
||
3029 | 3002 | * STDEV(value1[,value2[, ...]]) |
3030 | 3003 | * |
3031 | 3004 | * @category Statistical Functions |
3032 | - * @param mixed $arg,... Data values |
|
3033 | 3005 | * @return float |
3034 | 3006 | */ |
3035 | 3007 | public static function STDEV() |
@@ -3076,7 +3048,6 @@ discard block |
||
3076 | 3048 | * STDEVA(value1[,value2[, ...]]) |
3077 | 3049 | * |
3078 | 3050 | * @category Statistical Functions |
3079 | - * @param mixed $arg,... Data values |
|
3080 | 3051 | * @return float |
3081 | 3052 | */ |
3082 | 3053 | public static function STDEVA() |
@@ -3126,7 +3097,6 @@ discard block |
||
3126 | 3097 | * STDEVP(value1[,value2[, ...]]) |
3127 | 3098 | * |
3128 | 3099 | * @category Statistical Functions |
3129 | - * @param mixed $arg,... Data values |
|
3130 | 3100 | * @return float |
3131 | 3101 | */ |
3132 | 3102 | public static function STDEVP() |
@@ -3171,7 +3141,6 @@ discard block |
||
3171 | 3141 | * STDEVPA(value1[,value2[, ...]]) |
3172 | 3142 | * |
3173 | 3143 | * @category Statistical Functions |
3174 | - * @param mixed $arg,... Data values |
|
3175 | 3144 | * @return float |
3176 | 3145 | */ |
3177 | 3146 | public static function STDEVPA() |
@@ -3403,8 +3372,6 @@ discard block |
||
3403 | 3372 | * TRIMEAN(value1[,value2[, ...]], $discard) |
3404 | 3373 | * |
3405 | 3374 | * @category Statistical Functions |
3406 | - * @param mixed $arg,... Data values |
|
3407 | - * @param float $discard Percentage to discard |
|
3408 | 3375 | * @return float |
3409 | 3376 | */ |
3410 | 3377 | public static function TRIMMEAN() |
@@ -3447,7 +3414,6 @@ discard block |
||
3447 | 3414 | * VAR(value1[,value2[, ...]]) |
3448 | 3415 | * |
3449 | 3416 | * @category Statistical Functions |
3450 | - * @param mixed $arg,... Data values |
|
3451 | 3417 | * @return float |
3452 | 3418 | */ |
3453 | 3419 | public static function VARFunc() |
@@ -3489,7 +3455,6 @@ discard block |
||
3489 | 3455 | * VARA(value1[,value2[, ...]]) |
3490 | 3456 | * |
3491 | 3457 | * @category Statistical Functions |
3492 | - * @param mixed $arg,... Data values |
|
3493 | 3458 | * @return float |
3494 | 3459 | */ |
3495 | 3460 | public static function VARA() |
@@ -3540,7 +3505,6 @@ discard block |
||
3540 | 3505 | * VARP(value1[,value2[, ...]]) |
3541 | 3506 | * |
3542 | 3507 | * @category Statistical Functions |
3543 | - * @param mixed $arg,... Data values |
|
3544 | 3508 | * @return float |
3545 | 3509 | */ |
3546 | 3510 | public static function VARP() |
@@ -3583,7 +3547,6 @@ discard block |
||
3583 | 3547 | * VARPA(value1[,value2[, ...]]) |
3584 | 3548 | * |
3585 | 3549 | * @category Statistical Functions |
3586 | - * @param mixed $arg,... Data values |
|
3587 | 3550 | * @return float |
3588 | 3551 | */ |
3589 | 3552 | public static function VARPA() |
@@ -3668,7 +3631,6 @@ discard block |
||
3668 | 3631 | * @param float $dataSet |
3669 | 3632 | * @param float $m0 Alpha Parameter |
3670 | 3633 | * @param float $sigma Beta Parameter |
3671 | - * @param bool $cumulative |
|
3672 | 3634 | * @return float |
3673 | 3635 | */ |
3674 | 3636 | public static function ZTEST($dataSet, $m0, $sigma = null) |
@@ -520,8 +520,8 @@ |
||
520 | 520 | ]; |
521 | 521 | |
522 | 522 | // Define lower and upper region break-points. |
523 | - $p_low = 0.02425; //Use lower region approx. below this |
|
524 | - $p_high = 1 - $p_low; //Use upper region approx. above this |
|
523 | + $p_low = 0.02425; //Use lower region approx. below this |
|
524 | + $p_high = 1 - $p_low; //Use upper region approx. above this |
|
525 | 525 | |
526 | 526 | if (0 < $p && $p < $p_low) { |
527 | 527 | // Rational approximation for lower region. |
@@ -54,7 +54,7 @@ discard block |
||
54 | 54 | * CHARACTER |
55 | 55 | * |
56 | 56 | * @param string $character Value |
57 | - * @return int |
|
57 | + * @return string |
|
58 | 58 | */ |
59 | 59 | public static function CHARACTER($character) |
60 | 60 | { |
@@ -183,7 +183,7 @@ discard block |
||
183 | 183 | * This function converts a number to text using currency format, with the decimals rounded to the specified place. |
184 | 184 | * The format used is $#,##0.00_);($#,##0.00).. |
185 | 185 | * |
186 | - * @param float $value The value to format |
|
186 | + * @param integer $value The value to format |
|
187 | 187 | * @param int $decimals The number of digits to display to the right of the decimal point. |
188 | 188 | * If decimals is negative, number is rounded to the left of the decimal point. |
189 | 189 | * If you omit decimals, it is assumed to be 2 |
@@ -294,7 +294,7 @@ discard block |
||
294 | 294 | * @param mixed $value Value to check |
295 | 295 | * @param int $decimals |
296 | 296 | * @param bool $no_commas |
297 | - * @return bool |
|
297 | + * @return string |
|
298 | 298 | */ |
299 | 299 | public static function FIXEDFORMAT($value, $decimals = 2, $no_commas = false) |
300 | 300 | { |
@@ -409,7 +409,7 @@ discard block |
||
409 | 409 | * STRINGLENGTH |
410 | 410 | * |
411 | 411 | * @param string $value Value |
412 | - * @return string |
|
412 | + * @return integer |
|
413 | 413 | */ |
414 | 414 | public static function STRINGLENGTH($value = '') |
415 | 415 | { |
@@ -556,7 +556,7 @@ discard block |
||
556 | 556 | * RETURNSTRING |
557 | 557 | * |
558 | 558 | * @param mixed $testValue Value to check |
559 | - * @return bool |
|
559 | + * @return string|null |
|
560 | 560 | */ |
561 | 561 | public static function RETURNSTRING($testValue = '') |
562 | 562 | { |
@@ -574,7 +574,7 @@ discard block |
||
574 | 574 | * |
575 | 575 | * @param mixed $value Value to check |
576 | 576 | * @param string $format Format mask to use |
577 | - * @return bool |
|
577 | + * @return string |
|
578 | 578 | */ |
579 | 579 | public static function TEXTFORMAT($value, $format) |
580 | 580 | { |
@@ -575,7 +575,7 @@ discard block |
||
575 | 575 | * |
576 | 576 | * @param string $pCoordinateString |
577 | 577 | * @throws Exception |
578 | - * @return array Array containing column and row (indexes 0 and 1) |
|
578 | + * @return string[] Array containing column and row (indexes 0 and 1) |
|
579 | 579 | */ |
580 | 580 | public static function coordinateFromString($pCoordinateString = 'A1') |
581 | 581 | { |
@@ -757,7 +757,7 @@ discard block |
||
757 | 757 | * Calculate range boundaries |
758 | 758 | * |
759 | 759 | * @param string $pRange Cell range (e.g. A1:A1) |
760 | - * @return array Range coordinates array(Start Cell, End Cell) |
|
760 | + * @return integer Range coordinates array(Start Cell, End Cell) |
|
761 | 761 | * where Start Cell and End Cell are arrays (Column ID, Row Number) |
762 | 762 | */ |
763 | 763 | public static function getRangeBoundaries($pRange = 'A1:A1') |
@@ -845,11 +845,11 @@ |
||
845 | 845 | $_indexCache[$pColumnIndex] = chr(65 + $pColumnIndex); |
846 | 846 | } elseif ($pColumnIndex < 702) { |
847 | 847 | $_indexCache[$pColumnIndex] = chr(64 + ($pColumnIndex / 26)) . |
848 | - chr(65 + $pColumnIndex % 26); |
|
848 | + chr(65 + $pColumnIndex % 26); |
|
849 | 849 | } else { |
850 | 850 | $_indexCache[$pColumnIndex] = chr(64 + (($pColumnIndex - 26) / 676)) . |
851 | - chr(65 + ((($pColumnIndex - 26) % 676) / 26)) . |
|
852 | - chr(65 + $pColumnIndex % 26); |
|
851 | + chr(65 + ((($pColumnIndex - 26) % 676) / 26)) . |
|
852 | + chr(65 + $pColumnIndex % 26); |
|
853 | 853 | } |
854 | 854 | } |
855 | 855 |
@@ -177,7 +177,7 @@ discard block |
||
177 | 177 | /** |
178 | 178 | * Get Plot Grouping Type |
179 | 179 | * |
180 | - * @return string |
|
180 | + * @return boolean |
|
181 | 181 | */ |
182 | 182 | public function getPlotGrouping() |
183 | 183 | { |
@@ -200,7 +200,7 @@ discard block |
||
200 | 200 | /** |
201 | 201 | * Get Plot Direction |
202 | 202 | * |
203 | - * @return string |
|
203 | + * @return boolean |
|
204 | 204 | */ |
205 | 205 | public function getPlotDirection() |
206 | 206 | { |
@@ -347,7 +347,7 @@ discard block |
||
347 | 347 | /** |
348 | 348 | * Get Smooth Line |
349 | 349 | * |
350 | - * @return bool |
|
350 | + * @return string |
|
351 | 351 | */ |
352 | 352 | public function getSmoothLine() |
353 | 353 | { |
@@ -35,14 +35,14 @@ |
||
35 | 35 | const TYPE_PIECHART = 'pieChart'; |
36 | 36 | const TYPE_PIECHART_3D = 'pie3DChart'; |
37 | 37 | const TYPE_DOUGHTNUTCHART = 'doughnutChart'; |
38 | - const TYPE_DONUTCHART = self::TYPE_DOUGHTNUTCHART; // Synonym |
|
38 | + const TYPE_DONUTCHART = self::TYPE_DOUGHTNUTCHART; // Synonym |
|
39 | 39 | const TYPE_SCATTERCHART = 'scatterChart'; |
40 | 40 | const TYPE_SURFACECHART = 'surfaceChart'; |
41 | 41 | const TYPE_SURFACECHART_3D = 'surface3DChart'; |
42 | 42 | const TYPE_RADARCHART = 'radarChart'; |
43 | 43 | const TYPE_BUBBLECHART = 'bubbleChart'; |
44 | 44 | const TYPE_STOCKCHART = 'stockChart'; |
45 | - const TYPE_CANDLECHART = self::TYPE_STOCKCHART; // Synonym |
|
45 | + const TYPE_CANDLECHART = self::TYPE_STOCKCHART; // Synonym |
|
46 | 46 | |
47 | 47 | const GROUPING_CLUSTERED = 'clustered'; |
48 | 48 | const GROUPING_STACKED = 'stacked'; |
@@ -80,6 +80,7 @@ discard block |
||
80 | 80 | |
81 | 81 | /** |
82 | 82 | * Create a new DataSeriesValues object |
83 | + * @param string $dataSource |
|
83 | 84 | */ |
84 | 85 | public function __construct($dataType = self::DATASERIES_TYPE_NUMBER, $dataSource = null, $formatCode = null, $pointCount = 0, $dataValues = [], $marker = null) |
85 | 86 | { |
@@ -209,7 +210,7 @@ discard block |
||
209 | 210 | /** |
210 | 211 | * Identify if the Data Series is a multi-level or a simple series |
211 | 212 | * |
212 | - * @return bool |
|
213 | + * @return boolean|null |
|
213 | 214 | */ |
214 | 215 | public function isMultiLevelSeries() |
215 | 216 | { |
@@ -223,7 +224,7 @@ discard block |
||
223 | 224 | /** |
224 | 225 | * Return the level count of a multi-level Data Series |
225 | 226 | * |
226 | - * @return bool |
|
227 | + * @return integer |
|
227 | 228 | */ |
228 | 229 | public function multiLevelCount() |
229 | 230 | { |
@@ -387,7 +387,7 @@ |
||
387 | 387 | /** |
388 | 388 | * Get Contiguous |
389 | 389 | * |
390 | - * @return bool |
|
390 | + * @return integer |
|
391 | 391 | */ |
392 | 392 | public function getContiguous() |
393 | 393 | { |
@@ -254,8 +254,8 @@ |
||
254 | 254 | $sheet = $spreadsheet->setActiveSheetIndex($this->sheetIndex); |
255 | 255 | |
256 | 256 | $escapeEnclosures = ['\\' . $this->enclosure, |
257 | - $this->enclosure . $this->enclosure, |
|
258 | - ]; |
|
257 | + $this->enclosure . $this->enclosure, |
|
258 | + ]; |
|
259 | 259 | |
260 | 260 | // Set our starting row based on whether we're in contiguous mode or not |
261 | 261 | $currentRow = 1; |
@@ -260,7 +260,7 @@ |
||
260 | 260 | // Set our starting row based on whether we're in contiguous mode or not |
261 | 261 | $currentRow = 1; |
262 | 262 | if ($this->contiguous) { |
263 | - $currentRow = ($this->contiguousRow == -1) ? $sheet->getHighestRow(): $this->contiguousRow; |
|
263 | + $currentRow = ($this->contiguousRow == -1) ? $sheet->getHighestRow() : $this->contiguousRow; |
|
264 | 264 | } |
265 | 265 | |
266 | 266 | // Loop through each line of the file in turn |