ExcelML currently does not support multiple column headers (aka ColumnGroups). This was first requested in the forms back in 2012 and no feature request was created for ExcelML. It is important that ExcelML support ColumnGroups as Excel does support this functionality.

If using Frozen Columns with MultiHeaders, where one column has many headers while the other fewer. Each header in a column occupies some space and they get hidden, this will cause the upper (header) portion of the Grid to change its size. With that, the scrollbar will move away from the mouse position and causes the scrolling jump back and forth resulting in flickering.

Demo video of the issue: RadGrid FrozenColumns Flickering Header. The video can be found in the attachments as well.

 

Can the RadGrid generate columns from the client data source schema, it's painful having to manually declare the columns both in the RadGrid and the schema, again can something be done to make this control more user friendly?

The following steps create this issue:
1. Use html 4
2. Use telerik AJAX (For consistency)
3. Set a radgrid with some columns that reach beyond the extent of its element (such that it requires horizontal scrolling). Use at least four columns. One being the GridClientSelectColumn.
4. Have the following settings:
Control Settings: 
AllowPaging=true,AllowSorting=true,AllowFiltering=true,AllowFilteringByColumn=true,AllowMultiRowSelection=true

Control Events Used: NeedDataSource,OnItemDataBound
Client Settings:
EnablePostBackOnRowClick=false,Resizing AllowColumnResize=true, Selecting AllowRowSelect=true,UseClientSelectColumnOnly=false,Scrolling,AutoGenerateColumns=false,AllowScroll=true,UseStaticHeaders=true

Important note: Retain data on the server, rebind, and, on item databound, select the previously selected rows.

Set up a button to perform some action on the selected rows and have this action use AJAX such that this action depends on the currently selected rows in the RadGrid.

5. Scroll away from the selection checkboxes
6. Select some rows in your RadGrid
7. Perform your action with AJAX
If all was set up correctly, your grid should have been rebound with the previously selected rows re-selected. The RadGrid should still be scrolled to its previous position.
8. Perform your action with AJAX again. Here's the bug, the grid states that it has no selected items; however, the client shows that there are items selected in the UI.

This may be related to "RadGrid's last selected item index is not persisted correctly when two or more postbacks are triggered from external controls."

In GridTableView.cs, you provide a function
 protected virtual GridTableView CreateTableView() (Line 7828).
This function can be overloaded to return derived classes from GridTableView.

But, this is not overloadable completely. Because you create a GridTableView directly in protected void BuildDetailTablesFromDataSource() (Line 8808), too.
There you would have to call a virtual creator function, too.

This is necessary, because I have a lot of Trouble with your DataBind which I was able to fix with an overload. It is much to hard to make this bug visible for you, I really tried to do so already, but I had to fix this that way, because your GridTableView without my derivation fails in our szenario.

