poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject [Bug 48043] Excel complains about a POI generated function
Date Wed, 07 Oct 2015 09:55:35 GMT

--- Comment #5 from Javen ONeal <javenoneal@gmail.com> ---
Make sure you're using some evaluation that will cache the formula result in
the cell, such as FormulaEvaluator.evaluateInCell(Cell).
FormulaEvaluator.evaluate(Cell) returns the formula result but leaves the Cell
unmodified. Perhaps this is why you were still getting #VALUE! errors when you
opened the workbook in Excel.

Could you post the code you used to evaluate the formula after setting the
formula but before saving the workbook?

Alternatively, you might be able to try Workbook.    
setForceFormulaRecalculation(true) before saving the workbook, which tells
Excel to recalculate all the formulas next time it opens the workbook.

You are receiving this mail because:
You are the assignee for the bug.

To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org

View raw message