https://issues.apache.org/bugzilla/show_bug.cgi?id=47100
Summary: Change Worksheet name, related formula are not updated
Product: POI
Version: 3.5-dev
Platform: PC
OS/Version: Windows XP
Status: NEW
Severity: normal
Priority: P2
Component: XSSF
AssignedTo: [email protected]
ReportedBy: [email protected]
Created an attachment (id=23546)
--> (https://issues.apache.org/bugzilla/attachment.cgi?id=23546)
Original.xlsx
I write following codes to change a worksheet name, but the related named range
"OriginalValue" does not update its formula: expected "New!$A$1" but actual
"Original!$A$1".
--
Workbook sourceWb = (open "Original.xlsx"...)
int sheetIdx = sourceWb.getSheetIndex("Original");
sourceWb.setSheetName(sheetIdx, "New");
sourceWb.write(new FileOutputStream("New.xlsx"));
--
The Excel 2007 file for testing is 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]
