https://bz.apache.org/bugzilla/show_bug.cgi?id=60302
Javen O'Neal <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- OS| |All Status|NEW |NEEDINFO --- Comment #1 from Javen O'Neal <[email protected]> --- Formulas are not automatically evaluated in POI. You can either force Excel/LibreOffice to recalculate formulas when the workbook is opened [1] or use POI to update the formula result before saving the file. [2,3] That said, I believe the described behavior is expected and not a bug in POI, but rather an implementation difference in formula evaluation on workbook open in Excel versus LibreOffice. [1] https://poi.apache.org/apidocs/org/apache/poi/ss/usermodel/Workbook.html#setForceFormulaRecalculation(boolean) [2] https://poi.apache.org/spreadsheet/formula.html [3] https://poi.apache.org/spreadsheet/eval.html -- 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]
