https://bz.apache.org/bugzilla/show_bug.cgi?id=60302
Dominik Stadler <dominik.stad...@gmx.at> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEW |RESOLVED
Resolution|--- |WORKSFORME
--- Comment #5 from Dominik Stadler <dominik.stad...@gmx.at> ---
The problem is that the cached values for the formula is not populated by
default in POI to save the CPU cycles if not needed. You can force single cells
or all formulas to be evaluated with the FormulaEvaluator which is available
via "wb.getCreationHelper().createFormulaEvaluator()", so in your case the
following makes the result of the formula also show up in LibreOffice
correctly:
wb.getCreationHelper().createFormulaEvaluator().evaluateAll();
Therefore I am closing this WORKSFORME now as this is currently by design and
only Excel seems to somehow detect that the formulas need recalculation whereas
LibreOffice seems to rely on them being populated always.
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org
