Josh Micich wrote:
>
> 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]
>
>
>
What's a bugzilla entry?
What do you need? an excell sheet and code example?
kind regard
--
View this message in context:
http://old.nabble.com/Apache-POI-excel-function-VLOOKUP-tp28779554p28789108.html
Sent from the POI - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
