there is a use case, and i have used it, so i will raise a counter comment for POI to retain running calculations:
i had a project where i built a harness to load an excel spreadsheet and then exercise it as a system of record. if POI were to lose the ability to perform that function, it would be a loss for that use case. i do accept that it is an exotic case, but i'd wager it is not the only one. as a side note, some thought could be given to (if it were deemed necessary to go down this route) providing a contract layer so that existing functionality could be retained as an extension library. the current implementation allows for runtime patching of the execution engine (i had to use this for a missing function before PJF accepted a PR from me sometime ago), so there is a minimal contract in place already. Stanton Fisque principal technologist latticeware.com portland, oregon > On Oct 13, 2023, at 05:27 AM, bugzi...@apache.org wrote: > > https://bz.apache.org/bugzilla/show_bug.cgi?id=60848 > > --- Comment #15 from PJ Fanning <fannin...@yahoo.com> --- > I think it was a big mistake for POI to start evaluating formulas. It is too > complicated and there are not enough devs interested. It doesn't just take > someone to submit a change. It takes multiple people to review it. > > > Releases are irregular. > > Does anyone need POI to calculate formulas? The answer is no. Excel can be > made > to recalculate the formulas when you load the xlsx into Excel. > > See > https://poi.apache.org/apidocs/dev/org/apache/poi/xssf/usermodel/XSSFWorkbook.html#setForceFormulaRecalculation-boolean- > > -- > 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 > --------------------------------------------------------------------- To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org For additional commands, e-mail: dev-h...@poi.apache.org