https://issues.apache.org/bugzilla/show_bug.cgi?id=47916
Summary: sheet setRowGroupCollapsed is behaving unexpectedly -
not working
Product: POI
Version: 3.2-FINAL
Platform: PC
OS/Version: Windows Vista
Status: NEW
Severity: normal
Priority: P2
Component: HSSF
AssignedTo: [email protected]
ReportedBy: [email protected]
Created an attachment (id=24322)
--> (https://issues.apache.org/bugzilla/attachment.cgi?id=24322)
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.
--
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]
