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: [email protected] For additional commands, e-mail: [email protected]
