When trying to instantiate a workbook containing a chart on another sheet than the data, or when a chart is created as a new sheet, the HSSFWorkbook(fs) constructor fails. However when the chart is in the same sheet as the data, it seems to work fine. Tested with the latest nighlty jar : jakarta-poi-1.9.0-dev-20021216.jar Here is the stack trace : ----- java.lang.NullPointerException at org.apache.poi.hssf.usermodel.HSSFSheet.setPropertiesFromSheet(HSSFSheet.java:171) at org.apache.poi.hssf.usermodel.HSSFSheet.<init>(HSSFSheet.java:134) at org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:154) at com.calendra.services.functions.ExcelTest.writeResults(ExcelTest.java:28) at com.calendra.services.functions.ExcelTest.main(ExcelTest.java:110)
Created attachment 4238 [details] This Excel 2000 file contains data linked to a chart on another sheet.
put off till 3.0
I just checked the latest production release 2.0 and it is working fine.
Sorry, My mistake. I didn't read it comepletely.
File is read fine. the following code works on CVS HEAD. HSSFWorkbook wb = new HSSFWorkbook(in); assertTrue("No Exceptions while reading file", true); Testcase added. Of course, no guarantees of data reproduction on rewrite.