Bug 21580 - Data Format for double numbers (more than 2 decimals) not working
Summary: Data Format for double numbers (more than 2 decimals) not working
Status: RESOLVED FIXED
Alias: None
Product: POI
Classification: Unclassified
Component: HSSF (show other bugs)
Version: 1.5.1
Hardware: All All
: P3 normal (vote)
Target Milestone: ---
Assignee: POI Developers List
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2003-07-14 18:30 UTC by Yashwant Singh
Modified: 2005-03-20 17:06 UTC (History)
1 user (show)


Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Yashwant Singh 2003-07-14 18:30:59 UTC 
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.
Comment 1 Andy Oliver 2003-07-14 18:48:21 UTC 
please try with 2.0-pre2
Comment 2 Yashwant Singh 2003-07-15 18:20:48 UTC 
Support of user defined data format in 2.0-pre2 is awesome.  Thanks for the 
great effort. This bug can be closed now.
Comment 3 Andy Oliver 2003-07-24 17:10:45 UTC 
excellent.