mirror of
https://github.com/PHPOffice/PhpSpreadsheet.git
synced 2026-08-22 14:34:48 +00:00
Mark Baker
d5dc58d20e
* Split Information functions into a dedicated class and namespace and categorise as Value or Error * Refactor all error functions into the new ExcelError class
55 lines
1.0 KiB
PHP
55 lines
1.0 KiB
PHP
<?php
|
|
|
|
use PhpOffice\PhpSpreadsheet\Calculation\Information\ExcelError;
|
|
|
|
return [
|
|
[
|
|
98.45,
|
|
'31-Mar-2008', '1-Jun-2008', 0.09,
|
|
],
|
|
[
|
|
ExcelError::VALUE(),
|
|
'Not a Valid Date', '1-Jun-2008', 0.09,
|
|
],
|
|
[
|
|
ExcelError::VALUE(),
|
|
'31-Mar-2008', 'Not a Valid Date', 0.09,
|
|
],
|
|
[
|
|
ExcelError::VALUE(),
|
|
'31-Mar-2008', '1-Jun-2008', 'NaN',
|
|
],
|
|
[
|
|
ExcelError::NAN(),
|
|
'31-Mar-2008', '1-Jun-2008', -0.09,
|
|
],
|
|
[
|
|
ExcelError::NAN(),
|
|
'31-Mar-2000', '1-Jun-2021', 0.09,
|
|
],
|
|
[
|
|
ExcelError::NAN(),
|
|
'1-Jun-2008', '31-Mar-2008', 0.09,
|
|
],
|
|
[
|
|
0.0,
|
|
'31-Mar-2008', '1-Apr-2008', 360,
|
|
],
|
|
[
|
|
ExcelError::NAN(),
|
|
'31-Mar-2008', '1-Apr-2008', 361,
|
|
],
|
|
[
|
|
97.75,
|
|
'1-Apr-2017', '30-Jun-2017', 0.09,
|
|
],
|
|
[
|
|
97.543194444,
|
|
'5-Feb-2019', '1-Feb-2020', 0.0245,
|
|
],
|
|
[
|
|
98.86180556,
|
|
'1-Feb-2017', '30-Jun-2017', 0.0275,
|
|
],
|
|
];
|