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 ?
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.