https://bz.apache.org/bugzilla/show_bug.cgi?id=60302
[email protected] changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEEDINFO |NEW --- Comment #2 from [email protected] --- Makes sense being a behavior difference between Microsoft Excel and LibreOffice when updating the formulas. I tested setting "setForceFormulaRecalculation(true)" in my example source code, but it did not change the outcome (Still works in Microsoft Office, not in LibreOffice) However, I find it strange that it works with XSSF or HSSF but not with SXSSF (I forgot to mention this in the original post). So this shows that there's a way to save the .xlsx file so that LibreOffice correctly updates the formulas. I don't know how SXSSF works internally, but we are restricted to using it because of memory usage. I cannot evaluate the formulas before saving the file because our users may modify the original values and want the formulas to be updated, so it can't be a fixed value. That said, if this is an expected behavior of SXSSF, even though is different than XSSF, I will change the bug status to resolved. Thanks for the quick response! -- 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]
