https://issues.apache.org/bugzilla/show_bug.cgi?id=55185
--- Comment #3 from [email protected] --- (In reply to srousseau from comment #2) > (In reply to Nick Burch from comment #1) > > After changing a formula, you must trigger a recalculation to ensure the > > cached value is correctly stored/set in the file > > > > See http://poi.apache.org/spreadsheet/eval.html for instructions on how to > > do this > > Great!! > It works with HSSFFormulaEvaluator.evaluateAllFormulaCells(myWorkBook). > > I upgrade from POI 3.0 to POI 3.9 and I didn't need to call this code. So I > didn't know about "Formula Evaluation". > > Thanks a lot ! > > Stephane Hello, I dont't know what I've changed since last Tuesday but I doesn't work anymore. I now see "toto" as result. I'm using HSSFFormulaEvaluator.evaluateAllFormulaCells(book.getWorkbook()); and book.getWorkbook().setForceFormulaRecalculation(true); but the cell value is not refreshed. But I can see the call to evaluateFormulaCell for each formula cell. In excel, I have to click in the cell to refresh the cell value as in the beginning. I run Excel 2010 with HSSFWorkbook. So, if anybody has idea ... Regards Stéphane Rousseau -- 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]
