https://issues.apache.org/bugzilla/show_bug.cgi?id=48256
Yegor Kozlov <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |RESOLVED Resolution| |INVALID --- Comment #2 from Yegor Kozlov <[email protected]> 2011-06-25 12:35:57 UTC --- Excel Viewer displays cached formula results, i.e. the results previously calculated by Excel or OpenOffice. POI doesn't pre-calculate formulas for you, you need to manually pass your workbook to the formula evaluator. Add the following line in the end of your code and you will be good: workbook.getCreationHelper().createFormulaEvaluator().evaluateAll(); it should work for both .xls and .xlsx formats. More about evaluation of formulas: http://poi.apache.org/spreadsheet/eval.html Yegor -- Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email ------- 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]
