Bug 46028

Summary: Out update formulas in case reset order sheets
Product: POI Reporter: Duc Nguyen <duc.nguyen>
Component: HSSFAssignee: POI Developers List <dev>
Severity: normal CC: duc.nguyen
Priority: P2    
Version: 3.1-FINAL   
Target Milestone: ---   
Hardware: PC   
OS: Windows XP   
Attachments: Input for test case.
Output for test-case
Example code test for test function setSheetOrder

Description Duc Nguyen 2008-10-16 09:33:14 UTC
Created attachment 22742 [details]
Input for test case.

Suppose that I have one file excel with 3 sheets (Sheet 1, 2 and 3, respectively), in which, Sheet 2 and 3 contain formulas refer to cells in Sheet 1 (attached please get for example: origin.xls). And after reset order Sheet 2 up to Sheet 1 by function setSheetOrder, all formulas in Sheet 2 and 3 were changed (they change to refering to Sheet 2) (you can view output in file attached output.xls).

my code for test case please get in the attached.
Comment 1 Duc Nguyen 2008-10-16 09:35:42 UTC
Created attachment 22743 [details]
Output for test-case
Comment 2 Duc Nguyen 2008-10-16 09:36:59 UTC
Created attachment 22744 [details]
Example code test for test function setSheetOrder
Comment 3 Andrew 2011-10-01 12:37:48 UTC
Similar bug when deleting a not referenced sheet. The order changes and formulas mess up references.
Comment 4 Dominik Stadler 2013-08-25 18:47:57 UTC
I have tried to reproduce this with the latest version but could not, it seems to work fine now for me. If this problem still happens with a current snapshot build, please reopen this Bug with details which fields in the resulting sheet have which information and what information you would expect them to contain (or preferably provide a unit test which fails by doing verification steps as well)