Bug 56993 - XSSFCell.getNumericCellValue() returns wrong number
Summary: XSSFCell.getNumericCellValue() returns wrong number
Status: RESOLVED INVALID
Alias: None
Product: POI
Classification: Unclassified
Component: XSSF (show other bugs)
Version: 3.10-FINAL
Hardware: PC All
: P2 normal (vote)
Target Milestone: ---
Assignee: POI Developers List
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2014-09-18 15:44 UTC by liangyifang
Modified: 2014-09-18 17:10 UTC (History)
0 users



Attachments

Note You need to log in before you can comment on or make changes to this bug.
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.