| Summary: | XLSX is corrupted after set value to cell. | ||
|---|---|---|---|
| Product: | POI | Reporter: | Matthew <matthew.knl> |
| Component: | XSSF | Assignee: | POI Developers List <dev> |
| Status: | RESOLVED FIXED | ||
| Severity: | major | ||
| Priority: | P2 | ||
| Version: | 3.5-dev | ||
| Target Milestone: | --- | ||
| Hardware: | PC | ||
| OS: | Windows XP | ||
| Attachments: |
excel for testing
excel error log |
||
Created attachment 23245 [details]
excel error log
Sorry for typo mistake. The bug description should be: I use following code try to set a cell value, but after it cannot be opened by MS EXCEL. (It prompted an error message and asked for recover) |
Created attachment 23244 [details] excel for testing I use following code try to set a cell value, but after it cannot be opened by MS Word. (It prompted an error message and asked for recover) -- Workbook wb = new XSSFWorkbook("original.xlsx"); Sheet sheet = wb.getSheet("HouseShippingOrder"); Cell cell = sheet.getRow(1).getCell(10); cell.setCellFormula(null); cell.setCellValue("ABC"); wb.write(new FileOutputStream("output.xlsx"));