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 21580] New: - Data Format for double numbers (more than 2 decimals) not working
Date Mon, 14 Jul 2003 18:31:00 GMT
DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG 
RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT
<http://nagoya.apache.org/bugzilla/show_bug.cgi?id=21580>.
ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND 
INSERTED IN THE BUG DATABASE.

http://nagoya.apache.org/bugzilla/show_bug.cgi?id=21580

Data Format for double numbers (more than 2 decimals) not working 

           Summary: Data Format for double numbers (more than 2 decimals)
                    not working
           Product: POI
           Version: 1.5.1
          Platform: All
        OS/Version: Windows NT/2K
            Status: NEW
          Severity: Normal
          Priority: Other
         Component: HSSF
        AssignedTo: poi-dev@jakarta.apache.org
        ReportedBy: yash2022@yahoo.com
                CC: yash2022@yahoo.com


I have tried following data formats for for HSSFCell
#,##0.0000
#,##0.000
#,###.0000
But I am not getting the expected result. I am using poi version 1.5.1 and I 
have tried 1.10 dev jar also. Following are the result

Value             Data Format          Result              Expected result
12345.12345       #,##0.0000           12345.12345          12,345.1234
12345.12          #,##0.0000           12345.12             12,345.1200
-12345.123456     #,##0.0000          -12345.123456        -12,345.1234
12345.12345       #,##0.000            12345.12345          12,345.123
12345             #,##0.000            12345                12,345.000

Please let me know it I am expecting something unusual. But the number of 
decimal digits are not returning correct.  Please suggest solution.

Mime
View raw message