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 2020/02/11 21:30:15 UTC
[Bug 64137] New: IRR NaN When it should give back a value
https://bz.apache.org/bugzilla/show_bug.cgi?id=64137
Bug ID: 64137
Summary: IRR NaN When it should give back a value
Product: POI
Version: unspecified
Hardware: All
OS: All
Status: NEW
Severity: normal
Priority: P2
Component: SS Common
Assignee: dev@poi.apache.org
Reporter: fawaz.alhenaki@ibm.com
Target Milestone: ---
Created attachment 37012
--> https://bz.apache.org/bugzilla/attachment.cgi?id=37012&action=edit
Reproduction file
I have created a sample of when the issue occurs. IRR in apache documentation
says that covers "20 tries" as shown here
https://poi.apache.org/apidocs/dev/org/apache/poi/ss/formula/functions/Irr.htmlÂ
which is identical to Microsoft Excel
https://support.office.com/en-us/article/irr-function-64925eaa-9988-495b-b290-3ad0c163c1bc
This indicate that the result is the same between the two; however, in the case
of apache poi, it seems that the result is returned as NaN (while excel returns
the actual result).
--
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
[Bug 64137] IRR NaN When it should give back a value
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=64137
--- Comment #1 from PJ Fanning <fa...@yahoo.com> ---
I had to increase the iteration count and then POI calculates
-0.009463562705856032 for the attached test case
--
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
[Bug 64137] IRR NaN When it should give back a value
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=64137
PJ Fanning <fa...@yahoo.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Resolution|--- |FIXED
Status|NEW |RESOLVED
--
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
[Bug 64137] IRR NaN When it should give back a value
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=64137
--- Comment #2 from PJ Fanning <fa...@yahoo.com> ---
r1894110 - it seems like the way that Excel calculates its iteration count is
very different from how the POI code does because the attached use case
requires a much higher iteration count than 20 (POI iteration count)
--
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
[Bug 64137] IRR NaN When it should give back a value
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=64137
--- Comment #3 from PJ Fanning <fa...@yahoo.com> ---
https://bz.apache.org/bugzilla/show_bug.cgi?id=64085 is also open and has a
discussion about how Excel's IRR has some unusual implementation
--
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