Bug 53721 - Formula Shifter doesnt update Ref3DPtgs correctly when a sheet is shifted or deleted
Summary: Formula Shifter doesnt update Ref3DPtgs correctly when a sheet is shifted or ...
Status: RESOLVED LATER
Alias: None
Product: POI
Classification: Unclassified
Component: HSSF (show other bugs)
Version: 3.8-dev
Hardware: PC All
: P2 normal (vote)
Target Milestone: ---
Assignee: POI Developers List
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2012-08-14 22:48 UTC by val235
Modified: 2015-06-01 21:12 UTC (History)
0 users



Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description val235 2012-08-14 22:48:33 UTC
FormulaShifter does not update sheet references in formulas correctly when using
workbook.setSheetOrder(tabName, newIndex); 

Same issue can be observed during sheet remove using workbook.removeSheetAt(index)

After the operation, forumals reference wrong sheets, or sheets that no longer exist.
Comment 1 Yegor Kozlov 2012-12-04 12:49:57 UTC
Can you upload a Java code (ideally a failing junit test) that demonstrates the problem?
Comment 2 Dominik Stadler 2015-06-01 21:12:12 UTC
We did not get enough information to work on this bug, so resolving this one for now, please reopen with a unit test that shows the problem if this is still an issue.