Bug 47598 - Formula evaluator should evaluate "(0.06-0.01)=0.05" to "TRUE"
Summary: Formula evaluator should evaluate "(0.06-0.01)=0.05" to "TRUE"
Status: RESOLVED FIXED
Alias: None
Product: POI
Classification: Unclassified
Component: HSSF (show other bugs)
Version: 3.5-dev
Hardware: PC Windows XP
: P2 normal (vote)
Target Milestone: ---
Assignee: POI Developers List
URL: http://www.nabble.com/Rounding-proble...
Keywords:
Depends on:
Blocks:
 
Reported: 2009-07-28 20:17 UTC by Josh Micich
Modified: 2009-07-28 20:49 UTC (History)
0 users


Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Josh Micich 2009-07-28 20:17:04 UTC 
Excel seems to have some tricks to suppress IEEE floating point rounding anomalies.

In POI, the formula "(0.06-0.01)=0.05" currently evaluates to "FALSE"
Comment 1 Josh Micich 2009-07-28 20:49:12 UTC 
Fixed in svn r798771

junts added

Some improvements were also made to NumberToTextConverter (The last of the recently added test examples have now been enabled).