https://issues.apache.org/bugzilla/show_bug.cgi?id=46028
Summary: Out update formulas in case reset order sheets
Product: POI
Version: 3.1
Platform: PC
OS/Version: Windows XP
Status: NEW
Severity: normal
Priority: P2
Component: HSSF
AssignedTo: [email protected]
ReportedBy: [EMAIL PROTECTED]
CC: [EMAIL PROTECTED]
Created an attachment (id=22742)
--> (https://issues.apache.org/bugzilla/attachment.cgi?id=22742)
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.
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]