The call stack for that problem, I'd had to fix, is always like:
Exception of type 'System.Web.HttpUnhandledException' was thrown. ---> System.IndexOutOfRangeException: Cannot find column CheckSum.
                  at System.Data.DataTable.ParseSortString(String sortString)
                  at System.Data.DataView.set_Sort(String value)
                  at Telerik.Web.UI.GridEnumerableFromDataView.PerformTransformation()
                  at Telerik.Web.UI.GridEnumerableFromDataView.TransformEnumerable()
                  at Telerik.Web.UI.GridTableView.GetEnumerator(Boolean useDataSource, GridEnumerableBase resolvedDataSource, ArrayList dataKeysArray, Boolean shouldClearDataKeys)
                  at Telerik.Web.UI.GridTableView.CreateControlHierarchy(Boolean useDataSource)
                  at Telerik.Web.UI.GridTableView.CreateChildControls(IEnumerable dataSource, Boolean useDataSource)
                  at System.Web.UI.WebControls.CompositeDataBoundControl.PerformDataBinding(IEnumerable data)
                  at System.Web.UI.WebControls.DataBoundControl.OnDataSourceViewSelectCallback(IEnumerable data)
                  at Telerik.Web.UI.GridTableView.PerformSelect()
                  at Telerik.Web.UI.GridTableView.DataBind()
                  at Telerik.Web.UI.GridItemBuilder.BindDetailTable(GridDataItem parentItem, GridTableView cloned)
                  at Telerik.Web.UI.GridItemBuilder.BindDetailTables(GridDataItem parentItem, GridNestedViewItem detailItem)
                  at Telerik.Web.UI.GridItemBuilder.CreateItems(GridGroupingContext group)
                  at Telerik.Web.UI.GridTableView.CreateItems(IEnumerator enumerator, GridColumn[] columns, ControlCollection controls)
                  at Telerik.Web.UI.GridTableView.CreateControlHierarchy(Boolean useDataSource)
                  at Telerik.Web.UI.GridTableView.CreateChildControls(IEnumerable dataSource, Boolean useDataSource)
                  at System.Web.UI.WebControls.CompositeDataBoundControl.PerformDataBinding(IEnumerable data)
                  at System.Web.UI.WebControls.DataBoundControl.OnDataSourceViewSelectCallback(IEnumerable data)
                  at Telerik.Web.UI.GridTableView.PerformSelect()
                  at Telerik.Web.UI.GridTableView.DataBind()


In that, your DataTableView gets an invalid sort Expression string. Therefore, I overwrote DataBind.

But this is not possible in all cases, if you create GridViewTable() objects on your own.

Best regards

I have added Listview in Header template in Template column, its showing the data on the grid as expected. When I am exporting to Excel or PDF its not exporting the header. Header you see in headertemplate.jpg is not exporting to PDF

Thanks

I skipped the 3rd quarter 2016 update (2016.3.1027) for my copy of Telerik UI for ASP.NET.AJAX, since we were in code lock down at that time. 

 Later i installed the 4th quarter version (2016.4.1021.0)

Now, I still get a notice to install the previous version  (2016.3.1027) that I skipped.

That's annoying, and probably not possible. Right?

Is there anything we can do about this situation?

Thanks in advance
Tommy Heath
theath@teamenders.com

RadGrid filter command is not triggered for strings containing "and" word.

Video: https://www.screencast.com/t/j649UvPQ3z6

Steps to reproduce:
Filter by "SUNBAY AND LEONA A" in the following demo:
https://demos.telerik.com/aspnet-ajax/grid/examples/functionality/filtering/excel-like-filtering/defaultcs.aspx

Hello Sir

As I was workimg on Print functionality of RadGrid data.

While working on this functionality I found issue of "Print Preview" in chrome. Its working fine in IE and Firefox but in Chrome blank screen is coming with Print Preview Failed.

While searching on it I found "RadGrid Not Printing in Chrome" Post on telerik developer forum, I have created Telerik account and also reply to this post. 

Sir can you please help me regarding this issue. I look forward to hearing from you.

Regards

I'd like to request for an expansion of the RadGrid header rotation. Currently the rgRotateHeader style that can be applied rotates +90deg. 

I find this an uncomfartable reading direction and I am sure my users will complain about it. While attempting to set some custom style corrections tot rotate -90deg with the help of Telerik support I found that the end result was not good enough to bring into production: wrapping direction was wrong and too many manual corrections had to be made to make the header fit.

See attached screenshots where I made an attempt to rotate the header to override the rgRotateHeader style and the undesired wrapping results and the inconvenient required corrections in transform-origin. Maybe I could have made this work, but this is where I stopped my effort as it cost me too many time. 

I would very much like this a standard feature of the Radgrid. Also -45deg would be very nice to have!

Rather than simply using the drag and drop method to reorder rows within a rad grid, allow for the built in functionality where you can simply move rows up and down client side so that the user can sort the data by rows rather than columns.

Feature request came after a customer had a grid of data that was sorted in a sorted order but they wanted the ability to not only select what rows they wanted which we coded using the checkbox column, but they then wanted to be able to sort the rows they had selected as the selected rows were being exported to a PDF or Excel so wanted them in a certain order.

