mirror of
https://github.com/PHPOffice/PhpSpreadsheet.git
synced 2026-08-21 20:14:05 +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>
49 lines
953 B
PHP
49 lines
953 B
PHP
<?php
|
|
|
|
return [
|
|
[
|
|
90.0,
|
|
['01-Apr-2017', '31-Mar-2021', 0.025, 100],
|
|
],
|
|
[
|
|
97.625,
|
|
['2008-02-15', '2008-11-30', 0.03, 100, null],
|
|
],
|
|
[
|
|
97.6311475409836,
|
|
['2008-02-15', '2008-11-30', 0.03, 100, 1],
|
|
],
|
|
[
|
|
'#VALUE!',
|
|
['Invalid Date', '2008-11-30', 0.03, 100, 1],
|
|
],
|
|
[
|
|
'#VALUE!',
|
|
['2008-02-15', 'Invalid Date', 0.03, 100, 1],
|
|
],
|
|
[
|
|
'#VALUE!',
|
|
['2008-02-15', '2008-11-30', 'NaN', 100, 1],
|
|
],
|
|
[
|
|
'#NUM!',
|
|
['2008-02-15', '2008-11-30', -0.03, 100, 1],
|
|
],
|
|
[
|
|
'#VALUE!',
|
|
['2008-02-15', '2008-11-30', 0.03, 'NaN', 1],
|
|
],
|
|
[
|
|
'#NUM!',
|
|
['2008-02-15', '2008-11-30', 0.03, -100, 1],
|
|
],
|
|
[
|
|
'#VALUE!',
|
|
['2008-02-15', '2008-11-30', 0.03, 100, 'NaN'],
|
|
],
|
|
[
|
|
'#NUM!',
|
|
['2008-02-15', '2008-11-30', 0.03, 100, -1],
|
|
],
|
|
];
|