Bug 22404 - [INFO NEEDED]cell format error with append sheet to exists file
Summary: [INFO NEEDED]cell format error with append sheet to exists file
Status: RESOLVED WORKSFORME
Alias: None
Product: POI
Classification: Unclassified
Component: HSSF (show other bugs)
Version: 2.0-pre2
Hardware: PC All
: P3 normal (vote)
Target Milestone: ---
Assignee: POI Developers List
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2003-08-14 06:42 UTC by Akexander Gusev
Modified: 2009-02-18 09:25 UTC (History)
0 users



Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Akexander Gusev 2003-08-14 06:42:11 UTC
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 ?
Comment 1 Avik Sengupta 2003-10-30 18:47:03 UTC
Please provide a compilable testcase and an example excel sheet. I cannot
understand the bug in its current format. 
Comment 2 David Fisher 2009-02-18 09:25:50 UTC
No response for over 5 years - and cell formatting is working.