https://bz.apache.org/bugzilla/show_bug.cgi?id=66389
PJ Fanning <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- OS| |All --- Comment #1 from PJ Fanning <[email protected]> --- I'm not convinced. I only have access to the web version of Excel and this evaluates that formula as 2.859426516. Using Java to try to reverse engineer Excel's internal maths is a major pain in the neck. We'll never make everyone happy and what we are arguing about here is a minor rounding issue. You can just get Excel to recalculate all the formulas when it loads any xls/xlsx files you create with POI and not worry about POI's calculations. Workbook#setForceFormulaRecalculation(boolean) -- 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]
