Poi does NOT evalauate formula's. getXXValue() calls return the saved formula result, as caculated by Excel. For new formulas entered via POI, getNumericValue always returns 0. On Tue, 2004-07-06 at 15:24, Karl-Heinz Zengerle wrote: > 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] >
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
