Bug 46028 - Out update formulas in case reset order sheets
Summary: Out update formulas in case reset order sheets
Alias: None
Product: POI
Classification: Unclassified
Component: HSSF (show other bugs)
Version: 3.1-FINAL
Hardware: PC Windows XP
: P2 normal (vote)
Target Milestone: ---
Assignee: POI Developers List
Depends on:
Reported: 2008-10-16 09:33 UTC by Duc Nguyen
Modified: 2013-08-25 18:47 UTC (History)
1 user (show)

Input for test case. (13.50 KB, application/vnd.ms-excel)
2008-10-16 09:33 UTC, Duc Nguyen
Output for test-case (13.00 KB, application/vnd.ms-excel)
2008-10-16 09:35 UTC, Duc Nguyen
Example code test for test function setSheetOrder (1.36 KB, application/octet-stream)
2008-10-16 09:36 UTC, Duc Nguyen

Note You need to log in before you can comment on or make changes to this bug.
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)