poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject DO NOT REPLY [Bug 53076] cell.getNumericCellValue() returns incorrect results sometimes
Date Fri, 13 Apr 2012 15:28:43 GMT
https://issues.apache.org/bugzilla/show_bug.cgi?id=53076

--- Comment #3 from rohit.vats@gmail.com 2012-04-13 15:28:43 UTC ---
(In reply to comment #1)
> getNumericCellValue() returns the number stored in the file, which is a
> floating point. If you want a string that looks the same as excel shows, use
> something like DataFormatter to format your number

Ok, the actual value in the field seems to be -23530.915, which is why I
wondered why getNumericCellValue() returned -23530.915000000045.

Any thoughts?

-- 
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org


Mime
View raw message