Bug 15573

Summary: Can not modify a workbook containing a chart
Product: POI Reporter: Frederic Thiriet <fthiriet>
Component: HSSFAssignee: POI Developers List <dev>
Status: RESOLVED FIXED    
Severity: normal CC: nmoyere
Priority: P3    
Version: 3.0-dev   
Target Milestone: ---   
Hardware: PC   
OS: All   
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.