Hi Avik. Are you also able to evaluate all mapped formula (when a user calls the getStringValue() or getNumericValue() method of a cell) within POI?
E.g. there are functions like SVERWEIS() where internally quite a lot has to be done. Regards, Karl-Heinz. Am Di 06.07.2004 10:03 schrieb Avik Sengupta <[EMAIL PROTECTED]>: > 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] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
