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 <[email protected]> 24/11/2009 18:13 Please respond to "POI Users List" <[email protected]> To [email protected] 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.
