https://issues.apache.org/bugzilla/show_bug.cgi?id=51339
Bug #: 51339
Summary: Formula evaluation and floating point rounding problem
Product: POI
Version: 3.8-dev
Platform: PC
Status: NEW
Severity: major
Priority: P2
Component: XSSF
AssignedTo: [email protected]
ReportedBy: [email protected]
Classification: Unclassified
Created attachment 27130
--> https://issues.apache.org/bugzilla/attachment.cgi?id=27130
quick start
Hi.
We have a problem with different results from excel and POI calculation.
Problem is connected with floating points and rounding.
Im attaching a quick start which reproduce that problem. We are suming 12 rows,
multiply it by 50% and then rounding. In excel sheet we have 275,62 in POI
275,61.
(With sum we get some floating points like 0,499999995 etc.)
We have a lot of calculation and data precision is very important for us. So
there is huge ddiference with 0,62 and 0.61.
I saw that #46156 cover similar problem but i can reproduce it also for HSSF
implementation (which uses NumberToTextConverter).
Any clues how we can fast fix this without touching excel file ?
--
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]
