poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject DO NOT REPLY [Bug 51339] Formula evaluation and floating point rounding problem
Date Wed, 08 Jun 2011 11:55:57 GMT

--- Comment #3 from Nick Burch <nick.burch@alfresco.com> 2011-06-08 11:55:57 UTC ---
Could you please use this problem file to identify where the error comes in? A
difference of 0.01 on only a few operations seems rather large

You'll likely want to get excel to store some of the intermediate parts of your
formula so you can look at them, figure out what the values really are (not
what excel displays!), and then compare that with what poi calculates. Where
does this large error creep in?

POI will happily format a numeric cell as text with the same rules as excel,
see DataFormatter. This won't help if POI and Excel disagree on the underlying
numeric value though!

Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- 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

View raw message