|Summary:||Can not modify a workbook containing a chart|
|Product:||POI||Reporter:||Frederic Thiriet <fthiriet>|
|Component:||HSSF||Assignee:||POI Developers List <dev>|
|Attachments:||This Excel 2000 file contains data linked to a chart on another sheet.|
Description Frederic Thiriet 2002-12-20 16:02:54 UTC
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)
Comment 1 Frederic Thiriet 2002-12-20 16:06:45 UTC
Created attachment 4238 [details] This Excel 2000 file contains data linked to a chart on another sheet.
Comment 2 Andy Oliver 2003-07-24 14:09:12 UTC
put off till 3.0
Comment 3 Sri 2004-02-25 18:08:42 UTC
I just checked the latest production release 2.0 and it is working fine.
Comment 4 Sri 2004-02-25 18:12:37 UTC
Sorry, My mistake. I didn't read it comepletely.
Comment 5 Avik Sengupta 2005-04-22 14:09:49 UTC
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.