https://bz.apache.org/bugzilla/show_bug.cgi?id=68258
--- Comment #2 from Spyros <spy...@neotalogic.com> --- (In reply to PJ Fanning from comment #1) > wb.setForceFormulaRecalculation(true) makes Excel evaluate the formulas when > it opens the workbook. > > To be clear, noone is working on improving POI formula evaluation. > > I would recommend forgetting that POI has FormulaEvaluator support. Just use > `wb.setForceFormulaRecalculation(true)` and `cell.setCellFormula(...)`. > Write the results to an xslx file and open it in Excel. Excel will evaluate > the formulas. > > You are welcome to submit patches to POI but it is unlikely that someone > will try to enhance POI for you. Thanks for the very prompt response on this! We're already using `wb.setForceFormulaRecalculation(true)` for one class of usecases in our platform, where we want to provide users with the spreadsheet after values have been mapped, so that they can download and continue working on it. However, there's another class of usecases where users can use our platform to provide values to a Spreadsheet, have an Excel engine evaluate it for them, and return back only values for the cells/columns/whatever they are interested at. We used to do this with an older version of Sharepoint and Excel Services, but that's not supported/available by Microsoft anymore, hence our turn to POI. In any case, your idea of opening the .xslx file with Excel so that formulas can be computed before proceeding could be of value - we can try to add that extra step in the evaluation process so that all cells in the resulting .xslx file can have their "final" (post formula evaluation) values. Do you happen to know whether OpenOffice has good enough support for formulas? Thanks again for your prompt response on this! -- 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
