Bug 47916 - sheet setRowGroupCollapsed is behaving unexpectedly - not working
Summary: sheet setRowGroupCollapsed is behaving unexpectedly - not working
Status: NEW
Alias: None
Product: POI
Classification: Unclassified
Component: HSSF (show other bugs)
Version: 3.5-FINAL
Hardware: PC Windows Vista
: P2 normal (vote)
Target Milestone: ---
Assignee: POI Developers List
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2009-09-29 11:01 UTC by Shibaram Sahoo
Modified: 2015-10-29 09:00 UTC (History)
1 user (show)



Attachments
sheet showing unexpected behaviour of the grouping and collapse (22.51 KB, image/jpeg)
2009-09-29 11:01 UTC, Shibaram Sahoo
Details
is the expected report (Normal expected sheet) (65.57 KB, image/jpeg)
2009-09-29 11:49 UTC, Shibaram Sahoo
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Shibaram Sahoo 2009-09-29 11:01:58 UTC
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.
Comment 1 Shibaram Sahoo 2009-09-29 11:49:22 UTC
Created attachment 24323 [details]
is the expected report (Normal expected sheet)

is the expected report (Normal expected sheet)
Comment 2 Shibaram Sahoo 2009-09-29 12:02:11 UTC
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.