@@ -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 | } |
@@ -116,7 +116,7 @@ |
||
116 | 116 | * If an array of values is passed as an argument, then the returned result will also be an array |
117 | 117 | * with the same dimensions |
118 | 118 | */ |
119 | - public static function NOT(mixed $logical = false): array|bool|string |
|
119 | + public static function NOT(mixed $logical = false): array | bool | string |
|
120 | 120 | { |
121 | 121 | if (is_array($logical)) { |
122 | 122 | return self::evaluateSingleArgumentArray([self::class, __FUNCTION__], $logical); |
@@ -62,7 +62,7 @@ |
||
62 | 62 | * |
63 | 63 | * @return string the url encoded output |
64 | 64 | */ |
65 | - public static function urlEncode(mixed $text): string|array |
|
65 | + public static function urlEncode(mixed $text): string | array |
|
66 | 66 | { |
67 | 67 | if (!is_string($text)) { |
68 | 68 | return ExcelError::VALUE(); |
@@ -25,7 +25,7 @@ discard block |
||
25 | 25 | * |
26 | 26 | * @return float|string |
27 | 27 | */ |
28 | - public static function geometric(mixed ...$args): float|int|string |
|
28 | + public static function geometric(mixed ...$args): float | int | string |
|
29 | 29 | { |
30 | 30 | $aArgs = Functions::flattenArray($args); |
31 | 31 | |
@@ -53,7 +53,7 @@ discard block |
||
53 | 53 | * |
54 | 54 | * @return float|string |
55 | 55 | */ |
56 | - public static function harmonic(mixed ...$args): string|float|int |
|
56 | + public static function harmonic(mixed ...$args): string | float | int |
|
57 | 57 | { |
58 | 58 | // Loop through arguments |
59 | 59 | $aArgs = Functions::flattenArray($args); |
@@ -28,7 +28,7 @@ |
||
28 | 28 | * If an array of numbers is passed as an argument, then the returned result will also be an array |
29 | 29 | * with the same dimensions |
30 | 30 | */ |
31 | - public static function distribution(mixed $value, mixed $lambda, mixed $cumulative): array|string|float |
|
31 | + public static function distribution(mixed $value, mixed $lambda, mixed $cumulative): array | string | float |
|
32 | 32 | { |
33 | 33 | if (is_array($value) || is_array($lambda) || is_array($cumulative)) { |
34 | 34 | return self::evaluateArrayArguments([self::class, __FUNCTION__], $value, $lambda, $cumulative); |
@@ -83,7 +83,7 @@ discard block |
||
83 | 83 | * If an array of numbers is passed as an argument, then the returned result will also be an array |
84 | 84 | * with the same dimensions |
85 | 85 | */ |
86 | - public static function range(mixed $trials, mixed $probability, mixed $successes, mixed $limit = null): array|string|float|int |
|
86 | + public static function range(mixed $trials, mixed $probability, mixed $successes, mixed $limit = null): array | string | float | int |
|
87 | 87 | { |
88 | 88 | if (is_array($trials) || is_array($probability) || is_array($successes) || is_array($limit)) { |
89 | 89 | return self::evaluateArrayArguments([self::class, __FUNCTION__], $trials, $probability, $successes, $limit); |
@@ -141,7 +141,7 @@ discard block |
||
141 | 141 | * TODO Add support for the cumulative flag not present for NEGBINOMDIST, but introduced for NEGBINOM.DIST |
142 | 142 | * The cumulative default should be false to reflect the behaviour of NEGBINOMDIST |
143 | 143 | */ |
144 | - public static function negative(mixed $failures, mixed $successes, mixed $probability): array|string|float |
|
144 | + public static function negative(mixed $failures, mixed $successes, mixed $probability): array | string | float |
|
145 | 145 | { |
146 | 146 | if (is_array($failures) || is_array($successes) || is_array($probability)) { |
147 | 147 | return self::evaluateArrayArguments([self::class, __FUNCTION__], $failures, $successes, $probability); |
@@ -187,7 +187,7 @@ discard block |
||
187 | 187 | * If an array of numbers is passed as an argument, then the returned result will also be an array |
188 | 188 | * with the same dimensions |
189 | 189 | */ |
190 | - public static function inverse(mixed $trials, mixed $probability, mixed $alpha): array|string|int |
|
190 | + public static function inverse(mixed $trials, mixed $probability, mixed $alpha): array | string | int |
|
191 | 191 | { |
192 | 192 | if (is_array($trials) || is_array($probability) || is_array($alpha)) { |
193 | 193 | return self::evaluateArrayArguments([self::class, __FUNCTION__], $trials, $probability, $alpha); |
@@ -219,7 +219,7 @@ discard block |
||
219 | 219 | return $successes; |
220 | 220 | } |
221 | 221 | |
222 | - private static function calculateCumulativeBinomial(int $value, int $trials, float $probability): float|int |
|
222 | + private static function calculateCumulativeBinomial(int $value, int $trials, float $probability): float | int |
|
223 | 223 | { |
224 | 224 | $summer = 0; |
225 | 225 | for ($i = 0; $i <= $value; ++$i) { |
@@ -114,7 +114,7 @@ |
||
114 | 114 | * accuracy if I can get my head round the mathematics |
115 | 115 | * (as described at) http://home.online.no/~pjacklam/notes/invnorm/ |
116 | 116 | */ |
117 | - public static function inverse(mixed $probability, mixed $mean, mixed $stdDev): array|string|float |
|
117 | + public static function inverse(mixed $probability, mixed $mean, mixed $stdDev): array | string | float |
|
118 | 118 | { |
119 | 119 | if (is_array($probability) || is_array($mean) || is_array($stdDev)) { |
120 | 120 | return self::evaluateArrayArguments([self::class, __FUNCTION__], $probability, $mean, $stdDev); |