https://bz.apache.org/bugzilla/show_bug.cgi?id=60397
Bug ID: 60397
Summary: very slow Cell Merge for SXSSFWorkbook
Product: POI
Version: 3.15-FINAL
Hardware: Macintosh
Status: NEW
Severity: normal
Priority: P2
Component: SXSSF
Assignee: [email protected]
Reporter: [email protected]
Target Milestone: ---
When merging the cells for a SXSSFWorkbook the rendering speed is drastically
reduced. This can be demonstrated by adapting the sample code to merge each of
the cells.
SXSSFWorkbook wb = new SXSSFWorkbook(100);
Sheet sh = wb.createSheet();
for(int rownum = 0; rownum < 10000; rownum = rownum + 2){
Row row1 = sh.createRow(rownum);
Row row2 = sh.createRow(rownum + 1);
for(int cellnum = 0; cellnum < 10; cellnum++){
Cell cell1 = row1.createCell(cellnum);
String address = new CellReference(cell1).formatAsString();
cell1.setCellValue(address);
Cell cell2 = row2.createCell(cellnum);
cell2.setCellValue("");
sh.addMergedRegion(new CellRangeAddress(
rownum,
rownum + 1,
cellnum,
cellnum
));
}
}
--
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]
