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: [EMAIL PROTECTED] ReportedBy: [EMAIL PROTECTED] CC: [EMAIL PROTECTED] 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. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]