Bug 47813 - Problems with XSSFWorkbook.removeSheetAt when workbook contains chart
Summary: Problems with XSSFWorkbook.removeSheetAt when workbook contains chart
Status: RESOLVED FIXED
Alias: None
Product: POI
Classification: Unclassified
Component: XSSF (show other bugs)
Version: unspecified
Hardware: PC Mac OS X 10.4
: P2 normal (vote)
Target Milestone: ---
Assignee: POI Developers List
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2009-09-09 22:14 UTC by David Agnew
Modified: 2009-09-13 07:49 UTC (History)
0 users


Attachments
Test case to demonstrate problems with XSSFWorkbook.removeSheetAt. (495.27 KB, application/zip)
2009-09-09 22:14 UTC, David Agnew 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description David Agnew 2009-09-09 22:14:21 UTC 
Created attachment 24243 [details]
Test case to demonstrate problems with XSSFWorkbook.removeSheetAt.

Application modifies a template worksheet to which a separate chart refers. It
then attempts to delete a control sheet containing parameters for the run. In
my app, it deletes the chart instead, leaving the control sheet in the output
workbook.

I've attached a test case which demonstrates the above, as well as throwing a
XmlValueDisconnectedException when there are two "control" sheets to delete.

It works properly if the chart is the last item in the workbook.
Comment 1 David Agnew 2009-09-09 22:20:22 UTC 
The problematic workbooks were created by Excel 2008 for Mac, version 12.2.1.
Comment 2 Yegor Kozlov 2009-09-13 07:49:29 UTC 
Fixed in r814176

Sheets of type 'chartsheet' were not supported and XSSFWorkbook.removeSheetAt actually modified wrong data. 

Yegor