https://bz.apache.org/bugzilla/show_bug.cgi?id=69878
--- Comment #2 from [email protected] --- (In reply to PJ Fanning from comment #1) > There is noone actively maintaining the POI formula evaluations. If you > would like to submit a PR, feel free to do so. > > In practice, not everyone needs formula evaluation. xls(x) files have the > evaluated values cached in them - so POI read those anyway. When writing, > you can call setForceFormulaRecalculation(true) on the POI workbook and this > sets a flag in the xls(x) file that tells Excel to eval the formulas when it > opens the file. > > POI will likely never have full formula eval support. Thank you for your reply! That makes sense, it is a fairly niche use-case where I use POI as a calculation engine without the intention of ever opening the file in Excel. In case anyone else has this issue and finds this before this is fixed: The workaround I found was to, in the workbook, use SUBSTITUTE to replace "\" with "\\" and "+" with "\+" IF the matching criteria contains "*" or "?". -- 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]
