| Summary: | [INFO NEEDED]cell format error with append sheet to exists file | ||
|---|---|---|---|
| Product: | POI | Reporter: | Akexander Gusev <algusev> |
| Component: | HSSF | Assignee: | POI Developers List <dev> |
| Status: | RESOLVED WORKSFORME | ||
| Severity: | normal | ||
| Priority: | P3 | ||
| Version: | 2.0-pre2 | ||
| Target Milestone: | --- | ||
| Hardware: | PC | ||
| OS: | All | ||
Please provide a compilable testcase and an example excel sheet. I cannot understand the bug in its current format. No response for over 5 years - and cell formatting is working. |
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 ?