Hi,

I am getting the below issue on button click.Its working fine in all browsers ,but not in Edge.Please help.

Microsoft Edge SCRIPT65535: Argument not optional

It is saying grid is not available.

Reference: http://www.telerik.com/forums/radgrid-column-header-and-data-item-alignment-problem

This has apparently been an issue with RadGrid for a long time, according to the above thread. I have done a significant amount of testing to isolate this bug and have attached a self-contained solution in VB.NET 4.0 (VS 2010).

I removed all the surplus RadGrid properties I could in order to simplify the debugging process on your end and included my notes in the code and on the test page. There is indeed some peculiar behavior with the control.

Regards,
Matthew

You have very useful property - EnableTimeIndependentFiltering for GridDateTimeColumn. But I need to use ItemTemplate and EditItemTemplate and this future missing in GridTemplateColumn. I try to use FilterTemplate with RadDatePicker, but then I have only "equal to" option for filtering. I don't want this. So my suggestion to you is to develop EnableTimeIndependentFiltering for the cases when user have to use GridTemplateColumn with DataType=System.DateTime.

Hi Telerik,

The suggestion here is to be able to Copy and Paste (Ctrl-C and Ctrl-V) values from one cell in a column to other selected cells in the same column, when in Batch EditMode.  I currently have this working through javascript functions but maybe going too deep in the RadGrid control to get things to work and the internals of the control sometimes change from one version to another. Thus it might be better to embed this functionality in the control.

In order to better explain I included an attached word document describing what I am talking about with screenshots.

Thanks for you consideration, Jim

Currently it's not possible to overrule number of pages to be shown in page navigation, if EntityDataSource is used. There is the problem that always all rows from data source get queried, when GridGroupByExpression has been defined for RadGrid - and this is really a problem, if data source has hundreds of thousands of records (as in our case). The performance is really bad.

To overcome this issue I would like to control myself, which data gets returned by adapting query in OnQueryCreated event of EntityDataSource, basically by "injecting" skip / take expression to entity query. I am responsible myself about sorting and grouping should be done on page level only (so there is no need to query always ALL data).

In same event I want to set VirtualItemCount, which should control number of pages to be shown in page navigation (in combination with AllowCustomPaging). But unfortunately this setting is not taken into account by RadGrid for displaying pages in page navigation.

Is it possible to overrule this behavior that VirtualitemCount is always taken into account when AllowCustomPaging has been enabled? I would like to control myself.

Thanks,
Roger

Kendo ui Grid is taking more than 10 secs to load Data.It contains approx 16000 records.I am using Ajax call to get data from Database.Please let me know how to reduce the load time.In ASP grid it is taking not more than 3 secs to load the data of 16000 records.

We are using RadGrid in SharePoint Visual Webpart with FilterType="CheckList". What we need is to be able to filter the checklist further with auto filter textbox.
1. When the filter icon is clicked, it fills with all available options (say 100 + records).
2. User enters few characters (say first 4) in the textbox and the list gets filtered with the all options starting with... (resulting in 8 records)
3. User then selects the required option for the final filter.

Please find attached image for clarification.

The new RadGrid Filtering (Checkbox list) is great, but...
1) it will be great if, upon RadGrid Databinding, the filter gets a list of unique value for that column: that is, most of the time, how we populate the checklist.
2) Today, there's one Event "OnfilterCheckListItemsRequested" that is fired whenever a listbox needs to gets its list. Then you have to put in the event Handler the logic to find out which column called, and give back the specific column checkbox filtering list.
IMO, each column should have a distinct EventHandler for this. 
And BTW, if in the same radgrid you mix the new filter and the old ones, the old ones get an empty box instead of the default filters with option "FilterType=checklist"
Even if you choose filterType=Combined, there's a difference with the standard 'Filter way': instead of having directly the filters, you got to pass thru a single menu "filter options" to find the filter menu.