Cannot set outline group to collapsed on open
Created originally on Bitbucket by ekowal (Emily Kowal)
Struggling to figure out how to get an outline grouping of rows to present as collapsed when initially opening excel sheet. Current code:
#!python
target_ws.worksheet.row_dimensions[target_row].outlineLevel = outline_level
target_ws.worksheet.row_dimensions[target_row].collapsed = True
Outline level is working perfetly, however collapsed seems to have no effect on desired rows.
An example or clarification would be great! Thanks.