Bug 58407 - setSheetName() changes named ranges from absolute to relative.
Summary: setSheetName() changes named ranges from absolute to relative.
Status: RESOLVED REMIND
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
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2015-09-14 20:42 UTC by John Claxton
Modified: 2015-10-30 18:15 UTC (History)
1 user (show)


Attachments
Add an attachment (proposed patch, testcase, etc.)

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.