Bug 60509 - XSSFWorkbook.setSheetName() does not update references in charts
Summary: XSSFWorkbook.setSheetName() does not update references in charts
Alias: None
Product: POI
Classification: Unclassified
Component: XSSF (show other bugs)
Version: 3.14-FINAL
Hardware: PC All
: P2 enhancement (vote)
Target Milestone: ---
Assignee: POI Developers List
Depends on: 54470
  Show dependency tree
Reported: 2016-12-22 10:25 UTC by Tarik
Modified: 2018-10-01 19:29 UTC (History)
0 users


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