@@ -53,7 +53,7 @@ discard block |
||
53 | 53 | * |
54 | 54 | * @return array|float|string the inverse tangent of the specified x- and y-coordinates, or a string containing an error |
55 | 55 | */ |
56 | - public static function ATAN2($xCoordinate = null, $yCoordinate = null): string|float|array |
|
56 | + public static function ATAN2($xCoordinate = null, $yCoordinate = null): string | float | array |
|
57 | 57 | { |
58 | 58 | return MathTrig\Trig\Tangent::atan2($xCoordinate, $yCoordinate); |
59 | 59 | } |
@@ -76,7 +76,7 @@ discard block |
||
76 | 76 | * |
77 | 77 | * @return array|string the text representation with the given radix (base) |
78 | 78 | */ |
79 | - public static function BASE($number, $radix, $minLength = null): string|array |
|
79 | + public static function BASE($number, $radix, $minLength = null): string | array |
|
80 | 80 | { |
81 | 81 | return MathTrig\Base::evaluate($number, $radix, $minLength); |
82 | 82 | } |
@@ -149,7 +149,7 @@ discard block |
||
149 | 149 | * |
150 | 150 | * @return array|float|string Rounded Number, or a string containing an error |
151 | 151 | */ |
152 | - public static function EVEN($number): string|float|array |
|
152 | + public static function EVEN($number): string | float | array |
|
153 | 153 | { |
154 | 154 | return MathTrig\Round::even($number); |
155 | 155 | } |
@@ -361,7 +361,7 @@ discard block |
||
361 | 361 | * |
362 | 362 | * @return array|float|string The result, or a string containing an error |
363 | 363 | */ |
364 | - public static function logBase($number, $base = 10): string|float|array |
|
364 | + public static function logBase($number, $base = 10): string | float | array |
|
365 | 365 | { |
366 | 366 | return MathTrig\Logarithms::withBase($number, $base); |
367 | 367 | } |
@@ -403,7 +403,7 @@ discard block |
||
403 | 403 | * |
404 | 404 | * @return array|string The result, or a string containing an error |
405 | 405 | */ |
406 | - public static function MINVERSE($matrixValues): string|array |
|
406 | + public static function MINVERSE($matrixValues): string | array |
|
407 | 407 | { |
408 | 408 | return MathTrig\MatrixFunctions::inverse($matrixValues); |
409 | 409 | } |
@@ -420,7 +420,7 @@ discard block |
||
420 | 420 | * |
421 | 421 | * @return array|string The result, or a string containing an error |
422 | 422 | */ |
423 | - public static function MMULT($matrixData1, $matrixData2): string|array |
|
423 | + public static function MMULT($matrixData1, $matrixData2): string | array |
|
424 | 424 | { |
425 | 425 | return MathTrig\MatrixFunctions::multiply($matrixData1, $matrixData2); |
426 | 426 | } |
@@ -456,7 +456,7 @@ discard block |
||
456 | 456 | * |
457 | 457 | * @return array|float|string Rounded Number, or a string containing an error |
458 | 458 | */ |
459 | - public static function MROUND($number, $multiple): string|int|float|array |
|
459 | + public static function MROUND($number, $multiple): string | int | float | array |
|
460 | 460 | { |
461 | 461 | return MathTrig\Round::multiple($number, $multiple); |
462 | 462 | } |
@@ -492,7 +492,7 @@ discard block |
||
492 | 492 | * |
493 | 493 | * @return array|float|int|string Rounded Number, or a string containing an error |
494 | 494 | */ |
495 | - public static function ODD($number): string|int|float|array |
|
495 | + public static function ODD($number): string | int | float | array |
|
496 | 496 | { |
497 | 497 | return MathTrig\Round::odd($number); |
498 | 498 | } |
@@ -569,7 +569,7 @@ discard block |
||
569 | 569 | * |
570 | 570 | * @return array|int|string Random number |
571 | 571 | */ |
572 | - public static function RAND($min = 0, $max = 0): string|int|array |
|
572 | + public static function RAND($min = 0, $max = 0): string | int | array |
|
573 | 573 | { |
574 | 574 | return MathTrig\Random::randBetween($min, $max); |
575 | 575 | } |
@@ -588,7 +588,7 @@ discard block |
||
588 | 588 | * |
589 | 589 | * @return array|string Roman numeral, or a string containing an error |
590 | 590 | */ |
591 | - public static function ROMAN(mixed $aValue, mixed $style = 0): string|array |
|
591 | + public static function ROMAN(mixed $aValue, mixed $style = 0): string | array |
|
592 | 592 | { |
593 | 593 | return MathTrig\Roman::evaluate($aValue, $style); |
594 | 594 | } |
@@ -607,7 +607,7 @@ discard block |
||
607 | 607 | * |
608 | 608 | * @return array|float|string Rounded Number, or a string containing an error |
609 | 609 | */ |
610 | - public static function ROUNDUP($number, $digits): string|float|array |
|
610 | + public static function ROUNDUP($number, $digits): string | float | array |
|
611 | 611 | { |
612 | 612 | return MathTrig\Round::up($number, $digits); |
613 | 613 | } |
@@ -626,7 +626,7 @@ discard block |
||
626 | 626 | * |
627 | 627 | * @return array|float|string Rounded Number, or a string containing an error |
628 | 628 | */ |
629 | - public static function ROUNDDOWN($number, $digits): string|float|array |
|
629 | + public static function ROUNDDOWN($number, $digits): string | float | array |
|
630 | 630 | { |
631 | 631 | return MathTrig\Round::down($number, $digits); |
632 | 632 | } |
@@ -647,7 +647,7 @@ discard block |
||
647 | 647 | * |
648 | 648 | * @return array|float|string The result, or a string containing an error |
649 | 649 | */ |
650 | - public static function SERIESSUM(mixed $x, mixed $n, mixed $m, ...$args): string|float|int|array |
|
650 | + public static function SERIESSUM(mixed $x, mixed $n, mixed $m, ...$args): string | float | int | array |
|
651 | 651 | { |
652 | 652 | return MathTrig\SeriesSum::evaluate($x, $n, $m, ...$args); |
653 | 653 | } |
@@ -666,7 +666,7 @@ discard block |
||
666 | 666 | * |
667 | 667 | * @return array|int|string sign value, or a string containing an error |
668 | 668 | */ |
669 | - public static function SIGN($number): string|int|array |
|
669 | + public static function SIGN($number): string | int | array |
|
670 | 670 | { |
671 | 671 | return MathTrig\Sign::evaluate($number); |
672 | 672 | } |
@@ -696,7 +696,7 @@ discard block |
||
696 | 696 | * |
697 | 697 | * @return array|float|string Square Root of Number * Pi, or a string containing an error |
698 | 698 | */ |
699 | - public static function SQRTPI($number): string|float|array |
|
699 | + public static function SQRTPI($number): string | float | array |
|
700 | 700 | { |
701 | 701 | return MathTrig\Sqrt::pi($number); |
702 | 702 | } |
@@ -804,7 +804,7 @@ discard block |
||
804 | 804 | * |
805 | 805 | * @return float|string The result, or a string containing an error |
806 | 806 | */ |
807 | - public static function SUMPRODUCT(mixed ...$args): string|int|float |
|
807 | + public static function SUMPRODUCT(mixed ...$args): string | int | float |
|
808 | 808 | { |
809 | 809 | return MathTrig\Sum::product(...$args); |
810 | 810 | } |
@@ -1074,7 +1074,7 @@ discard block |
||
1074 | 1074 | * |
1075 | 1075 | * @return array|float|string Rounded number |
1076 | 1076 | */ |
1077 | - public static function builtinROUND($number, $precision): string|float|array |
|
1077 | + public static function builtinROUND($number, $precision): string | float | array |
|
1078 | 1078 | { |
1079 | 1079 | return MathTrig\Round::round($number, $precision); |
1080 | 1080 | } |
@@ -1092,7 +1092,7 @@ discard block |
||
1092 | 1092 | * |
1093 | 1093 | * @return array|float|int|string Rounded number |
1094 | 1094 | */ |
1095 | - public static function builtinABS($number): string|int|float|array |
|
1095 | + public static function builtinABS($number): string | int | float | array |
|
1096 | 1096 | { |
1097 | 1097 | return MathTrig\Absolute::evaluate($number); |
1098 | 1098 | } |
@@ -1218,7 +1218,7 @@ discard block |
||
1218 | 1218 | * |
1219 | 1219 | * @return array|float|string Rounded number |
1220 | 1220 | */ |
1221 | - public static function builtinCOS($number): string|float|array |
|
1221 | + public static function builtinCOS($number): string | float | array |
|
1222 | 1222 | { |
1223 | 1223 | return MathTrig\Trig\Cosine::cos($number); |
1224 | 1224 | } |
@@ -1236,7 +1236,7 @@ discard block |
||
1236 | 1236 | * |
1237 | 1237 | * @return array|float|string Rounded number |
1238 | 1238 | */ |
1239 | - public static function builtinCOSH($number): string|float|array |
|
1239 | + public static function builtinCOSH($number): string | float | array |
|
1240 | 1240 | { |
1241 | 1241 | return MathTrig\Trig\Cosine::cosh($number); |
1242 | 1242 | } |
@@ -1254,7 +1254,7 @@ discard block |
||
1254 | 1254 | * |
1255 | 1255 | * @return array|float|string Rounded number |
1256 | 1256 | */ |
1257 | - public static function builtinDEGREES($number): string|float|array |
|
1257 | + public static function builtinDEGREES($number): string | float | array |
|
1258 | 1258 | { |
1259 | 1259 | return MathTrig\Angle::toDegrees($number); |
1260 | 1260 | } |
@@ -1272,7 +1272,7 @@ discard block |
||
1272 | 1272 | * |
1273 | 1273 | * @return array|float|string Rounded number |
1274 | 1274 | */ |
1275 | - public static function builtinEXP($number): string|float|array |
|
1275 | + public static function builtinEXP($number): string | float | array |
|
1276 | 1276 | { |
1277 | 1277 | return MathTrig\Exp::evaluate($number); |
1278 | 1278 | } |
@@ -1290,7 +1290,7 @@ discard block |
||
1290 | 1290 | * |
1291 | 1291 | * @return array|float|string Rounded number |
1292 | 1292 | */ |
1293 | - public static function builtinLN(mixed $number): string|float|array |
|
1293 | + public static function builtinLN(mixed $number): string | float | array |
|
1294 | 1294 | { |
1295 | 1295 | return MathTrig\Logarithms::natural($number); |
1296 | 1296 | } |
@@ -1308,7 +1308,7 @@ discard block |
||
1308 | 1308 | * |
1309 | 1309 | * @return array|float|string Rounded number |
1310 | 1310 | */ |
1311 | - public static function builtinLOG10(mixed $number): string|float|array |
|
1311 | + public static function builtinLOG10(mixed $number): string | float | array |
|
1312 | 1312 | { |
1313 | 1313 | return MathTrig\Logarithms::base10($number); |
1314 | 1314 | } |
@@ -1326,7 +1326,7 @@ discard block |
||
1326 | 1326 | * |
1327 | 1327 | * @return array|float|string Rounded number |
1328 | 1328 | */ |
1329 | - public static function builtinRADIANS($number): string|float|array |
|
1329 | + public static function builtinRADIANS($number): string | float | array |
|
1330 | 1330 | { |
1331 | 1331 | return MathTrig\Angle::toRadians($number); |
1332 | 1332 | } |
@@ -1344,7 +1344,7 @@ discard block |
||
1344 | 1344 | * |
1345 | 1345 | * @return array|float|string sine |
1346 | 1346 | */ |
1347 | - public static function builtinSIN($number): string|float|array |
|
1347 | + public static function builtinSIN($number): string | float | array |
|
1348 | 1348 | { |
1349 | 1349 | return MathTrig\Trig\Sine::sin($number); |
1350 | 1350 | } |
@@ -1362,7 +1362,7 @@ discard block |
||
1362 | 1362 | * |
1363 | 1363 | * @return array|float|string Rounded number |
1364 | 1364 | */ |
1365 | - public static function builtinSINH($number): string|float|array |
|
1365 | + public static function builtinSINH($number): string | float | array |
|
1366 | 1366 | { |
1367 | 1367 | return MathTrig\Trig\Sine::sinh($number); |
1368 | 1368 | } |
@@ -1416,7 +1416,7 @@ discard block |
||
1416 | 1416 | * |
1417 | 1417 | * @return array|float|string Rounded number |
1418 | 1418 | */ |
1419 | - public static function builtinTANH($number): string|float|array |
|
1419 | + public static function builtinTANH($number): string | float | array |
|
1420 | 1420 | { |
1421 | 1421 | return MathTrig\Trig\Tangent::tanh($number); |
1422 | 1422 | } |
@@ -35,7 +35,7 @@ |
||
35 | 35 | * If an array of numbers is passed as an argument, then the returned result will also be an array |
36 | 36 | * with the same dimensions |
37 | 37 | */ |
38 | - public static function ERF(mixed $lower, mixed $upper = null): array|float|string |
|
38 | + public static function ERF(mixed $lower, mixed $upper = null): array | float | string |
|
39 | 39 | { |
40 | 40 | if (is_array($lower) || is_array($upper)) { |
41 | 41 | return self::evaluateArrayArguments([self::class, __FUNCTION__], $lower, $upper); |
@@ -34,7 +34,7 @@ |
||
34 | 34 | * If an array of numbers is passed as an argument, then the returned result will also be an array |
35 | 35 | * with the same dimensions |
36 | 36 | */ |
37 | - public static function BESSELJ(mixed $x, mixed $ord): array|string|float |
|
37 | + public static function BESSELJ(mixed $x, mixed $ord): array | string | float |
|
38 | 38 | { |
39 | 39 | if (is_array($x) || is_array($ord)) { |
40 | 40 | return self::evaluateArrayArguments([self::class, __FUNCTION__], $x, $ord); |
@@ -32,7 +32,7 @@ |
||
32 | 32 | * If an array of numbers is passed as an argument, then the returned result will also be an array |
33 | 33 | * with the same dimensions |
34 | 34 | */ |
35 | - public static function BESSELK(mixed $x, mixed $ord): array|string|float |
|
35 | + public static function BESSELK(mixed $x, mixed $ord): array | string | float |
|
36 | 36 | { |
37 | 37 | if (is_array($x) || is_array($ord)) { |
38 | 38 | return self::evaluateArrayArguments([self::class, __FUNCTION__], $x, $ord); |
@@ -32,7 +32,7 @@ discard block |
||
32 | 32 | * If an array of numbers is passed as an argument, then the returned result will also be an array |
33 | 33 | * with the same dimensions |
34 | 34 | */ |
35 | - public static function COMPLEX(mixed $realNumber = 0.0, mixed $imaginary = 0.0, mixed $suffix = 'i'): array|string |
|
35 | + public static function COMPLEX(mixed $realNumber = 0.0, mixed $imaginary = 0.0, mixed $suffix = 'i'): array | string |
|
36 | 36 | { |
37 | 37 | if (is_array($realNumber) || is_array($imaginary) || is_array($suffix)) { |
38 | 38 | return self::evaluateArrayArguments([self::class, __FUNCTION__], $realNumber, $imaginary, $suffix); |
@@ -74,7 +74,7 @@ discard block |
||
74 | 74 | * If an array of numbers is passed as an argument, then the returned result will also be an array |
75 | 75 | * with the same dimensions |
76 | 76 | */ |
77 | - public static function IMAGINARY($complexNumber): array|string|float |
|
77 | + public static function IMAGINARY($complexNumber): array | string | float |
|
78 | 78 | { |
79 | 79 | if (is_array($complexNumber)) { |
80 | 80 | return self::evaluateSingleArgumentArray([self::class, __FUNCTION__], $complexNumber); |
@@ -104,7 +104,7 @@ discard block |
||
104 | 104 | * If an array of numbers is passed as an argument, then the returned result will also be an array |
105 | 105 | * with the same dimensions |
106 | 106 | */ |
107 | - public static function IMREAL($complexNumber): array|string|float |
|
107 | + public static function IMREAL($complexNumber): array | string | float |
|
108 | 108 | { |
109 | 109 | if (is_array($complexNumber)) { |
110 | 110 | return self::evaluateSingleArgumentArray([self::class, __FUNCTION__], $complexNumber); |
@@ -35,7 +35,7 @@ |
||
35 | 35 | * If an array of numbers is passed as an argument, then the returned result will also be an array |
36 | 36 | * with the same dimensions |
37 | 37 | */ |
38 | - public static function BESSELI(mixed $x, mixed $ord): array|string|float |
|
38 | + public static function BESSELI(mixed $x, mixed $ord): array | string | float |
|
39 | 39 | { |
40 | 40 | if (is_array($x) || is_array($ord)) { |
41 | 41 | return self::evaluateArrayArguments([self::class, __FUNCTION__], $x, $ord); |
@@ -31,7 +31,7 @@ |
||
31 | 31 | * If an array of numbers is passed as an argument, then the returned result will also be an array |
32 | 32 | * with the same dimensions |
33 | 33 | */ |
34 | - public static function BESSELY(mixed $x, mixed $ord): array|string|float |
|
34 | + public static function BESSELY(mixed $x, mixed $ord): array | string | float |
|
35 | 35 | { |
36 | 36 | if (is_array($x) || is_array($ord)) { |
37 | 37 | return self::evaluateArrayArguments([self::class, __FUNCTION__], $x, $ord); |
@@ -50,7 +50,7 @@ discard block |
||
50 | 50 | * |
51 | 51 | * @param mixed $stringValue Value to check |
52 | 52 | */ |
53 | - public static function TRIMSPACES(mixed $stringValue = ''): string|array |
|
53 | + public static function TRIMSPACES(mixed $stringValue = ''): string | array |
|
54 | 54 | { |
55 | 55 | return TextData\Trim::spaces($stringValue); |
56 | 56 | } |
@@ -66,7 +66,7 @@ discard block |
||
66 | 66 | * |
67 | 67 | * @return array|int|string A string if arguments are invalid |
68 | 68 | */ |
69 | - public static function ASCIICODE($characters): string|int|array |
|
69 | + public static function ASCIICODE($characters): string | int | array |
|
70 | 70 | { |
71 | 71 | return TextData\CharacterConvert::code($characters); |
72 | 72 | } |
@@ -171,7 +171,7 @@ discard block |
||
171 | 171 | * @param array|string $value Value |
172 | 172 | * @param array|int $chars Number of characters |
173 | 173 | */ |
174 | - public static function LEFT($value = '', $chars = 1): string|array |
|
174 | + public static function LEFT($value = '', $chars = 1): string | array |
|
175 | 175 | { |
176 | 176 | return TextData\Extract::left($value, $chars); |
177 | 177 | } |
@@ -187,7 +187,7 @@ discard block |
||
187 | 187 | * @param array|int $start Start character |
188 | 188 | * @param array|int $chars Number of characters |
189 | 189 | */ |
190 | - public static function MID($value = '', $start = 1, $chars = null): string|array |
|
190 | + public static function MID($value = '', $start = 1, $chars = null): string | array |
|
191 | 191 | { |
192 | 192 | return TextData\Extract::mid($value, $start, $chars); |
193 | 193 | } |
@@ -202,7 +202,7 @@ discard block |
||
202 | 202 | * @param array|string $value Value |
203 | 203 | * @param array|int $chars Number of characters |
204 | 204 | */ |
205 | - public static function RIGHT($value = '', $chars = 1): string|array |
|
205 | + public static function RIGHT($value = '', $chars = 1): string | array |
|
206 | 206 | { |
207 | 207 | return TextData\Extract::right($value, $chars); |
208 | 208 | } |
@@ -216,7 +216,7 @@ discard block |
||
216 | 216 | * |
217 | 217 | * @param string $value Value |
218 | 218 | */ |
219 | - public static function STRINGLENGTH($value = ''): int|array |
|
219 | + public static function STRINGLENGTH($value = ''): int | array |
|
220 | 220 | { |
221 | 221 | return TextData\Text::length($value); |
222 | 222 | } |
@@ -232,7 +232,7 @@ discard block |
||
232 | 232 | * |
233 | 233 | * @param array|string $mixedCaseString |
234 | 234 | */ |
235 | - public static function LOWERCASE($mixedCaseString): string|array |
|
235 | + public static function LOWERCASE($mixedCaseString): string | array |
|
236 | 236 | { |
237 | 237 | return TextData\CaseConvert::lower($mixedCaseString); |
238 | 238 | } |
@@ -248,7 +248,7 @@ discard block |
||
248 | 248 | * |
249 | 249 | * @param string $mixedCaseString |
250 | 250 | */ |
251 | - public static function UPPERCASE($mixedCaseString): string|array |
|
251 | + public static function UPPERCASE($mixedCaseString): string | array |
|
252 | 252 | { |
253 | 253 | return TextData\CaseConvert::upper($mixedCaseString); |
254 | 254 | } |
@@ -264,7 +264,7 @@ discard block |
||
264 | 264 | * |
265 | 265 | * @param array|string $mixedCaseString |
266 | 266 | */ |
267 | - public static function PROPERCASE($mixedCaseString): string|array |
|
267 | + public static function PROPERCASE($mixedCaseString): string | array |
|
268 | 268 | { |
269 | 269 | return TextData\CaseConvert::proper($mixedCaseString); |
270 | 270 | } |
@@ -316,7 +316,7 @@ discard block |
||
316 | 316 | * |
317 | 317 | * @param mixed $testValue Value to check |
318 | 318 | */ |
319 | - public static function RETURNSTRING(mixed $testValue = ''): string|array |
|
319 | + public static function RETURNSTRING(mixed $testValue = ''): string | array |
|
320 | 320 | { |
321 | 321 | return TextData\Text::test($testValue); |
322 | 322 | } |
@@ -381,7 +381,7 @@ discard block |
||
381 | 381 | * Use the exact() method in the TextData\Text class instead |
382 | 382 | * @see TextData\Text::exact() |
383 | 383 | */ |
384 | - public static function EXACT(mixed $value1, mixed $value2): bool|array |
|
384 | + public static function EXACT(mixed $value1, mixed $value2): bool | array |
|
385 | 385 | { |
386 | 386 | return TextData\Text::exact($value1, $value2); |
387 | 387 | } |
@@ -41,7 +41,7 @@ discard block |
||
41 | 41 | * FALSE CELL_ADDRESS returns an R1C1-style reference |
42 | 42 | * @param array|string $sheetText Optional Name of worksheet to use |
43 | 43 | */ |
44 | - public static function cellAddress(mixed $row, mixed $column, $relativity = 1, $referenceStyle = true, $sheetText = ''): string|array |
|
44 | + public static function cellAddress(mixed $row, mixed $column, $relativity = 1, $referenceStyle = true, $sheetText = ''): string | array |
|
45 | 45 | { |
46 | 46 | return Address::cell($row, $column, $relativity, $referenceStyle, $sheetText); |
47 | 47 | } |
@@ -268,7 +268,7 @@ discard block |
||
268 | 268 | * |
269 | 269 | * @return array|float|int|string The relative position of the found item |
270 | 270 | */ |
271 | - public static function MATCH(mixed $lookupValue, mixed $lookupArray, mixed $matchType = 1): array|float|int|string |
|
271 | + public static function MATCH(mixed $lookupValue, mixed $lookupArray, mixed $matchType = 1): array | float | int | string |
|
272 | 272 | { |
273 | 273 | return LookupRef\ExcelMatch::MATCH($lookupValue, $lookupArray, $matchType); |
274 | 274 | } |