DO NOT REPLY [Bug 22404] New: - cell format error with append sheet to exists file

[bu...@apache.org]

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=22404>.
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=22404

cell format error with append sheet to exists file

           Summary: cell format error with append sheet to exists file
           Product: POI
           Version: 2.0-pre2
          Platform: PC
        OS/Version: Windows NT/2K
            Status: NEW
          Severity: Normal
          Priority: Other
         Component: HSSF
        AssignedTo: poi-dev@jakarta.apache.org
        ReportedBy: algusev@hotmail.com


Hello, guys!

Have a probs with cell format.
My cell has next format:
style.setDataFormat(format.getFormat("#,##0.00;[Red]-#,##0.00"));
It is working fine when i create new xls file:               
wb = new HSSFWorkbook();
But when I open exists xls file and add new sheet:

FileInputStream fis = new FileInputStream(file);
POIFSFileSystem poifs = new POIFSFileSystem(fis);
wb = new HSSFWorkbook( poifs );

the same code for cell formatting give me wrong result. 
My cell, when I open xls file with excel, has format: ;;;
So, as result no data in cell with such format.

Where is my probs ?

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