Worksheet.row_dimensions.group() does not collapse multi-level outlines
My exported worksheet has a multi-level outline, i.e. groups of rows nested inside a larger group of rows.
I used hidden=True
but when I open the file in Excel, only the top outline level is collapsed. When I open Level 1, Levels 2, 3, etc. inside it are expanded by default.
Adding this line fixes my issue:
# dimensions.py line 222 (DimensionHolder.group() function)
...
new_dim.outline_level = outline_level
new_dim.hidden = hidden
# Added
new_dim.collapsed = hidden
The .hidden
line seems to still be needed, in addition to .collapsed
The column outline code just above this may need a similar addition. Haven't tested that.