mirror of
https://github.com/PHPOffice/PhpSpreadsheet.git
synced 2026-08-25 20: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.
27 lines
561 B
PHP
27 lines
561 B
PHP
<?php
|
|
|
|
use PhpOffice\PhpSpreadsheet\Calculation\Information\ExcelError;
|
|
|
|
return [
|
|
[1, 0],
|
|
[12, 22269.0],
|
|
[2, 30348.0],
|
|
[6, 30843.0],
|
|
[11, '11-Nov-1918'],
|
|
[2, '28-Feb-1904'],
|
|
[7, '01 Jul 2003'],
|
|
[4, '38094'],
|
|
[12, 'Dec 2003'],
|
|
[12, '1960-12-25'],
|
|
[11, '1918-11-01'],
|
|
[ExcelError::VALUE(), '1918-13-11'],
|
|
[ExcelError::NAN(), -10],
|
|
[ExcelError::VALUE(), 'ABCD'],
|
|
[1, false],
|
|
[1, true],
|
|
[3, 61],
|
|
[2, 60], // because of fake leap day
|
|
[12, 366], // because of fake leap day
|
|
[1, 367],
|
|
];
|