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.

Hi,

in Radgrid header context menu filter section would be nice the possibility to add field to filter and change the logical operator (AND / OR ).

Best Regards

Enable drag-and-drop between cells

I would like to see the RadGrid control have support for a global header and footer template row for the entire grid.

The header or footer would be rendered within a row inserted at the top or bottom of the grid, with styling consistent with the grid's skin.  It would actually be very similiar to CommandItemTemplate, but could be used with the default command rows and would apply to the very top and bottom of the grid, and not be part of the MasterTableView.  It would simply be to anchor something to the top or bottom of the grid with a consistent look, feel, and width of the rest of the grid.

<TELERIK:RadGrid Runat="server">
<HeaderTemplate>
Whatever I want to put here would be placed in it's own row at the very top of the grid and it would be automatically styled consistent with the Grid's skin.  I could put controls in here and they would bubble through the grid (and it's AJAX functionality, if anything is enabled). 
</HeaderTemplate>
<MasterTableView ... />
<FooterTemplate>
Same here, except it goes at the bottom of the grid.
</FooterTemplate>
</TELERIK:RadGrid>

In the example image I attached, the bottom row with "Primary Service Completed" is not actually part of the grid, but we used some CSS to make it look like it was... but that particular CSS is fragile if we ever changed the global skin on the site or for the Grid in particular.  That is what I might want to put in the FooterTemplate.

While implement this demo http://demos.telerik.com/aspnet-ajax/grid/examples/dataediting/batchediting/defaultcs.aspx, when I was about to save changes I clicked "Add new record" instead "Save changes" and because of RequireFieldValidator in Unit Price I cant save changes. Now I am forced to add information to new record in order to save changes and not losing the rows I already added. I attached an image with the scenario.