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]>
