mirror of
https://github.com/PHPOffice/PhpSpreadsheet.git
synced 2026-08-22 05:03:42 +00:00
Mark Baker
a34695e0f9
* Additional unit tests and rationalisation for Financial Functions * Providing a series of sample files for Financial functions * Refactor the last of the existing Financial functions * Some more unit tests with default assignments from null arguments Co-authored-by: Adrien Crivelli <adrien.crivelli@gmail.com>
45 lines
1017 B
PHP
45 lines
1017 B
PHP
<?php
|
|
|
|
return [
|
|
[
|
|
0.06095433369153867,
|
|
'15-Mar-2008', '3-Nov-2008', '8-Nov-2007', 0.0625, 100.0123, 0,
|
|
],
|
|
[
|
|
0.06095433369153867,
|
|
'15-Mar-2008', '3-Nov-2008', '8-Nov-2007', 0.0625, 100.0123, null,
|
|
],
|
|
[
|
|
0.04210977320221025,
|
|
'1-Jan-2017', '30-Jun-2018', '01-Jul-2014', 0.055, 101,
|
|
],
|
|
[
|
|
'#VALUE!',
|
|
'Invalid', '30-Jun-2018', '01-Jul-2014', 0.055, 101,
|
|
],
|
|
[
|
|
'#VALUE!',
|
|
'1-Jan-2017', 'Invalid', '01-Jul-2014', 0.055, 101,
|
|
],
|
|
[
|
|
'#VALUE!',
|
|
'1-Jan-2017', '30-Jun-2018', 'Invalid', 0.055, 101,
|
|
],
|
|
[
|
|
'#VALUE!',
|
|
'1-Jan-2017', '30-Jun-2018', '01-Jul-2014', 'NaN', 101,
|
|
],
|
|
[
|
|
'#VALUE!',
|
|
'1-Jan-2017', '30-Jun-2018', '01-Jul-2014', 0.055, 'NaN',
|
|
],
|
|
[
|
|
'#NUM!',
|
|
'1-Jan-2017', '30-Jun-2018', '01-Jul-2014', -0.055, 101,
|
|
],
|
|
[
|
|
'#NUM!',
|
|
'1-Jan-2017', '30-Jun-2018', '01-Jul-2014', 0.055, -101,
|
|
],
|
|
];
|