You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@poi.apache.org by bu...@apache.org on 2013/03/02 14:22:59 UTC

[Bug 54469] [PATCH] IPMT, PPMT financial functions implemented and integrated in latest POI

https://issues.apache.org/bugzilla/show_bug.cgi?id=54469

Yegor Kozlov <ye...@dinom.ru> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|REOPENED                    |NEW

--- Comment #17 from Yegor Kozlov <ye...@dinom.ru> ---
Partially applied in r1451886 with some tweaks.

Your implementation of PPMT is buggy. If I run PPMT_test I'm getting this:

ppmt=-121.95920277082378 [should be equal to -350.99]

The value -350.99 is correct, I confirmed it in Excel. 

Interestingly that two test cases from
http://office.microsoft.com/en-001/excel-help/ppmt-function-HP010342774.aspx
pass. 

Please fix PPMT , I guess it a math error and should be easy to detect and fix.

Regards,
Yegor

-- 
You are receiving this mail because:
You are the assignee for the bug.

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org