mirror of
https://github.com/PHPOffice/PhpSpreadsheet.git
synced 2026-08-25 16:28:18 +00:00
MarkBaker
a91dd60a98
Also enforce more rigorous Excel Function implementation by testing the underlying implementation, call via the Calc Engine, and execution from in a worksheet. Separate out unhappy path (exception) checks into a separate test, so that a single test isn't made overcomplex checking for every potentiality. Scrutinizer may dislike variadics, for variable number of arguments of mixed type; but tough. It's 100% valid PHP, accepted by phpstan, and makes life a lot easier. Initial work here covers all the database and datetime unit tests for Excel function implementations.
22 lines
458 B
PHP
22 lines
458 B
PHP
<?php
|
|
|
|
use PhpOffice\PhpSpreadsheet\Calculation\Information\ExcelError;
|
|
|
|
return [
|
|
[57, 0.2339930556],
|
|
[13, 0.4202893519],
|
|
[22, 0.60789351845],
|
|
[11, 0.8022106481],
|
|
[35, '11-Nov-1918 11:15:35'],
|
|
[0, '11:59 PM'],
|
|
[59, '23:59:59'],
|
|
[0, 3600],
|
|
[ExcelError::VALUE(), '23:59:99'],
|
|
[ExcelError::NAN(), -3601],
|
|
[0, 12500],
|
|
[0, 65535],
|
|
[ExcelError::VALUE(), "Half past 1 O'Clock"],
|
|
[0, false],
|
|
[0, true],
|
|
];
|