poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Karl-Heinz Zengerle <karlhe...@sawag.com>
Subject Re: invalid formula
Date Tue, 06 Jul 2004 10:25:59 GMT
Thanks Avik.

I.e. I never see actualized formula result value in POI without having
opened the file with Excel first.

Regards, Karl-Heinz.


Am Di 06.07.2004 12:22 schrieb Avik Sengupta
<avik.sengupta@itellix.com>:

> 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
> > <avik.sengupta@itellix.com>:
> > 
> > > 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
> > > > <karlheinz@sawag.com>:
> > > > 
> > > > > 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: poi-user-unsubscribe@jakarta.apache.org
> > > > For additional commands, e-mail:
> > > > poi-user-help@jakarta.apache.org
> > > > 
> > > 
> > > 
> > >
> > > ---------------------------------------------------------------------
> > > To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
> > > For additional commands, e-mail: poi-user-help@jakarta.apache.org
> > > 
> > > 
> > 
> > 
> > 
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
> > For additional commands, e-mail: poi-user-help@jakarta.apache.org
> > 
> 
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: poi-user-help@jakarta.apache.org
> 
> 



---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-user-help@jakarta.apache.org


Mime
View raw message