Bug 51927 - Cannot read long number EAN 8185002411111 as 8.5810822E7
Summary: Cannot read long number EAN 8185002411111 as 8.5810822E7
Status: RESOLVED WORKSFORME
Alias: None
Product: POI
Classification: Unclassified
Component: HSSF (show other bugs)
Version: 3.7-FINAL
Hardware: PC All
: P2 normal (vote)
Target Milestone: ---
Assignee: POI Developers List
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2011-09-30 11:48 UTC by Petr Novak
Modified: 2013-08-05 12:25 UTC (History)
0 users



Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Petr Novak 2011-09-30 11:48:50 UTC
I have cell 8185002411111  as number or as text in excel


I have to resolve it:

hssfCell.setCellType(Cell.CELL_TYPE_STRING);
cellValue = hssfCell.getStringCellValue();
Comment 1 Nick Burch 2011-09-30 11:53:53 UTC
What is the cell type? And what value do you get back before you make changes?
Comment 2 Dominik Stadler 2013-08-05 12:25:11 UTC
no response in a long time => resolving for now, please reopen with more information if this is still an issue