https://bz.apache.org/bugzilla/show_bug.cgi?id=57721
--- Comment #5 from GW <greg.wool...@gmail.com> --- This isn't a problem with formula function coverage, it is a core problem with XSSF formula SYNTAX evaluation. POI just doesn't understand Excel Table "Structured References" in formulas. These are XSSF format objects only, and have no equivalent in HSSF. https://support.office.com/en-us/article/Using-structured-references-with-Excel-tables-f5ed2452-2337-4f71-bed3-c8ae6d2b276e This means POI formula support is limited to pre-2007 syntax only, which is an increasing problem. The fix should not be too hard, but would be deep into XSSFEvaluationWorkbook. There is no function to register. It would need to extend getName(String, int) to also check all sheets for tables matching the given name (tables have globally scoped names but are tied to specific sheets), and return something similar to EvaluationName. Since table references are just convenience syntax, this could just map directly to a range specification and parse the formula using the range expression from that point on, I think. I plan to dig a bit, but any fix will involve some extensive refactoring, so I'm not sure anyone outside the core committers can write a patch acceptable to the repository owners. -- 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
