I think it would be a great addition to the grid control if there was an attribute that you could apply to the columns called "SortNullsLast" or something along those lines. This attribute would modify the grid's sorting functionality and only apply the ascending or descending sort to non-null values.

Currently when you sort ascending, null values are sorted to the top of the grid. This new attribute would allow the non-null values to show up at the top in ascending order.

An example of why this would be useful is having a grid that tracks an optional requested completion date of a task. You would want to be able to sort the grid so that the earliest date shows first in the grid. Right now, any records that don't have this optional date would show first, which doesn't make sense.

Auto-Fit column width when exporting to excel using Format="Xlsx"

 I'd really like to have the columns automatically adjust to fit the width of the content.

A workaround is to take the header border color and set it to all rows 

- Default skin
           .RadGrid_Default .rgRow > td,
            .RadGrid_Default .rgAltRow > td {
                border-left-color: rgb(130, 130, 130);
            }


- BlackMetroTouch skin

            .RadGrid_BlackMetroTouch .rgRow > td,
            .RadGrid_BlackMetroTouch .rgAltRow > td {
                border-left-color: rgb(51, 51, 51);
            }

            .RadGrid_BlackMetroTouch .rgRow > td,
            .RadGrid_BlackMetroTouch .rgAltRow > td {
                border-bottom-width: 0px; /*remove extra space between rows that becomes visible when you put on borders for alt rows*/
            }


- WebBlue skin

            .RadGrid_WebBlue .rgRow > td,
            .RadGrid_WebBlue .rgAltRow > td
            {
                border-left-color: rgb(69, 95, 119);
            }

As shown in the attached screen, please keep the column headers Fixed or Visible so they are still visible when users scroll down to see the other data, for both RadGrid and PivotGrid:

It seems the element somehow considmes the scrolling/touch action and the grid does not scroll unless you hit the gap where the custom element does not reach.

A workaround is to enforce overflow: auto to the scrollable element of the grid. A sample is attached below.

        div.rgDataDiv {
            overflow: auto !important;
        }

Provide a simple interface to showcase exactly in what order the columns have been sorted in (ex. 1, 2, 3, etc in column header) - matching the functionality in Kendo UI Grid:

http://demos.telerik.com/kendo-ui/grid/sorting

I would like to suggest that the Buttons in the RadGrid allow databinding to the CommandName and CommandArgument fields.  And pretty much all the buttons or anything that triggers an ItemCommand event that allow a CommandName and CommandArgument have their properties to be databound and accessible in the code behind.

Thanks!!!

The Filtering context menu is not positioned properly when there is not enough height. It is positioned depending on the top border of the window, making the filters not accessible.

Screencast: https://www.screencast.com/t/4dQEAczF9c2

Steps to reproduce:
1. Open http://demos.telerik.com/aspnet-ajax/grid/examples/functionality/filtering/excel-like-filtering/defaultcs.aspx
2. Resize the browser so the last elements of the Grid are not visible
3. Open the Filtering context menu

Result: It is shown with too big negative top margin

If a column does not have width set, it will not populate the Columns collection of the ExportInfrastructure in the BiffExprorting event http://docs.telerik.com/devtools/aspnet-ajax/controls/grid/functionality/exporting/export-formats/excel-biff-export

To be able to loop through all columns, you need to have width specified for them.

This change has been introduced in Q3 2014

If you cannot do this for the standard grid rendering when defining columns, you can use the Grid.PreRender event to loop all columns and set some width for them:


VB

    Protected Sub RadGrid1_PreRender(ByVal sender As Object, ByVal e As System.EventArgs) Handles RadGrid1.PreRender

        'workaround for BiffExporting event Columns collection not being populated if the column does not have width set
        Dim Grid As RadGrid = DirectCast(sender, RadGrid)
        If (Grid.IsExporting) Then
            For index = 0 To Grid.MasterTableView.Columns.Count - 1
                Grid.MasterTableView.Columns(index).HeaderStyle.Width = 100
            Next
        End If
    End Sub


C#

protected void RadGrid1_PreRender(object sender, System.EventArgs e)
{
	//workaround for BiffExporting event Columns collection not being populated if the column does not have width set
	RadGrid Grid = (RadGrid)sender;
	if ((Grid.IsExporting)) {
		for (index = 0; index <= Grid.MasterTableView.Columns.Count - 1; index++) {
			Grid.MasterTableView.Columns(index).HeaderStyle.Width = 100;
		}
	}
}

