|Summary:||Out update formulas in case reset order sheets|
|Product:||POI||Reporter:||Duc Nguyen <duc.nguyen>|
|Component:||HSSF||Assignee:||POI Developers List <dev>|
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)