Bug 49377

Summary: [PATCH] Formatter classes using Java 6.0 features
Product: POI Reporter: will
Component: POI OverallAssignee: POI Developers List <dev>
Status: RESOLVED FIXED    
Severity: normal    
Priority: P2    
Version: 3.7-dev   
Target Milestone: ---   
Hardware: PC   
OS: Windows XP   

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.