|Summary:||XSSFWorkbook.setSheetName() does not update references in charts|
|Component:||XSSF||Assignee:||POI Developers List <dev>|
|Bug Depends on:||54470|
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.