Bug 53721

Summary:	Formula Shifter doesnt update Ref3DPtgs correctly when a sheet is shifted or deleted
Product:	POI	Reporter:	val235
Component:	HSSF	Assignee:	POI Developers List <dev>
Status:	RESOLVED LATER
Severity:	normal
Priority:	P2
Version:	3.8-dev
Target Milestone:	---
Hardware:	PC
OS:	All

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.