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.

Currently only columns in first level of hierarchy trigger horizontal scroll bar when being expanded by width. The goal is when resizing columns deeper in the hierarchy to trigger scroll too.

<ClientSettings AllowDragToGroup="true">
<Resizing AllowColumnResize="true" AllowResizeToFit="true" EnableRealTimeResize="true" ClipCellContentOnResize="false" ResizeGridOnColumnResize="false"/>
<Scrolling AllowScroll="true" UseStaticHeaders="true"/>
</ClientSettings>

Currently ExcelML format does not work when both hierarchy and grouping are used.

It is a bit disappointing that Enum filtering is not supported. I would recommend you re-evaluate the need for this type of support given the fact that the Entity Framework now supports Enums (I think as of 4.1?) AND since the RadGrid supports binding against the Entity Data Source.

I think you'll find that Enums are very popular when using the Entity Framework Code First approach. It would be SUPER useful if your development team could find a way to support this. It would make an already great control even greater!

Hi,

 In our project we are using the telerik grid on Invoice screen to display item list. 
 We are adding item from text box and adds it to grid dynamically using UpdateGrid javascript function. 
 
 Issue:
  When we add the new item to grid. It adds to grid as last row. But grid is not scrolling to last row.
  We want to scroll grid to last row every time we add new item.
  
  Below are the settings used in grid which did not work out:
<ClientEvents OnRowSelected="rowSelected" OnRowCreated="OnRowCreated" OnRowCreating="OnRowCreating" />
<Scrolling AllowScroll="True" EnableVirtualScrollPaging="True" UseStaticHeaders="false" SaveScrollPosition="true" />
  
Please help.

Hi,
I am adding items to radgrid using cleint side javascript using updateGrid function.
My grid structure is DIV -> Table -> Radgrid.

I am adding rows dynamically based on the values added from the external fields.
I want the grid scroll bar at the last row position.
I have already tried all settings suggested from telerik site but was no success.
Below are the settings added which did not worked out:
<ClientEvents OnRowSelected="rowSelected" OnRowCreated="OnRowCreated" OnRowCreating="OnRowCreating" />
<Scrolling AllowScroll="True" EnableVirtualScrollPaging="True" UseStaticHeaders="false" SaveScrollPosition="true" />

Please help.

Regards.

Currently the RADGrid  only supports creation of columns on the server side. With todays browsers capabilities it is important to support client side column creation as well.

Currently to use a UserControl in RadGrid, it has to be in EditFormSettings defined as UserControlName. This functionallity requires filling all the controls of UserControl again on ItemDataBound event.
It should be possible to put the UserControl in FormTemplate when EditFormType is "Template" . Thank you.

We have to bind a Grid to a SQLDataSource with several columns that should be displayed and edited as a CheckBox column.

We've seen in your manuals that a GridCheckBoxColumn can be binded to a datafield with 'True' or 'False', but what about the fields that contains numerics 1 or 0 ?   

(SQLDataSource does not have a True/False column, so, the GridCheckBoxColumn is useless)

We've also seen a workarround with Templates, but when in edit mode, it is very tedious. 

In our opinion, it's a very common procedure to display numeric columns with Checkboxes. Do you plan to add this feature in new versions?

Thank you in advance.