Excel |
If you want outline group to be collapsed, you need to set three parameters:
OutlineLevel property needs to be set to correct outline level.
All rows in the collapsed group Hidden property needs to be set to true.
The row where collapsed (plus) sign is located Collapsed property needs to be set to true.