You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@poi.apache.org by bu...@apache.org on 2004/08/10 18:27:17 UTC

DO NOT REPLY [Bug 30565] New: - getNumericCellValue is returning more digits from a formula cell than expected

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

getNumericCellValue is returning more digits from a formula cell than expected

           Summary: getNumericCellValue is returning more digits from a
                    formula cell than expected
           Product: POI
           Version: 2.5
          Platform: Other
        OS/Version: Other
            Status: NEW
          Severity: Normal
          Priority: Other
         Component: HSSF
        AssignedTo: poi-dev@jakarta.apache.org
        ReportedBy: peter.hamann@eu.fkilogistex.com


When getting data from a cell containing af formula, using getNumericCellValue, 
I get a lot of digits that I dont find in the sheet if opened in excel.

E.g. when opened in excel a cell might show the value 0,3, but when getting the 
same cell-value from getNumericCellValue () I will get 0,300000001. 

Why is that ?

/ Peter

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