|Summary:||[PATCH] Formatter classes using Java 6.0 features|
|Component:||POI Overall||Assignee:||POI Developers List <dev>|
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