Approved
Last Updated: 17 Jan 2014 08:32 by Nels
Nels
Created on: 02 Dec 2013 15:43
Category: Grid
Type: Feature Request
2
Export groups to Excel
In a non Telerik 3rd-party tool we can export to Excel, and groups that have been defined will be rendered with group buttons in Excel that can be expanded and collapsed in the Excel spreadsheet. With Telerik when we export a RadGrid that has a user-defined group, there are no grouping expand/collapse buttons in the generated Excel spreadsheet.

Related Telerik Support ID: 758667

Thanks.
2 comments
Nels
Posted on: 02 Dec 2013 17:56
Actually regarding my last comment, I found that the expand was occurring because of the following:
   rgMain.MasterTableView.GroupsDefaultExpanded = True
   rgMain.Rebind()
   rgMain.MasterTableView.ExportToExcel()
However my request to have group expand/collapse buttons in Excel still stands.
Thanks.
Nels
Nels
Posted on: 02 Dec 2013 15:50
Also if a user-defined group is collapsed and then a user exports the grid to Excel then the group is expanded in Excel. If/once group buttons are implemented in the Excel export, it would be preferable for groups that are collapsed in the RadGrid to be collapsed in the Excel export -- i.e. wysiwyg.

Thanks.