https://bz.apache.org/bugzilla/show_bug.cgi?id=66501
PJ Fanning <fannin...@yahoo.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
OS| |All
Status|NEW |RESOLVED
Resolution|--- |WONTFIX
--- Comment #1 from PJ Fanning <fannin...@yahoo.com> ---
Excel uses doubles under the hood. POI is an attempt to approximate what Excel
does. If you want exact results instead of floating point approximations,
please do not use Excel or POI.
What Excel does is use formats to define how the approximate values should be
displayed. It's hard to imagine how they came up with this but this is what we
are stuck with. Use POI's DataFormatter to apply the cell formats.
Closing this issue as: Won't Fix
--
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
