Bug 58407 - setSheetName() changes named ranges from absolute to relative.
Summary: setSheetName() changes named ranges from absolute to relative.
Alias: None
Product: POI
Classification: Unclassified
Component: XSSF (show other bugs)
Version: 3.12-FINAL
Hardware: PC All
: P2 normal (vote)
Target Milestone: ---
Assignee: POI Developers List
Depends on:
Reported: 2015-09-14 20:42 UTC by John Claxton
Modified: 2015-10-30 18:15 UTC (History)
1 user (show)


Note You need to log in before you can comment on or make changes to this bug.
Description John Claxton 2015-09-14 20:42:13 UTC
If XSSFWorkbook.setSheetName() is called when you have named ranges set in the workbook, any absolute ($A$1) references in the named ranges are replaced with relative (A1) references. I suspect the problem is actually caused by XSSFFormulaUtils.updateName(), which is called to update references to the sheet.
Comment 1 Dominik Stadler 2015-09-28 19:05:36 UTC
Any chance of a piece of code which reproduces the problem? Preferably as standalone unit-test...
Comment 2 Dominik Stadler 2015-10-30 18:15:01 UTC
No response for a month so we cannot really work on this, please reopen with more information if you can provide some sample code.