The RuntimeException ('Complex name formulas not supported yet') that
you received indicates that POI is not able to evaluate 'BereikArray'.
POI currently only handles evaluation of very simple internal defined
names (i.e. cell references and area references). There is an open
feature request to add support for evaluating external defined names:
https://issues.apache.org/bugzilla/show_bug.cgi?id=48996
This hasn't been applied yet because I was considering working out a
more complete solution (evaluating names which have complex formulas)
in order to make the code less of a patchwork of special cases.
The second error you describe involves POI functionality that is
supposed to work (VLOOKUP, OFFSET and COUNTA are all supported). If
you can cut down your example to a simple case that shows POI
producing the wrong result, it would be very helpful. Please open a
new bugzilla entry once you have collected these details.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
