https://bz.apache.org/bugzilla/show_bug.cgi?id=68974
--- Comment #3 from PJ Fanning <fannin...@yahoo.com> --- If you want Excel to calculate the formulas when you open the workbook, you need to call. workbook.setForceFormulaRecalculation(true); POI has some basic support for calculating formula results but a lot of Excel functions are not supported or only partially supported. I would strongly recommend just using setForceFormulaRecalculation(true). https://poi.apache.org/components/spreadsheet/eval.html -- You are receiving this mail because: You are the assignee for the bug. --------------------------------------------------------------------- To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org For additional commands, e-mail: dev-h...@poi.apache.org