Bug 12165 - Need a way to get a formatted string for a numeric field when reading a file.
Summary: Need a way to get a formatted string for a numeric field when reading a file.
Status: RESOLVED WONTFIX
Alias: None
Product: POI
Classification: Unclassified
Component: HSSF (show other bugs)
Version: unspecified
Hardware: Other other
: P1 blocker (vote)
Target Milestone: ---
Assignee: POI Developers List
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2002-08-29 15:31 UTC by Elvira Gurevich
Modified: 2004-11-16 19:05 UTC (History)
0 users



Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Elvira Gurevich 2002-08-29 15:31:29 UTC
I am using jakarta-poi-1.7.0-dev-bin.zip, 
and HSSFCell method getStringCellValue throws a NumberFormatException if a cell 
is numeric. However, there are custom formats one may specify on a numeric 
field. For example, a phone number would be displayed in a certain way, and not 
as a double 1.11111111E8. I have to generate a report from an xls file, and 
need a way to format numeric fields. Please advise on a way to do this.
Thanks,
Comment 1 Andy Oliver 2002-09-02 00:32:18 UTC
ask this question on the list.  I don't think this is a bug and this description
is insufficient for a bug report.