https://issues.apache.org/bugzilla/show_bug.cgi?id=53514
Priority: P2
Bug ID: 53514
Assignee: [email protected]
Summary: blank row getting created after row no 32767
Severity: major
Classification: Unclassified
Reporter: [email protected]
Hardware: PC
Status: NEW
Version: unspecified
Component: SXSSF
Product: POI
HI All,
POI Version used : 3.8 Stable and poi-3.9-beta1-20120422,
poi-3.9-beta1-20120628 (POI nightly builds from Jenkins)
Below is the sample code.
SXSSFWorkbook workbook = new SXSSFWorkbook(50);
workbook.setCompressTempFiles(true);
SXSSFSheet worksheet=null;
String header = "";
CellStyle cellStyle = workbook.createCellStyle();
Font font = workbook.createFont();
Font fontd = workbook.createFont();
ArrayList rowdata = null;
String data = "";
SXSSFCell cell=null;
CellStyle cellStyle1=null;
SXSSFRow row=null;
cellStyle.setFillForegroundColor(IndexedColors.ROYAL_BLUE.index);
cellStyle.setFillPattern(CellStyle.SOLID_FOREGROUND);
font.setBoldweight(Font.BOLDWEIGHT_BOLD);
font.setColor(IndexedColors.WHITE.index);
font.setFontHeightInPoints((short)10);
font.setFontName("Arial");
cellStyle.setFont(font);
fontd.setColor(IndexedColors.BLACK.index);
fontd.setFontHeightInPoints((short)10);
fontd.setFontName("Arial");
System.out.println("Matrix Report noofrows::"+noofrows);
for(long i = 0,rowNo=1 ; i < noofrows;i++,rowNo++){
worksheet = (SXSSFSheet) workbook.createSheet("Matrix Report "+sheetNo);
row = (SXSSFRow) worksheet.createRow(0);
for(int hl=0; hl<headerLength; hl++){
cell = (SXSSFCell) row.createCell(hl);
header = (String)matrixReportHeader.get(hl);
cell.setCellValue(header);
cell.setCellStyle(cellStyle);
cell=null;
}
row = (SXSSFRow) worksheet.createRow((int)rowNo);
rowdata = (ArrayList)matrixReportdata.get((int)i);
cellStyle1 = workbook.createCellStyle();
if(rowNo%2 != 0){
cellStyle1.setFillForegroundColor(IndexedColors.LIGHT_CORNFLOWER_BLUE.index);
cellStyle1.setFillPattern(CellStyle.SOLID_FOREGROUND);
}
cellStyle1.setFont(fontd);
for(int j=0; j<rowdata.size(); j++){
cell = (SXSSFCell) row.createCell(j);
data = (String)rowdata.get(j);
if(data==null) data="";
cell.setCellValue(data);
cell.setCellStyle(cellStyle1);
}
}
--
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]
