Bug 15573 - Can not modify a workbook containing a chart
Summary: Can not modify a workbook containing a chart
Status: RESOLVED FIXED
Alias: None
Product: POI
Classification: Unclassified
Component: HSSF (show other bugs)
Version: 3.0-dev
Hardware: PC All
: P3 normal (vote)
Target Milestone: ---
Assignee: POI Developers List
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2002-12-20 16:02 UTC by Frederic Thiriet
Modified: 2005-04-22 06:09 UTC (History)
1 user (show)



Attachments
This Excel 2000 file contains data linked to a chart on another sheet. (14.00 KB, application/vnd.ms-excel)
2002-12-20 16:06 UTC, Frederic Thiriet
Details

Note You need to log in before you can comment on or make changes to this bug.
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.