Summary: | Out update formulas in case reset order sheets | ||
---|---|---|---|
Product: | POI | Reporter: | Duc Nguyen <duc.nguyen> |
Component: | HSSF | Assignee: | POI Developers List <dev> |
Status: | RESOLVED WORKSFORME | ||
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 |
Created attachment 22743 [details]
Output for test-case
Created attachment 22744 [details]
Example code test for test function setSheetOrder
Similar bug when deleting a not referenced sheet. The order changes and formulas mess up references. 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) |
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.