https://bz.apache.org/bugzilla/show_bug.cgi?id=68200
Bug ID: 68200
Summary: Rate function error
Product: POI
Version: 5.2.3-FINAL
Hardware: PC
OS: All
Status: NEW
Severity: critical
Priority: P2
Component: SS Common
Assignee: dev@poi.apache.org
Reporter: 450570...@qq.com
Target Milestone: ---
Hi Team,
Here some cases, `calculateRate` will return `Double.NaN` -> [#NUM!],
(https://github.com/apache/poi/blob/trunk/poi/src/main/java/org/apache/poi/ss/formula/functions/Rate.java#L99)
But it can get the right result in Numbers
case1:
RATE(22,30000,20000,-82257625,0,0.1)
Result: Double.NaN
whereas in Numbers I get: 0.35397960290713076
--
case2:
RATE(22,10000,10000,-313562750,0,0.1)
Result: Double.NaN
whereas in Numbers I get: 0.35397960290713076
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org
