Luke jaryszek wrote:Hi thank you!
so answer is: you can using only table object but you can not access to named range using reference to strcuture table...
You are welcome. Actually, I don't know; ii looks like a table is different from a named range. To access a range of named cells the example you had referred at the Apache POI web site is the correct one. You can try the example (named range) by creating a named range in an Excel sheet: name a range of cells using the "Name Manager" and then try to access them in Java. Here is the link again:
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.
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.
When in Excel you have Reference within named range like:
=Table1[Column1] isntead of "=Sheet1!$A$1:$B$1" you can't read this with APACHE POI.
Only addresses. You have workaround for this using evaluation function.
You showed up just in time for the waffles! And this tiny ad:
Building a Better World in your Backyard by Paul Wheaton and Shawn Klassen-Koop