poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Javen O'Neal" <javenon...@gmail.com>
Subject Re: Apache POI: How to update excel file with many formulas?
Date Fri, 04 Aug 2017 08:40:07 GMT
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 <hehabr@web.de> 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: user-unsubscribe@poi.apache.org
> For additional commands, e-mail: user-help@poi.apache.org
>
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message