Humm, I'll look this up tonight. Didn't notice anything that explained that exactly.
-Andy Avik Sengupta wrote: >operand tokens in Excel can be of three classes .. Reference, Value and Array. > >Each operation (and also each inbuild sheet function) has an expects one >particular type of operand class. So, for example, + operator expects value >class operand token, the ROW() function expects a reference class token, and >the SUM() function expects either value or reference class token. The actual >token class is a function of the default for that token, the expected token >class, and the position. > >Further, functions have a token class for their return values... eg SUM() and >ROW() returns value class tokens (ie, their token is FuncV by default). also, >as above, that can change based on the position of the function. > >So, while i know, for eg, that ROW() expects reference class parameter tokens, >and returns value class tokens, i do not have this info for all the sheet >functions. > >Regards >- >Avik > > >Quoting "Andrew C. Oliver" <[EMAIL PROTECTED]>: > >>> >>>- >>>Avik >>> >>>PS. While i wait for my Excel dev kit to negotiate its international >>> >>shipping >> >>>course, can anybody send me a list of expected param types of all excel >>> >>sheet >> >>>functions .. it does not seem to be documented in the openoffice doc. thanx. >>> >>elaborate on what you mean..? >> >> >>>Quoting [EMAIL PROTECTED]: >>> >>>>avik 02/05/06 11:23:24 >>>> >>>> Modified: src/java/org/apache/poi/hssf/record/formula Ptg.java >>>> ReferencePtg.java >>>> src/testcases/org/apache/poi/hssf/usermodel >>>> TestFormulas.java >>>> Log: >>>> committing patches supplied by Matthew McClain for bug 8757. This will >>>>handle most cases, since majority formulas expect value class params. Ptgs >>>> >>to >> >>>>be refactored for full functionality >>>> >>>> >>>-- >>>To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> >>>For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> >>> >>> >> >> >> >>-- >>To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> >>For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> >> >> > > > >-- >To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> >For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> > > -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
