poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Karl-Heinz Zengerle" <karl-heinz.zenge...@sawag.com>
Subject AW: AW: evaluating simple formula
Date Mon, 08 Mar 2004 17:57:57 GMT
Hi Avik.

For normal cells I've got the cell type. In case of formulas it's
CELL_TYPE_FORMULA (or something like that). So the result type is
hidden.

I can do the trial & error method. Loading with one method for a
certain. If an exception occurs trying the next type, e.g. 1 numeric 2
date 3 string.

Regards,	Karl-Heinz.


-----Ursprüngliche Nachricht-----
Von: avik.sengupta@itellix.com [mailto:avik.sengupta@itellix.com] 
Gesendet: Dienstag, 9. März 2004 00:57
An: POI Users List
Betreff: Re: AW: evaluating simple formula

Same way you do for a normal cell.. sorry its midnight, and I dont have
the api
open in front of me... 

Quoting Karl-Heinz Zengerle <karl-heinz.zengerle@sawag.com>:

> Thanks for the quick answer Avik.
> 
> How do I know to which type the formula will result?
> 
> Regards,	Karl-Heinz.
> 
> 
> -----Ursprüngliche Nachricht-----
> Von: avik.sengupta@itellix.com [mailto:avik.sengupta@itellix.com] 
> Gesendet: Dienstag, 9. März 2004 00:32
> An: POI Users List
> Betreff: Re: evaluating simple formula
> 
> Call getStringValue or getNumericValue on the cell.
> 
> Quoting Karl-Heinz Zengerle <karl-heinz.zengerle@sawag.com>:
> 
> > Hi world.
> >  
> > I see methods to retrieve the formula but I'ld need the results.
What
> do
> > I have to do?
> >  
> > Regards,
> > Karl-Heinz Zengerle
> >  
> > 
> 
> 
> 
> 
> 
> ---------------------------------------------------------------------
> 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