Page 1 of 1

Solved- Collapsing Groups - How?

PostPosted: Fri Jun 17, 2011 11:42 pm
by arimmer
I have successfully added grouping to my report by setting the outline levels on rows, but can't get it to open in MS Excel with the groups collapsed.

If I collapse the groups within MS Excel and save and close the spreadsheet and re-open it, the groups stay collapsed, but I haven't yet found what is allowing this. (I am setting the collapsed and hidden attributes on the row)

I'll keep investigating, but thought I'd ask here if anyone else knows how to solve this problem?

Re: Collapsing Groups - How?

PostPosted: Sat Jun 18, 2011 1:03 am
by arimmer
Problem solved.

As well as setting the maximum outline level within the sheet in the SheetFormatPr element, it is also necessary to set the default row height in the same element.

Re: Solved- Collapsing Groups - How?

PostPosted: Sat Jun 18, 2011 10:33 am
by jason
Thanks for letting us know :-)