https://bz.apache.org/bugzilla/show_bug.cgi?id=59300
Bug ID: 59300
Summary: default sheet name for the 1st sheet has to be
"Sheet1" instead pf "Sheet0"
Product: POI
Version: unspecified
Hardware: All
OS: All
Status: NEW
Severity: normal
Priority: P2
Component: HSSF
Assignee: [email protected]
Reporter: [email protected]
When MS Excel, Libreoffice opens - they create an empty spread sheet with name
"Sheet1".
XSSFSheet (and potentially other implementations) calls it "Sheet0" that is
inconvenient.
public XSSFSheet createSheet() {
String sheetname = "Sheet" + (sheets.size());
int idx = 0;
while(getSheet(sheetname) != null) {
sheetname = "Sheet" + idx;
idx++;
}
return createSheet(sheetname);
}
it is worth to change it to
public XSSFSheet createSheet() {
String sheetname = "Sheet" + (sheets.size() + 1);
int idx = 0;
while(getSheet(sheetname) != null) {
sheetname = "Sheet" + idx;
idx++;
}
return createSheet(sheetname);
}
--
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]
