Bug 56993

Summary: XSSFCell.getNumericCellValue() returns wrong number
Product: POI Reporter: liangyifang
Component: XSSFAssignee: POI Developers List <dev>
Status: RESOLVED INVALID    
Severity: normal    
Priority: P2    
Version: 3.10-FINAL   
Target Milestone: ---   
Hardware: PC   
OS: All   

Description liangyifang 2014-09-18 15:44:34 UTC
if i have a number 350102196912300000 in a xlsx's numeric cell. when i use the method "XSSFCell.getNumericCellValue()", it returns 350102196912300030, but not 350102196912300000 !!!  I use the poi-bin-3.10.1-20140818.zip. jdk1.7.0_15
Comment 1 David North 2014-09-18 15:47:35 UTC
http://mail-archives.apache.org/mod_mbox/poi-user/201406.mbox/%3C538C6634.6070405@corefiling.co.uk%3E may be relevant, especially the linked Microsoft documentation.
Comment 2 liangyifang 2014-09-18 17:10:28 UTC
yes, u r right. i found the xml content is "<v>3.5010219691230003E+17</v>".

Thanks.