Hello, I try to create a new file from an existing Excel file. My program works well on WAS3.5 on NT. But when I deploy my program on WAS3.5 on Mainframe, when opening generated file, Excel displays "File error. Some number formats may have been lost." and all string from the template file were unreadable. I used POI-1.8.0-dev. source of the program : FileInputStream fis = new FileInputStream(FmkPropertiesManager.getRootDir() + "model.xls"); POIFSFileSystem fs = new POIFSFileSystem(sourceModel); HSSFWorkbook wb = new HSSFWorkbook(fs); fis.close(); FileOutputStream fileOut = new FileOutputStream (FmkPropertiesManager.getUploadPath()+resultName); wb.write(fileOut); fileOut.close();
We need the code used to generate it (simplest runnable code which replicates the problem), the generated sheet, etc. I don't remember when the default character set fixes were put in but htis seems releated. Once you provide those things please reopen. (click "create a new attachment)
Created attachment 14338 [details] file error.some number formats may been lost today open 2 excel files and have the same result.