Created attachment 23257 [details] 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?
Created attachment 23258 [details] the result image
Created attachment 23259 [details] the wanted iamge
I think this is a duplicate of https://issues.apache.org/bugzilla/show_bug.cgi?id=30714 Try calling sheet.setAlternativeExpression(false); instead until it is fixed properly
Fixed in r766273 I changed sheet.setRowSumsBelow to propagate the boolean flag to sheet.setAlternativeExpression. These two methods work in conjunction. Regards, Yegor