If you don't trust POI's formula evaluator, you can ask Excel to recalculate all formulas when it opens the workbook. https://poi.apache.org/apidocs/org/apache/poi/xssf/usermodel/XSSFWorkbook.html#setForceFormulaRecalculation(boolean) This won't clear the cached results from the file, and it's up to your spreadsheet program to honor the formula recalculation request
Otherwise you could for-loop over all formula cells and delete the cached result. But based on what Greg said, the IFERROR function is already implemented in POI under the Analysis ToolPak and it's only a few lines of code to make these functions available to the FormulaEvaluator. On Fri, Aug 4, 2017 at 12:36 AM, Hehabr <[email protected]> wrote: > Idea: delete the cached results from the file. > Is it possible? > > > > -- > View this message in context: http://apache-poi.1045710.n5. > nabble.com/Apache-POI-How-to-update-excel-file-with-many- > formulas-tp5728410p5728427.html > Sent from the POI - User mailing list archive at Nabble.com. > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [email protected] > For additional commands, e-mail: [email protected] > >
