Bug 54751 - Add levels to groupRow
Summary: Add levels to groupRow
Status: NEEDINFO
Alias: None
Product: POI
Classification: Unclassified
Component: XSSF (show other bugs)
Version: 3.9-FINAL
Hardware: PC All
: P2 enhancement with 1 vote (vote)
Target Milestone: ---
Assignee: POI Developers List
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2013-03-25 18:14 UTC by Christopher Florencia
Modified: 2020-04-15 11:03 UTC (History)
0 users



Attachments
Group row multilevel (3.57 KB, image/png)
2013-03-25 18:14 UTC, Christopher Florencia
Details
Bug not reproduced (6.01 KB, image/png)
2020-04-15 11:01 UTC, Eugene Kortov
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Christopher Florencia 2013-03-25 18:14:53 UTC
Created attachment 30102 [details]
Group row multilevel

I need to show my information into different row levels using the function groupRow 

sheet.groupRow( 0, 5 )
sheet.groupRow( 1, 4 )
sheet.groupRow( 2, 3 )

-0
--1
---2
---3
--4
-5


Actually all rows have the same group in the first level
Expected behavior in the attachment
Comment 1 Eugene Kortov 2020-04-15 10:59:55 UTC
Hi, I checked on Poi 4.1.1 and doesn't have such behaviour with this code (added a screenshot "Screenshot from 2020-04-15 14-55-04.png")

import org.apache.poi.ss.usermodel.*;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;

import java.io.FileInputStream;
import java.io.FileOutputStream;

class ExcelGroupColumns {

    public static void main(String[] args) throws Exception{

        Workbook workbook = new XSSFWorkbook();

        Sheet sheet = workbook.createSheet("Sheet1");
        for (int rowNum = 0; rowNum < 6; rowNum++) {
            Row row = sheet.createRow(rowNum);
            for (int i = 0; i < 25; i++) {
                Cell cell = row.createCell(i);
                cell.setCellValue("Col" + rowNum + " " + i);

            }
        }

        sheet.groupRow( 0, 5 );
        sheet.groupRow( 1, 4 );
        sheet.groupRow( 2, 3 );



        FileOutputStream out = new FileOutputStream("Test_1.xlsx");
        workbook.write(out);
        out.close();
        workbook.close();

    }
}
Comment 2 Eugene Kortov 2020-04-15 11:01:19 UTC
Created attachment 37173 [details]
Bug not reproduced
Comment 3 Eugene Kortov 2020-04-15 11:03:11 UTC
neen your info