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 46156] Formula evaluation exhibits IEEE floating point rounding anomalies
Date Mon, 01 Dec 2008 23:42:47 GMT

Josh Micich <josh@gildedtree.com> changed:

           What    |Removed                     |Added
             Status|ASSIGNED                    |RESOLVED
         Resolution|                            |FIXED

--- Comment #6 from Josh Micich <josh@gildedtree.com>  2008-12-01 15:42:46 PST ---
Fixed in svn r722284 ( https://svn.apache.org/viewcvs.cgi?view=rev&rev=722284 )

A new class NumberToTextConverter was added.  It is now used for all number to
text conversion used during formula rendering and formula evaluation.  You can
also use it on plain double values in the following way:

String text = NumberToTextConverter.toText(0.05+0.01);
assertEquals("0.06", text);


You mentioned the idea of storing both the formula text and result value
together in a single object.  I imagine it would be quite difficult to provide
a complete solution along these lines.  Formulas can reference other formulas,
and the formula text of the top cell may not have the necessary information. 
Furthermore, it is not clear how knowing the formula text would be useful in

If you still think such a class (holding formula & result) would be useful in
POI, please submit a working patch to explain more clearly.

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