For Bug Report :

Note: We are using MM/dd/yyyy as Internal Date format to prevent issue while inserting or updating value.

Steps to reproduce:
When we use dd-MM-yyyy and yyyy-dd-MM Date DisplayFformat for RadDatePicker/RadDateTimePicker control as well as view mode in Radgrid Batch Edit mode it's render behaviour is inconsistent
1. When dd is less than or equal to 12 then while rendering in edit mode Month and Date is interchanged
2. When dd is greather than 12 then while rendering in edit mode Month and Date is rendered correctly.

A valid SQL statement should look like

SELECT * FROM Products WHERE ([Discontinued] = 1)

or

SELECT * FROM Products WHERE ([Discontinued] = 'True')

but RadGrid provides something like

([Discontinued] = True)

in the MasterTableView.FilterExpression property.

By default RadGrid filters the data on its own after retrieving the entire data set form the data source, and the filtering operation works like that.
If you will be using the filter expression provided by the grid in a custom data source operation you may need to tweak the string first.
Note that changing this may result in a breaking change if you are already using the current syntax.

Workaround: https://www.telerik.com/support/kb/aspnet-ajax/grid/details/get-sql-compliant-filterexpressions-from-radgrid

You would get something like

(([createddate] >= '01/08/2017,00:00:00') AND ([createddate] <= '14/08/2017,23:59:59'))

while you should get something like

(([createddate] >= '01/08/2017 00:00:00') AND ([createddate] <= '14/08/2017 23:59:59'))

so that the SQL syntax is valid.

RadGrid, does not send the FilterExpression to the SqlDataSource, however. It executes the SELECT statement and then filters the resulting data on its own. This works fine.

If you will be performing operations yourself, you could use a string operation before passing the filter expression. For example:

protected void RadGrid1_NeedDataSource(object sender, GridNeedDataSourceEventArgs e)
{
	if (!string.IsNullOrEmpty(this.RadGrid1.MasterTableView.FilterExpression))
	{
		if (this.RadGrid1.MasterTableView.FilterExpression.Contains("createddate"))
		{
			this.RadGrid1.MasterTableView.FilterExpression = this.RadGrid1.MasterTableView.FilterExpression.Replace(",", " ");
		}
		DataView dv =GetData("select * from [myTable] where ", this.RadGrid1.MasterTableView.FilterExpression);
                //where you would need to have something like (([createddate] >= '01/08/2017 00:00:00') AND ([createddate] <= '14/08/2017 23:59:59'))
		this.RadGrid1.DataSource = dv;
	}
}

Note that implementing such a change may break existing code that relies on the current syntax that contains the comma.

If the selection mode of the Grid is different than row selection, no cell of the detailed grid gets selected. The bug is introduced with version 2016 R3 SP1

Steps to reproduce:
1. Run the following demo locally  http://demos.telerik.com/aspnet-ajax/grid/examples/hierarchy/declarative-relations/defaultcs.aspx

2. and add this configuration:
       <telerik:RadGrid ...>
            <ClientSettings>
                <Selecting CellSelectionMode="SingleCell" />
            </ClientSettings>

Simply add a Column to RadGrid in the GridColumn Collection Editor of the Configuration wizard. You will note that a value for FilterControlAltText is autopopulated. When you hit Ok, that value is written in the column definition, in markup. If you clear that text in the editor, then, in markup you will find the value FilterControlAltText ="". This is useless clutter, which you should manually remove from the markup. The editor/designer should remove the property entry from markup if you clear the FilterControlAltText from the PropertyGrid in the GridColumn Collection Editor.

https://www.screencast.com/t/4BCjMdLqQS5

A workaround is to access the column and replace the text of the cell with a <label> control. Examples are attached below

The manually entered value of RadDateTimePicker is replaced with the original one in Batch Edid mode in iPad.

To reproduce this incorrect behavior add a new 

<telerik:GridDateTimeColumn HeaderText="Start Date" UniqueName="StartDate" DataField="StartDate" DataFormatString="{0:MM/dd/yyyy}">
            </telerik:GridDateTimeColumn>

column in the Batch Edit demos of RadGrid and test under iPad. 

Tap over RadTextBox, enter some new date and press Go/tap out and you'll see the problem.

Hi

Could we have an "export to excel functionality" in "rad grid" to 
a "predefined formatted excel file".
So my excel exported file wont loose the formatting.
Thanks