[prev in list] [next in list] [prev in thread] [next in thread] 

List:       poi-user
Subject:    Re: Method getNumericCellValue()
From:       avik.sengupta () itellix ! com
Date:       2005-04-21 15:11:43
Message-ID: 20050421202943.av507dz140c4488w () www ! itellix ! net
[Download RAW message or body]

POI is only a file format reader/writer, not a functional equivalent 
for excel.
Thus, it only writes formulas in a format excel understands, and does not
calculate formula results.

HTH
-
Avik


Quoting Alessandro Santos <alessandro.research@gmail.com>:

> Hi folks!
>
> I'm facing a weird problem: when I use the POI method
> getNumericCellValue() to read a formula cell in a sheet created by
> Excel, it returns me the formula result correctly. But when I use the
> same method to read a formula cell in a sheet created by POI, it
> returns me always the number zero. Can anyone tell me why? How can I
> get the formula result from a cell in a sheet created by POI?
> --=20
> Alessandro
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
> Mailing List:     http://jakarta.apache.org/site/mail2.html#poi
> The Apache Jakarta Poi Project:  http://jakarta.apache.org/poi/
>
>



---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
Mailing List:     http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project:  http://jakarta.apache.org/poi/

[prev in list] [next in list] [prev in thread] [next in thread]