https://issues.apache.org/bugzilla/show_bug.cgi?id=46714
Summary: method 'setRowSumsBelow(false)' doesn't work fine
Product: POI
Version: 3.0
Platform: PC
OS/Version: Windows XP
Status: NEW
Severity: normal
Priority: P2
Component: HSSF
AssignedTo: [email protected]
ReportedBy: [email protected]
Created an attachment (id=23257)
--> (https://issues.apache.org/bugzilla/attachment.cgi?id=23257)
the result iamge
Hello
I use POI 3.0 to create a Excel file with outline. And I use the method
"setRowSumsBelow" to put detail below row summaries.
But when I open my file in MS EXCEL 2000 or Open Office, the row summaries
appear below detail in the outline even if I put true or false to the
method.
I hope you understand my problem.
------------------start------------------
HSSFWorkbook workbook = new HSSFWorkbook();
HSSFSheet sheet = workbook.createSheet("sheet1");
HSSFRow row;
HSSFCell cell;
sheet.setRowSumsBelow(false);
row = sheet.createRow(0);
cell = row.createCell(0);
cell.setCellValue("group");
for(int i=1;i<9;i++){
row = sheet.createRow(i);
cell = row.createCell(0);
cell.setCellValue("value"+i);
}
sheet.groupRow(1, 8);
try {
FileOutputStream fs = new FileOutputStream("./test.xls");
workbook.write(fs);
fs.close();
} catch (IOException e) {
e.printStackTrace();
}
------------------end------------------
result image is as 'result.bmp', but the wanted result is as 'wanted.bmp'.
atattched files: 'result.bmp' and 'wanted.bmp'.
if I want to get the result as 'wanted.bmp' image, how to code?
--
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]
