mirror of
https://github.com/PHPOffice/PhpSpreadsheet.git
synced 2026-11-09 19:36:15 +00:00
Guy Tomer
17 lines
680 B
PHP
17 lines
680 B
PHP
<?php
|
|
|
|
declare(strict_types=1);
|
|
|
|
// Logical values and text representations of numbers typed directly into the argument list are counted;
|
|
// text that cannot be translated into a number is an error (unlike text in a reference or an array, which is ignored).
|
|
// https://support.microsoft.com/en-us/office/max-function-e0012414-9ac8-4b34-9a47-73e662c08098
|
|
|
|
return [
|
|
'numeric text counts' => [-1, -3, '-1'],
|
|
'numeric text counts over numbers' => [27, 10, 7, 9, '27', 2],
|
|
'TRUE counts as 1' => [1, -3, true],
|
|
'FALSE counts as 0' => [0, -3, false],
|
|
'non-numeric text is an error' => ['#VALUE!', -3, 'a'],
|
|
'empty text is an error' => ['#VALUE!', '', 600000],
|
|
];
|