So NIck, you are saying if text cell has a numeric value POI will give
me cell type as numeric?
On Thu, Sep 13, 2012 at 4:27 PM, Nick Burch wrote:
On Thu, 13 Sep 2012, FELIX BERIG wrote:
Thanks for the reply. My problem is that cell is defined as text. For
some reason POI considers it as a numeric and adds '.0' to the text
of the cell.
Defined in Excel as text <-> stored in the file as text
POI is giving you back exactly what Excel has stored in the file
You probably want to use DataFormatter, that provides methods to
format numbers based on the excel formatting rules you've applied
Nick
---------------------------------------------------------------------
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]
