Excel stores an integer index for the inbuilt functions. POI knows the mappings between the ENGLISH function names and the indices. I think we have all the names upto office xp, but check in code to be sure. AbstractFunctionPtg.java
For names that are not recognised, POI will put in the integer for an user defined function. If that UDF is not defined in the excel template, Excel will show #NAME on opening the file. Regards - Avik PS. you had said urgent, sorry for the delay. On Fri, 2004-07-02 at 22:22, Karl-Heinz Zengerle wrote: > Hi world. > > Are any Excel formulas (with valid function names) known which can't be > evaluated in POI? The answer is urgent. > > If the general answer isn't known then a statement about the lookup > functions (like SVERWEIS in German) would be welcome. > > Regards, Karl-Heinz. > > > Am Mo 28.06.2004 15:21 schrieb Karl-Heinz Zengerle > <[EMAIL PROTECTED]>: > > > Hi world. > > > > How are invalid formula detected, e.g. a function NONSENSE() not > > existing in Excel? How will the application see that? > > > > As Excel documents can also be created in OpenOffice e.g. the Bessel > > functions aren't available in Excel. Such files could be processed in > > POI. So such situations could occur in practice. > > > > Regards, Karl-Heinz. > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
