Bug 51927

Summary: Cannot read long number EAN 8185002411111 as 8.5810822E7
Product: POI Reporter: Petr Novak <xfigoo>
Component: HSSFAssignee: POI Developers List <dev>
Status: RESOLVED WORKSFORME    
Severity: normal    
Priority: P2    
Version: 3.7-FINAL   
Target Milestone: ---   
Hardware: PC   
OS: All   

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