https://bz.apache.org/bugzilla/show_bug.cgi?id=60302
--- Comment #3 from Javen O'Neal <[email protected]> --- (In reply to nicolaspohren from comment #2) > 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. The OOXML format can save both a formula and a cached result (that can be re-evaluated). Off the top of my head, it looks like this: <c address="G6" type="f"> <f>SUM(A1:D3)</f> <v>42</v> </c> Cell#setCellFormula("SUM(A1:D3)") will set f to "SUM(A1:D3)" and v to 0. POI can evaluate the formula result and set v to 42. That said, SXSSF formula evaluation is contingent on all formulas being accessible in the row window. -- 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]
