Bug 49377 - [PATCH] Formatter classes using Java 6.0 features
[PATCH] Formatter classes using Java 6.0 features
Status: RESOLVED FIXED
Product: POI
Classification: Unclassified
Component: POI Overall
3.7-dev
PC Windows XP
: P2 normal (vote)
: ---
Assigned To: POI Developers List
:
Depends on:
Blocks:
  Show dependency tree
 
Reported: 2010-06-03 11:36 UTC by will
Modified: 2010-06-03 12:20 UTC (History)
0 users



Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description will 2010-06-03 11:36:44 UTC
This patch naively removes the offending use of .setRoundingMode() and relies on the the default rounding algorithm.
Comment 1 Nick Burch 2010-06-03 11:41:04 UTC
The default rounding mode is alas different to the one used by Excel

I guess the best thing is probably to call this via reflection? That way those on Java 6 can get the same result as excel, and those on java 5 can get something close...
Comment 2 David Fisher 2010-06-03 11:52:25 UTC
Hi Nick,

This looks like an excellent example for a FAQ. - "Why do my POI results differ from Excel?"

Regards,
Dave
Comment 3 Nick Burch 2010-06-03 12:20:54 UTC
Fixed in r951052.