Bug 60509

Summary: XSSFWorkbook.setSheetName() does not update references in charts
Product: POI Reporter: Tarik <tarik.osswald>
Component: XSSFAssignee: POI Developers List <dev>
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