[Bug 57721] Evaluating formulas in named Excel table

https://bz.apache.org/bugzilla/show_bug.cgi?id=57721 Dominik Stadler changed: What|Removed |Added Blocks||63934 Referenced Bugs:

[Bug 57721] Evaluating formulas in named Excel table

https://bz.apache.org/bugzilla/show_bug.cgi?id=57721 Javen O'Neal changed: What|Removed |Added Status|NEW |RESOLVED

[Bug 57721] Evaluating formulas in named Excel table

https://bz.apache.org/bugzilla/show_bug.cgi?id=57721 Greg Woolsey changed: What|Removed |Added Status|NEEDINFO|NEW ---

[Bug 57721] Evaluating formulas in named Excel table

https://bz.apache.org/bugzilla/show_bug.cgi?id=57721 Javen O'Neal changed: What|Removed |Added Status|NEW |NEEDINFO ---

[Bug 57721] Evaluating formulas in named Excel table

https://bz.apache.org/bugzilla/show_bug.cgi?id=57721 Bug 57721 depends on bug 57840, which changed state. Bug 57840 Summary: [PATCH] Support for structured references with Excel tables. https://bz.apache.org/bugzilla/show_bug.cgi?id=57840 What|Removed |Added

[Bug 57721] Evaluating formulas in named Excel table

https://bz.apache.org/bugzilla/show_bug.cgi?id=57721 --- Comment #7 from Javen O'Neal --- With the added support of structured references from bug 57840, using the XSSFFormulaEvaluator to evaluate all formulas in a workbook containing structured references works. Applied unit

[Bug 57721] Evaluating formulas in named Excel table

https://bz.apache.org/bugzilla/show_bug.cgi?id=57721 Javen O'Neal changed: What|Removed |Added Depends on||57840 -- You are

[Bug 57721] Evaluating formulas in named Excel table

https://bz.apache.org/bugzilla/show_bug.cgi?id=57721 --- Comment #6 from GW --- I found this issue, with a potential patch, that has received no attention in over a year: https://bz.apache.org/bugzilla/show_bug.cgi?id=57840 >From the description, this looks like exactly

[Bug 57721] Evaluating formulas in named Excel table

https://bz.apache.org/bugzilla/show_bug.cgi?id=57721 --- Comment #5 from GW --- 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.

[Bug 57721] Evaluating formulas in named Excel table

https://bz.apache.org/bugzilla/show_bug.cgi?id=57721 --- Comment #4 from Javen O'Neal --- Patches are always welcome! Submitting patches: https://poi.apache.org/guidelines.html#SubmittingPatches Understanding formula evaluation: https://poi.apache.org/spreadsheet/eval.html

[Bug 57721] Evaluating formulas in named Excel table

https://bz.apache.org/bugzilla/show_bug.cgi?id=57721 GW changed: What|Removed |Added Version|3.12-dev|3.12-FINAL

[Bug 57721] Evaluating formulas in named Excel table

https://bz.apache.org/bugzilla/show_bug.cgi?id=57721 --- Comment #2 from Stephen Matta --- This is preventing me from shifting rows that use the formula. My workaround is to use the "Table Tools/Design" tab and "Convert to Range" the table in Excel. This is not ideal but

[Bug 57721] Evaluating formulas in named Excel table

https://bz.apache.org/bugzilla/show_bug.cgi?id=57721 Stephen Matta changed: What|Removed |Added CC|

[Bug 57721] Evaluating formulas in named Excel table

https://bz.apache.org/bugzilla/show_bug.cgi?id=57721 Dominik Stadler dominik.stad...@gmx.at changed: What|Removed |Added OS||All -- You

[Bug 57721] Evaluating formulas in named Excel table

https://bz.apache.org/bugzilla/show_bug.cgi?id=57721 --- Comment #1 from gruber.c...@gmx.at --- Created attachment 32582 -- https://bz.apache.org/bugzilla/attachment.cgi?id=32582action=edit java test pgm -- You are receiving this mail because: You are the assignee for the bug.