Do not know if you have already done this but if you visit this link;

http://poi.apache.org/apidocs/org/apache/poi/hssf/record/formula/functions/package-summary.html

Then you can see all of the functions that POI currently supports. By
supports, I mean that it is possible to call on the services of a forumla
evaluator to actually evaluate any one fot hese functions in their cells so
to speak; any functions that are not listed are still waiting to be
implemented.

It may be possible to write code for some of these un-implemented' functions
and, if this effort proves successful, maybe that code could form the basis
for a new member of the functions package; this is very much how I am
approaching the WEEKDAY() function we discussed in your other post. If you
have the time, I am sure that any contributions you may be able to make
would be very much appreciated.

Yours

Mark B


VK123 wrote:
>
> I am sure array functions like 'transpose' is one of the common functions
> used in spreadsheet.
> How to evaluate a spresheet formula cell  which contains 'transpose'
> function or any other functions whose ouput is
> an array.
>
> Regards,
>
> Vijayakumar Gowdaman
>
> Group Technology & Operations (GTO)
> Global Markets
> Deutsche Bank
> off: 02075456250
> Mob:07789773998
>
>
> ---
>
> 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.
>

--
View this message in context: http://www.nabble.com/evaluating-a-array-formula-tp25295370p25295791.html
Sent from the POI - User mailing list archive at Nabble.com.


---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi....
For additional commands, e-mail: user-help@poi....