@@ -28,7 +28,7 @@ discard block |
||
28 | 28 | * @return array|string If an array of values is passed for either of the arguments, then the returned result |
29 | 29 | * will also be an array with matching dimensions |
30 | 30 | */ |
31 | - public static function replace(mixed $oldText, mixed $start, mixed $chars, mixed $newText): array|string |
|
31 | + public static function replace(mixed $oldText, mixed $start, mixed $chars, mixed $newText): array | string |
|
32 | 32 | { |
33 | 33 | if (is_array($oldText) || is_array($start) || is_array($chars) || is_array($newText)) { |
34 | 34 | return self::evaluateArrayArguments([self::class, __FUNCTION__], $oldText, $start, $chars, $newText); |
@@ -68,7 +68,7 @@ discard block |
||
68 | 68 | * @return array|string If an array of values is passed for either of the arguments, then the returned result |
69 | 69 | * will also be an array with matching dimensions |
70 | 70 | */ |
71 | - public static function substitute(mixed $text = '', mixed $fromText = '', mixed $toText = '', mixed $instance = null): array|string |
|
71 | + public static function substitute(mixed $text = '', mixed $fromText = '', mixed $toText = '', mixed $instance = null): array | string |
|
72 | 72 | { |
73 | 73 | if (is_array($text) || is_array($fromText) || is_array($toText) || is_array($instance)) { |
74 | 74 | return self::evaluateArrayArguments([self::class, __FUNCTION__], $text, $fromText, $toText, $instance); |
@@ -23,7 +23,7 @@ discard block |
||
23 | 23 | * @return array|bool If an array of numbers is passed as an argument, then the returned result will also be an array |
24 | 24 | * with the same dimensions |
25 | 25 | */ |
26 | - public static function isBlank(mixed $value = null): array|bool |
|
26 | + public static function isBlank(mixed $value = null): array | bool |
|
27 | 27 | { |
28 | 28 | if (is_array($value)) { |
29 | 29 | return self::evaluateSingleArgumentArray([self::class, __FUNCTION__], $value); |
@@ -71,7 +71,7 @@ discard block |
||
71 | 71 | * @return array|bool|string If an array of numbers is passed as an argument, then the returned result will also be an array |
72 | 72 | * with the same dimensions |
73 | 73 | */ |
74 | - public static function isEven(mixed $value = null): array|string|bool |
|
74 | + public static function isEven(mixed $value = null): array | string | bool |
|
75 | 75 | { |
76 | 76 | if (is_array($value)) { |
77 | 77 | return self::evaluateSingleArgumentArray([self::class, __FUNCTION__], $value); |
@@ -95,7 +95,7 @@ discard block |
||
95 | 95 | * @return array|bool|string If an array of numbers is passed as an argument, then the returned result will also be an array |
96 | 96 | * with the same dimensions |
97 | 97 | */ |
98 | - public static function isOdd(mixed $value = null): array|string|bool |
|
98 | + public static function isOdd(mixed $value = null): array | string | bool |
|
99 | 99 | { |
100 | 100 | if (is_array($value)) { |
101 | 101 | return self::evaluateSingleArgumentArray([self::class, __FUNCTION__], $value); |
@@ -119,7 +119,7 @@ discard block |
||
119 | 119 | * @return array|bool If an array of numbers is passed as an argument, then the returned result will also be an array |
120 | 120 | * with the same dimensions |
121 | 121 | */ |
122 | - public static function isNumber(mixed $value = null): array|bool |
|
122 | + public static function isNumber(mixed $value = null): array | bool |
|
123 | 123 | { |
124 | 124 | if (is_array($value)) { |
125 | 125 | return self::evaluateSingleArgumentArray([self::class, __FUNCTION__], $value); |
@@ -141,7 +141,7 @@ discard block |
||
141 | 141 | * @return array|bool If an array of numbers is passed as an argument, then the returned result will also be an array |
142 | 142 | * with the same dimensions |
143 | 143 | */ |
144 | - public static function isLogical(mixed $value = null): array|bool |
|
144 | + public static function isLogical(mixed $value = null): array | bool |
|
145 | 145 | { |
146 | 146 | if (is_array($value)) { |
147 | 147 | return self::evaluateSingleArgumentArray([self::class, __FUNCTION__], $value); |
@@ -159,7 +159,7 @@ discard block |
||
159 | 159 | * @return array|bool If an array of numbers is passed as an argument, then the returned result will also be an array |
160 | 160 | * with the same dimensions |
161 | 161 | */ |
162 | - public static function isText(mixed $value = null): array|bool |
|
162 | + public static function isText(mixed $value = null): array | bool |
|
163 | 163 | { |
164 | 164 | if (is_array($value)) { |
165 | 165 | return self::evaluateSingleArgumentArray([self::class, __FUNCTION__], $value); |
@@ -177,7 +177,7 @@ discard block |
||
177 | 177 | * @return array|bool If an array of numbers is passed as an argument, then the returned result will also be an array |
178 | 178 | * with the same dimensions |
179 | 179 | */ |
180 | - public static function isNonText(mixed $value = null): array|bool |
|
180 | + public static function isNonText(mixed $value = null): array | bool |
|
181 | 181 | { |
182 | 182 | if (is_array($value)) { |
183 | 183 | return self::evaluateSingleArgumentArray([self::class, __FUNCTION__], $value); |
@@ -192,7 +192,7 @@ discard block |
||
192 | 192 | * @param mixed $cellReference The cell to check |
193 | 193 | * @param ?Cell $cell The current cell (containing this formula) |
194 | 194 | */ |
195 | - public static function isFormula(mixed $cellReference = '', ?Cell $cell = null): array|bool|string |
|
195 | + public static function isFormula(mixed $cellReference = '', ?Cell $cell = null): array | bool | string |
|
196 | 196 | { |
197 | 197 | if ($cell === null) { |
198 | 198 | return ExcelError::REF(); |
@@ -17,7 +17,7 @@ discard block |
||
17 | 17 | * |
18 | 18 | * @param mixed ...$args Data values |
19 | 19 | */ |
20 | - public static function sumSquares(mixed ...$args): string|float |
|
20 | + public static function sumSquares(mixed ...$args): string | float |
|
21 | 21 | { |
22 | 22 | $aArgs = Functions::flattenArrayIndexed($args); |
23 | 23 | |
@@ -57,7 +57,7 @@ discard block |
||
57 | 57 | * |
58 | 58 | * @param array ...$args Data Series |
59 | 59 | */ |
60 | - public static function kurtosis(...$args): string|int|float |
|
60 | + public static function kurtosis(...$args): string | int | float |
|
61 | 61 | { |
62 | 62 | $aArgs = Functions::flattenArrayIndexed($args); |
63 | 63 | $mean = Averages::average($aArgs); |
@@ -102,7 +102,7 @@ discard block |
||
102 | 102 | * |
103 | 103 | * @return float|int|string The result, or a string containing an error |
104 | 104 | */ |
105 | - public static function skew(...$args): string|int|float |
|
105 | + public static function skew(...$args): string | int | float |
|
106 | 106 | { |
107 | 107 | $aArgs = Functions::flattenArrayIndexed($args); |
108 | 108 | $mean = Averages::average($aArgs); |
@@ -18,7 +18,7 @@ discard block |
||
18 | 18 | * |
19 | 19 | * @param mixed ...$args Data values |
20 | 20 | */ |
21 | - public static function min(mixed ...$args): float|int|string |
|
21 | + public static function min(mixed ...$args): float | int | string |
|
22 | 22 | { |
23 | 23 | $returnValue = null; |
24 | 24 | |
@@ -55,7 +55,7 @@ discard block |
||
55 | 55 | * |
56 | 56 | * @param mixed ...$args Data values |
57 | 57 | */ |
58 | - public static function minA(mixed ...$args): float|int|string |
|
58 | + public static function minA(mixed ...$args): float | int | string |
|
59 | 59 | { |
60 | 60 | $returnValue = null; |
61 | 61 |
@@ -65,7 +65,7 @@ discard block |
||
65 | 65 | * @param mixed $yValues array of mixed Data Series Y |
66 | 66 | * @param null|mixed $xValues array of mixed Data Series X |
67 | 67 | */ |
68 | - public static function CORREL(mixed $yValues, $xValues = null): float|string |
|
68 | + public static function CORREL(mixed $yValues, $xValues = null): float | string |
|
69 | 69 | { |
70 | 70 | if (($xValues === null) || (!is_array($yValues)) || (!is_array($xValues))) { |
71 | 71 | return ExcelError::VALUE(); |
@@ -91,7 +91,7 @@ discard block |
||
91 | 91 | * @param mixed[] $yValues array of mixed Data Series Y |
92 | 92 | * @param mixed[] $xValues array of mixed Data Series X |
93 | 93 | */ |
94 | - public static function COVAR(array $yValues, array $xValues): float|string |
|
94 | + public static function COVAR(array $yValues, array $xValues): float | string |
|
95 | 95 | { |
96 | 96 | try { |
97 | 97 | self::checkTrendArrays($yValues, $xValues); |
@@ -178,7 +178,7 @@ discard block |
||
178 | 178 | * @param mixed[] $yValues Data Series Y |
179 | 179 | * @param mixed[] $xValues Data Series X |
180 | 180 | */ |
181 | - public static function INTERCEPT(array $yValues, array $xValues): float|string |
|
181 | + public static function INTERCEPT(array $yValues, array $xValues): float | string |
|
182 | 182 | { |
183 | 183 | try { |
184 | 184 | self::checkTrendArrays($yValues, $xValues); |
@@ -205,7 +205,7 @@ discard block |
||
205 | 205 | * |
206 | 206 | * @return array|string The result, or a string containing an error |
207 | 207 | */ |
208 | - public static function LINEST(array $yValues, ?array $xValues = null, mixed $const = true, mixed $stats = false): string|array |
|
208 | + public static function LINEST(array $yValues, ?array $xValues = null, mixed $const = true, mixed $stats = false): string | array |
|
209 | 209 | { |
210 | 210 | $const = ($const === null) ? true : (bool) Functions::flattenSingleValue($const); |
211 | 211 | $stats = ($stats === null) ? false : (bool) Functions::flattenSingleValue($stats); |
@@ -266,7 +266,7 @@ discard block |
||
266 | 266 | * |
267 | 267 | * @return array|string The result, or a string containing an error |
268 | 268 | */ |
269 | - public static function LOGEST(array $yValues, ?array $xValues = null, mixed $const = true, mixed $stats = false): string|array |
|
269 | + public static function LOGEST(array $yValues, ?array $xValues = null, mixed $const = true, mixed $stats = false): string | array |
|
270 | 270 | { |
271 | 271 | $const = ($const === null) ? true : (bool) Functions::flattenSingleValue($const); |
272 | 272 | $stats = ($stats === null) ? false : (bool) Functions::flattenSingleValue($stats); |
@@ -377,7 +377,7 @@ discard block |
||
377 | 377 | * @param mixed[] $yValues Data Series Y |
378 | 378 | * @param mixed[] $xValues Data Series X |
379 | 379 | */ |
380 | - public static function STEYX(array $yValues, array $xValues): float|string |
|
380 | + public static function STEYX(array $yValues, array $xValues): float | string |
|
381 | 381 | { |
382 | 382 | try { |
383 | 383 | self::checkTrendArrays($yValues, $xValues); |
@@ -37,7 +37,7 @@ discard block |
||
37 | 37 | * |
38 | 38 | * @param mixed ...$args Data values |
39 | 39 | */ |
40 | - public static function STDEVA(mixed ...$args): float|string |
|
40 | + public static function STDEVA(mixed ...$args): float | string |
|
41 | 41 | { |
42 | 42 | $result = Variances::VARA(...$args); |
43 | 43 | if (!is_numeric($result)) { |
@@ -57,7 +57,7 @@ discard block |
||
57 | 57 | * |
58 | 58 | * @param mixed ...$args Data values |
59 | 59 | */ |
60 | - public static function STDEVP(mixed ...$args): float|string |
|
60 | + public static function STDEVP(mixed ...$args): float | string |
|
61 | 61 | { |
62 | 62 | $result = Variances::VARP(...$args); |
63 | 63 | if (!is_numeric($result)) { |
@@ -77,7 +77,7 @@ discard block |
||
77 | 77 | * |
78 | 78 | * @param mixed ...$args Data values |
79 | 79 | */ |
80 | - public static function STDEVPA(mixed ...$args): float|string |
|
80 | + public static function STDEVPA(mixed ...$args): float | string |
|
81 | 81 | { |
82 | 82 | $result = Variances::VARPA(...$args); |
83 | 83 | if (!is_numeric($result)) { |
@@ -18,7 +18,7 @@ discard block |
||
18 | 18 | * |
19 | 19 | * @param mixed ...$args Data values |
20 | 20 | */ |
21 | - public static function max(mixed ...$args): float|int|string |
|
21 | + public static function max(mixed ...$args): float | int | string |
|
22 | 22 | { |
23 | 23 | $returnValue = null; |
24 | 24 | |
@@ -55,7 +55,7 @@ discard block |
||
55 | 55 | * |
56 | 56 | * @param mixed ...$args Data values |
57 | 57 | */ |
58 | - public static function maxA(mixed ...$args): float|int|string |
|
58 | + public static function maxA(mixed ...$args): float | int | string |
|
59 | 59 | { |
60 | 60 | $returnValue = null; |
61 | 61 |
@@ -23,7 +23,7 @@ discard block |
||
23 | 23 | * |
24 | 24 | * @param mixed ...$args Data values |
25 | 25 | */ |
26 | - public static function geometric(mixed ...$args): float|int|string |
|
26 | + public static function geometric(mixed ...$args): float | int | string |
|
27 | 27 | { |
28 | 28 | $aArgs = Functions::flattenArray($args); |
29 | 29 | |
@@ -49,7 +49,7 @@ discard block |
||
49 | 49 | * |
50 | 50 | * @param mixed ...$args Data values |
51 | 51 | */ |
52 | - public static function harmonic(mixed ...$args): string|float|int |
|
52 | + public static function harmonic(mixed ...$args): string | float | int |
|
53 | 53 | { |
54 | 54 | // Loop through arguments |
55 | 55 | $aArgs = Functions::flattenArray($args); |
@@ -90,7 +90,7 @@ discard block |
||
90 | 90 | * |
91 | 91 | * @param mixed $args Data values |
92 | 92 | */ |
93 | - public static function trim(mixed ...$args): float|string |
|
93 | + public static function trim(mixed ...$args): float | string |
|
94 | 94 | { |
95 | 95 | $aArgs = Functions::flattenArray($args); |
96 | 96 |
@@ -20,7 +20,7 @@ discard block |
||
20 | 20 | * |
21 | 21 | * @return float|string (string if result is an error) |
22 | 22 | */ |
23 | - public static function averageDeviations(mixed ...$args): string|float |
|
23 | + public static function averageDeviations(mixed ...$args): string | float |
|
24 | 24 | { |
25 | 25 | $aArgs = Functions::flattenArrayIndexed($args); |
26 | 26 | |
@@ -69,7 +69,7 @@ discard block |
||
69 | 69 | * |
70 | 70 | * @return float|int|string (string if result is an error) |
71 | 71 | */ |
72 | - public static function average(mixed ...$args): string|int|float |
|
72 | + public static function average(mixed ...$args): string | int | float |
|
73 | 73 | { |
74 | 74 | $returnValue = $aCount = 0; |
75 | 75 | |
@@ -108,7 +108,7 @@ discard block |
||
108 | 108 | * |
109 | 109 | * @return float|int|string (string if result is an error) |
110 | 110 | */ |
111 | - public static function averageA(mixed ...$args): string|int|float |
|
111 | + public static function averageA(mixed ...$args): string | int | float |
|
112 | 112 | { |
113 | 113 | $returnValue = null; |
114 | 114 | |
@@ -147,7 +147,7 @@ discard block |
||
147 | 147 | * |
148 | 148 | * @return float|string The result, or a string containing an error |
149 | 149 | */ |
150 | - public static function median(mixed ...$args): float|string |
|
150 | + public static function median(mixed ...$args): float | string |
|
151 | 151 | { |
152 | 152 | $aArgs = Functions::flattenArray($args); |
153 | 153 | |
@@ -181,7 +181,7 @@ discard block |
||
181 | 181 | * |
182 | 182 | * @return float|string The result, or a string containing an error |
183 | 183 | */ |
184 | - public static function mode(mixed ...$args): float|string |
|
184 | + public static function mode(mixed ...$args): float | string |
|
185 | 185 | { |
186 | 186 | $returnValue = ExcelError::NA(); |
187 | 187 | |
@@ -211,7 +211,7 @@ discard block |
||
211 | 211 | * Special variant of array_count_values that isn't limited to strings and integers, |
212 | 212 | * but can work with floating point numbers as values. |
213 | 213 | */ |
214 | - private static function modeCalc(array $data): float|string |
|
214 | + private static function modeCalc(array $data): float | string |
|
215 | 215 | { |
216 | 216 | $frequencyArray = []; |
217 | 217 | $index = 0; |