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 48124] New: The Precision is lossed when i prasing excel used poi
Date Wed, 04 Nov 2009 10:43:23 GMT

           Summary: The Precision is lossed when i prasing excel used poi
           Product: POI
           Version: 3.5-FINAL
          Platform: PC
        OS/Version: Linux
            Status: NEW
          Severity: critical
          Priority: P5
         Component: HSSF
        AssignedTo: dev@poi.apache.org
        ReportedBy: xunwei@csii.com.cn

  I am so sorry ,my english is not very well.But i have some trouble in using
POI to parse excel,the precision is lossed.
  For exampe,the right amount is:1860.68,but the result is 1860.6800000000001
when i using poi in Linux 64-bit and the poi version is poi-3.5-FINAL.
  If I run the project in Linux 32-bit,the result is right.But I can't change
the os because it's a production.
  Pls give me some suggestions and i must solve it quickly because many users
can't use  our product.

  This is the testing code in Linux RatHat5.0 64-bit :

    *This function return 1860.6800000000001 which i see in the log,but the 
    * amount is 1860.68 in the excel
   public double getNumericCellValue(HSSFSheet hssfsheet, int i, int j)
       HSSFCell hssfcell = getCell(hssfsheet, i , j );
       double value=hssfcell.getNumericCellValue();
       return vaule;


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

View raw message