Ahh.. . Did you order the Excel 97 dev kit? Anyhow I'll read it over again for this aspect tonight, I don't recall it covering this.
-Andy Avik Sengupta wrote: >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]> > > -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
