Excel export a grid that is grouped and also set the state of whether the groups should be collapsed or not
Is it possible to set the state of whether the groups are collapsed or not by default once you open the excel file, or is that not an option?
Hello, Huw,
You can export a Grid with its grouping by setting the ExcelExport group prop the group state:
In addition, you can set the ExcelExport collapsible prop to enable/disable the collapsing of the groups in the Excel sheet. However, currently there is not an option to set the collapsed state of the groups by default when opening the excel file. Therefore, I am transforming this thread into a public feature request in our feedback portal where new ideas are constantly being evaluated and the most popular ones are implemented in future releases.
Kind regards,
Wissam
Progress Telerik
Love the Telerik and Kendo UI products and believe more people should try them? Invite a fellow developer to become a Progress customer and each of you can get a $50 Amazon gift voucher.