https://issues.apache.org/bugzilla/show_bug.cgi?id=48462
Summary: Excel Name Box could not display the range name
corresponding to the singlecell after create/change
the range name using POI
Product: POI
Version: 3.2-FINAL
Platform: PC
OS/Version: Windows XP
Status: NEW
Severity: normal
Priority: P2
Component: HSSF
AssignedTo: [email protected]
ReportedBy: [email protected]
Created an attachment (id=24773)
--> (https://issues.apache.org/bugzilla/attachment.cgi?id=24773)
a jpeg describes the usage of namebox for the relationship between single cell
and a range name
Excel Name Box could not display the range name corresponding to the singlecell
after create/change the range name using POI.
Below is the codes:
InputStream inp = new FileInputStream("testRF.xls");
HSSFWorkbook wb = new HSSFWorkbook(inp);
HSSFName name = wb.getNameAt(wb.getNameIndex("testCell"));
CellReference reference = new CellReference("Sheet1!A2");
name.setReference(reference.formatAsString());
File file = new File("output_testRF.xls");
if(file.exists())
file.delete();
FileOutputStream fileOut = new FileOutputStream("output_testRF.xls");
wb.write(fileOut);
fileOut.close();
--
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]
