mirror of
https://github.com/PHPOffice/PhpSpreadsheet.git
synced 2026-08-25 20:18:21 +00:00
oleibman
3a6009d49e
Very peculiar implementation in Excel. PhpSpreadsheet will match it: - FLOOR(8,0) is #DIV/0. This already matched, and is the only result I understand. - CEILING(8,0) is 0 (already matched) - FLOOR.MATH(8,0) is 0 (changed to match) - FLOOR.PRECISE(8,0) is 0 (changed to match) - CEILING.MATH(8,0) is 0 (already matched) - CEILING.PRECISE(8,0) is 0 (already matched)
29 lines
544 B
PHP
29 lines
544 B
PHP
<?php
|
|
|
|
declare(strict_types=1);
|
|
|
|
return [
|
|
[2, '2.5, 1'],
|
|
[-4, '-2.5, -2'],
|
|
[-4, '-2.5, 2'],
|
|
[2, '2.5, -2'],
|
|
[0.0, '0.0, 1'],
|
|
'corrected with PR 4446' => [0.0, '123.456, 0'],
|
|
[1.5, '1.5, 0.1'],
|
|
[0.23, '0.234, 0.01'],
|
|
[123, '123.456'],
|
|
['#VALUE!', '"ABC"'],
|
|
[15, '17, 3'],
|
|
[16, '19, 4'],
|
|
['exception', ''],
|
|
['#VALUE!', '25, "ABC"'],
|
|
[0, ',1'],
|
|
[0, 'false,1'],
|
|
[1, 'true,1'],
|
|
['#VALUE!', '"", 1'],
|
|
[1, 'A2, 1'],
|
|
[2, 'A3, 1'],
|
|
[-4, 'A4, 1'],
|
|
[-6, 'A5, 1'],
|
|
];
|