Bug 49377 - [PATCH] Formatter classes using Java 6.0 features
Summary: [PATCH] Formatter classes using Java 6.0 features
Alias: None
Product: POI
Classification: Unclassified
Component: POI Overall (show other bugs)
Version: 3.7-dev
Hardware: PC Windows XP
: P2 normal (vote)
Target Milestone: ---
Assignee: POI Developers List
Depends on:
Reported: 2010-06-03 11:36 UTC by will
Modified: 2010-06-03 12:20 UTC (History)
0 users


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?"

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