https://issues.apache.org/bugzilla/show_bug.cgi?id=46156
Josh Micich <[EMAIL PROTECTED]> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEW |NEEDINFO
Summary|AddEval does not process |Formula evaluation exhibits
|properly |IEEE floating point rounding
| |anomalies
--- Comment #1 from Josh Micich <[EMAIL PROTECTED]> 2008-11-05 21:43:10 PST ---
POI's internal evaluation works entirely in terms of IEEE doubles which is
mostly consistent with Excel. My bet is that internally Excel experiences the
same floating point anomalies, but hides them relatively well by using nice
number-to-text conversion.
I don't think using BigDecimal is a solution. It just transforms the problem
into a question of setting the correct 'scale' (which I'm assuming would be
POI's responsibility).
There is an outstanding request to get POI to more closely emulate Excel
number-to-text conversion. Do you think this would help solve your problem?
--
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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
