My knowledge is only from reading ... and rereading .. and rereading :) the openoffice doc .. and from doing some experimentation with the bug.
Quoting "Andrew C. Oliver" <[EMAIL PROTECTED]>: > 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]> > > -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
