You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@poi.apache.org by Vijayakumar Gowdaman <vi...@db.com> on 2009/11/24 19:13:31 UTC
evaluating array formula
Is there way to evaluate the array formual in POI. In my excel spreadsheet
I have got a VLOOKUP which is
doing a lookup in another sheet. This lookup contains some array formula.
For example the formula is something
like this {=IF(TRUE,"yes","no")}. I am getting a error when I try to
evaluate this formula. Is this is a limitation in POI.
Regards,
Vijayakumar Gowdaman
---
This e-mail may contain confidential and/or privileged information. If you are not the intended recipient (or have received this e-mail in error) please notify the sender immediately and delete this e-mail. Any unauthorized copying, disclosure or distribution of the material in this e-mail is strictly forbidden.
Please refer to http://www.db.com/en/content/eu_disclosures.htm for additional EU corporate and regulatory disclosures.
Re: evaluating array formula
Posted by Josh Micich <jo...@gmail.com>.
It looks like Petr Udalau has done a bit of work that should get committed soon.
This is the first related bugzilla entry that Petr has submitted.
https://issues.apache.org/bugzilla/show_bug.cgi?id=48292
If you are able to help in any way (by offering new code, design work,
junit test code or even QA) that would be appreciated.
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org
Re: evaluating array formula
Posted by Vijayakumar Gowdaman <vi...@db.com>.
I have checked the POI website
http://poi.apache.org/spreadsheet/formula.html. One of the limitiation
specified there is formulas that look like "{....}" is not yet supported.
Is it the case still. If yes then please
somebody update me is there any work going on to implement this in the
future releases.
Regards,
Vijayakumar Gowdaman
Group Technology & Operations (GTO)
Global Markets
Deutsche Bank
off: 02075456250
Mob:07789773998
Vijayakumar Gowdaman <vi...@db.com>
24/11/2009 18:13
Please respond to
"POI Users List" <us...@poi.apache.org>
To
user@poi.apache.org
cc
Subject
evaluating array formula
Is there way to evaluate the array formual in POI. In my excel spreadsheet
I have got a VLOOKUP which is
doing a lookup in another sheet. This lookup contains some array formula.
For example the formula is something
like this {=IF(TRUE,"yes","no")}. I am getting a error when I try to
evaluate this formula. Is this is a limitation in POI.
Regards,
Vijayakumar Gowdaman
---
This e-mail may contain confidential and/or privileged information. If you
are not the intended recipient (or have received this e-mail in error)
please notify the sender immediately and delete this e-mail. Any
unauthorized copying, disclosure or distribution of the material in this
e-mail is strictly forbidden.
Please refer to http://www.db.com/en/content/eu_disclosures.htm for
additional EU corporate and regulatory disclosures.
---
This e-mail may contain confidential and/or privileged information. If you are not the intended recipient (or have received this e-mail in error) please notify the sender immediately and delete this e-mail. Any unauthorized copying, disclosure or distribution of the material in this e-mail is strictly forbidden.
Please refer to http://www.db.com/en/content/eu_disclosures.htm for additional EU corporate and regulatory disclosures.