Created attachment 24322 [details] sheet showing unexpected behaviour of the grouping and collapse I am creating an 97 format excel sheet report, fetching datas from database (more than 4000 records). Scenario:: I am grouping the users according to their level (General Manager, Sales Manager, and Sales Representatives). After grouping I am collapsing the inner levels. I use below code snippet: sheet.groupRow(start, end); sheet.setRowGroupCollapsed(start, true); Every thing was working fine (rows were grouping and collapsing perfectly) till last Friday. But on Monday, when I executed the code again, to my surprise the sheet created, in that rows are not visible, all rows in collapsed state shifted (or became hidden). Note: I have not used any hidden attribute of any kind. But when I comment the line // sheet.setRowGroupCollapsed(start, true); at least for the inner level of users. Rows in the sheet shows up correctly Please see the attached screenshots. Image : poi-02.jpg is the expected report (Normal expected sheet) Image: poi-01.jpg is the sheet showing unexpected behaviour of the grouping and collapse Please suggest any workaround. Does any body faced this problem ? I am able to regenerate the problem again and again.
Created attachment 24323 [details] is the expected report (Normal expected sheet) is the expected report (Normal expected sheet)
This is neither working with poi-3.5-FINAL nor with poi-3.2-FINAL. I am developing with poi-3.2-Final. But, verified the problem with both versions.