posted 12 years ago
I am using it to generate a Excel spreadsheet. And one feature is to expand\contract rows as groups. The trouble is: I have one overall level, then I want multiple level 2 levels that group the rows. I can't seem to get the numaric combination right. I end up with a single level two grouping that expands between 1 to 10.
hssfSheet.groupRow(1, 20);//level 1
hssfSheet.groupRow(1, 7);//level 2
hssfSheet.groupRow(8, 10);//level 2
This is what I am trying to achieve; two row groups, 1 to 7 and 8 to 10, both at level 2.
_____
1| | 1
| |
| |
| |
| |
| |
| |7(-)
| |8
| |
| |10(-)
|
|
|
|
|15(-)