You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@poi.apache.org by "Tong-Huang (via GitHub)" <gi...@apache.org> on 2023/11/23 10:48:46 UTC

[PR] Fix Bug 68200 [poi]

Tong-Huang opened a new pull request, #552:
URL: https://github.com/apache/poi/pull/552

   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


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


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


Re: [PR] Fix Bug 68200 [poi]

Posted by "xzel23 (via GitHub)" <gi...@apache.org>.
xzel23 commented on PR #552:
URL: https://github.com/apache/poi/pull/552#issuecomment-1824256870

   Link to Apache POI Bug Tracker: https://bz.apache.org/bugzilla/show_bug.cgi?id=68200


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


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