| Summary: | NullPointerException when opening existing Workbook | ||
|---|---|---|---|
| Product: | POI | Reporter: | Simon Gunzenreiner <simon.gunzenreiner> |
| Component: | HSSF | Assignee: | POI Developers List <dev> |
| Status: | RESOLVED FIXED | ||
| Severity: | enhancement | ||
| Priority: | P3 | ||
| Version: | 1.5 | ||
| Target Milestone: | --- | ||
| Hardware: | PC | ||
| OS: | other | ||
| URL: | none | ||
| Attachments: | Excel workbook containing charts | ||
Created attachment 1751 [details]
Excel workbook containing charts
glen, can you look at this? Looks like an issue with the charts in the spreadsheet. Since we're currently in the process of looking into how the whole charting thing works with Excel right now a solution will probably fall out from that. Sorry for the slowness with my progress on this one. This bug occurs when the chart is in a different sheet that the data used to create it. If the data and the chart are on the same sheet, no errors occur. Using HEAD, the attached file now reads and writes correctly. Suspect that this has been fixed for quite a while. |
On execution of the following code, a uncaught NullPointerException occurs: File f = new File("test.xls"); POIFSFileSystem fs = new POIFSFileSystem(new FileInputStream(f)); HSSFWorkbook wb = new HSSFWorkbook(fs); in the HSSFSheet.setPropertiesFromSheet() method at hrow.createCellFromRecord(cval). The Exception occurs on the first cycle of the while loop. I would like to attach my Excel workboob, if I figure out how to do this (otherwise I will mail it).