Hi Animesh. In your case just getNumericValue() returns some non empty value. To obtain your desired result you need to format this which is normal Java.
It's a similar problem (internal and external representation) like that with the date a few days ago. Regards, Karl-Heinz. -----Ursprüngliche Nachricht----- Von: animesh sonkar [mailto:[EMAIL PROTECTED] Gesendet: Dienstag, 19. Juli 2005 12:47 An: [email protected] Betreff: Reading Formula cell as String hi all, I am using POI v 2.5.1 . I want to read a Formula Cell which has a Numerical Value (say 05005). The problem is that i want to read this cell as a String such that i get the Value "05005" and not as 5005 or 5005.0 (reading the cell as Numerical value). I tries using HSSFCell.getStringValue() but it gives me a blank string as said in the documentation. Please help me resolve this problem. Is there any such feature in POI v 3.0 ? --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] Mailing List: http://jakarta.apache.org/site/mail2.html#poi The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
