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 30565] - getNumericCellValue is returning more digits from a formula cell than expected
Date Wed, 30 Nov 2005 14:01:07 GMT
DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG·
RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT
<http://issues.apache.org/bugzilla/show_bug.cgi?id=30565>.
ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND·
INSERTED IN THE BUG DATABASE.

http://issues.apache.org/bugzilla/show_bug.cgi?id=30565


gopal_sharma@freddiemac.com changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |acoliver@apache.org




------- Additional Comments From gopal_sharma@freddiemac.com  2005-11-30 15:01 -------
I think i didnt make it very clear. 

In the excel file attached before (at c:\test.xls), i made the format of all 
the cell to 10 places of decimal. Now, all the values are "displayed" to 10 
places after decimal in the excel file, as suggested : 1820311666.4400000000 
and 0.10000000000 

However, now when i run the attached code, the values returned are: 
A1 value : 1820311666.440002
A2 value : 1820311666.44
A3 value : 1820311666.440002
A4 value : 1820311666.44
A5 value : 0.1
C1 value : 1820311666.44
C2 value : 1820311666.44
C3 value : 1820311666.44
C4 value : 1820311666.44
C5 value : 0.1

The issue is with the cells being displayed as 1820311666.4400000000 in the 
excel sheet, but being retrieved as 1820311666.440002! 

Is this a bug in HSSF POI? Why does the value returned from POI not show as 
1820311666.4400000000 ?

Thanks, 
Gopal

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

---------------------------------------------------------------------
To unsubscribe, e-mail: poi-dev-unsubscribe@jakarta.apache.org
Mailing List:    http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta POI Project: http://jakarta.apache.org/poi/


Mime
View raw message