Bug 60509

Summary:	XSSFWorkbook.setSheetName() does not update references in charts
Product:	POI	Reporter:	Tarik <tarik.osswald>
Component:	XSSF	Assignee:	POI Developers List <dev>
Status:	RESOLVED FIXED
Severity:	enhancement
Priority:	P2
Version:	3.14-FINAL
Target Milestone:	---
Hardware:	PC
OS:	All
Bug Depends on:	54470
Bug Blocks:

Description Tarik 2016-12-22 10:25:40 UTC

I have a base xlsx file with several tabs and charts.

When I work on this file with POI, I need to change the sheet names.

Unfortunately, the data referenced by the chart keeps the reference to the old chart Name when I use XSSFWorkbook.setSheetName().

Related bugs have been fixed for formulas and named ranges, but apparently not for Charts.

Comment 1 Dominik Stadler 2016-12-28 20:02:35 UTC

As stated in http://poi.apache.org/spreadsheet/limitations.html support for charts is very limited currently, therefore this would likely involve a bit more work to prepare more fundamental support for handling charts first...

Comment 2 Alain Fagot Bearez 2018-09-26 21:08:36 UTC

I found valuable code in #54470 that can be applied to fix this issue.

I am working on it.

Comment 3 Alain Fagot Bearez 2018-10-01 19:29:38 UTC

resolved by r1842548