Pending Review
Last Updated: 05 Feb 2018 14:17 by Vasssek
Created by: Vasssek
Comments: 0
Category: Grid
Type: Feature Request
3
How is it possible to autofit / autosize a giving column (or all columns) when exporting the contents from RadGrid to xlsx using ExportStructure?

The only option available is Width with a defined value. I was unable to find an autofit / autosize function.

And also add AutoFilter feature...

Please consider to add this features :-)
Pending Review
Last Updated: 14 Dec 2017 21:55 by Joel
Created by: Joel
Comments: 0
Category: Grid
Type: Feature Request
0
I have a RadGrid with around 150 columns and a few hundred rows. Currently, I'm looping over them and setting their widths with the resizeColumn function. Unfortunately, it's triggering a recalculation of the layout every time I call this function, so the total page load time can be in the minutes.

Oddly, much of the time was spent on the line:
e.style.width=e.offsetWidth-d+"px";

Chrome's developer tools helpfully pointed me at Forced Reflow. Apparently, when a width is set, initially no extra work is done. When another width is requested, the previous width may have changed it, so the whole layout gets recalculated.

The feature I'd like to request is a function to set column widths in bulk (accepting anything like an array or a dictionary would be fine) that doesn't trigger this recalculation mid-function.
Pending Review
Last Updated: 07 Dec 2017 12:23 by avi
ADMIN
Created by: Marin Bratanov
Comments: 1
Category: Grid
Type: Feature Request
0
At the moment, RTL support for excel like filtering is not implemented. It displays the following issues

    - menu position is wrong (tends to show up on the column to the left)
    - controls alignment inside the menu is wrong (ltr)

You can find attached a sample and screenshots with the current behavior
Completed
Last Updated: 03 Sep 2019 15:56 by ADMIN
Release R3 2019
For keyboard users who don't have a specific Context Menu key (see  https://en.wikipedia.org/wiki/Menu_key), they typically need to use the Windows standard SHIFT+F10 hotkey to trigger a contextmenu event.

For example:

1.	In IE, load http://demos.telerik.com/aspnet-ajax/grid/examples/columns-rows/columns/context-menu/defaultcs.aspx
2.	Tab to a column header link
3.	Press SHIFT+F10 (standard Windows/IE hotkey to open context menu)
4.	Notice the context menu displays, however, the focus is really on the IE menubar. IE supports F10 to open the menubar, but is also seeing SHIFT+F10 too.

Or
1.	In FireFox, load http://demos.telerik.com/aspnet-ajax/grid/examples/columns-rows/columns/context-menu/defaultcs.aspx
2.	Tab to a column header link
3.	Press SHIFT+F10 (standard Windows/IE hotkey to open context menu) then press down arrow
4.	Notice the context menu displays, however, the focus is really on FireFox's application system menu in the upper left.

Chrome does not have this issue - it opens the grid context menu only.
We need IE and FireFox to also only open the grid's context menu, and not trigger default browser behavior.

According to https://yuilibrary.com/yui/docs/event/contextmenu.html, it is possible to correct this behavior by calling event.preventDefault() when SHIFT+F10 is pressed, but then trigger a synthetic contextmenu event anyway.

As a workaround, we know users can press Escape to close the browser's default menu and bring focus back into the HTML document (and thus the grid's context menu), but this throws off the user experience and becomes a training issue.
Pending Review
Last Updated: 30 Oct 2017 11:57 by ADMIN
In some cases, inside the Grid table, the tfoot element is rendered before the tbody element. This causes some readers to read the footer before the body. 

A possible workaround is moving the tfoot after the tbody in the OnGridCreated event:

function OnGridCreated(sender, args) {
    var $ = $telerik.$;
    $('tfoot').each(function (index, item) {
        debugger
        var $item = $(item);
        var $next = $item.next();
        if ($next[0]) {
            if ($next[0].tagName.toLowerCase() == "tbody") {
                debugger
                $item.insertAfter($next);
            }
        }
    });
}
Pending Review
Last Updated: 19 Oct 2017 15:23 by Cameron
Created by: Cameron
Comments: 0
Category: Grid
Type: Feature Request
1
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.
Pending Review
Last Updated: 19 Oct 2017 14:19 by TRANSEPT
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.
Pending Review
Last Updated: 24 Nov 2017 10:13 by Arnstein
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:

Pending Review
Last Updated: 15 Sep 2017 16:26 by Shane
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
Pending Review
Last Updated: 01 Sep 2017 19:20 by Erich
Created by: Erich
Comments: 0
Category: Grid
Type: Feature Request
1
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!!!
Pending Review
Last Updated: 08 Nov 2018 20:52 by Attila Antal
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
Pending Review
Last Updated: 24 Aug 2017 12:59 by ADMIN
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.
Approved
Last Updated: 08 Jun 2017 09:25 by ADMIN
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.
Pending Review
Last Updated: 26 Apr 2017 17:43 by Rajendra
Created by: Rajendra
Comments: 0
Category: Grid
Type: Feature Request
5
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
Approved
Last Updated: 17 Oct 2017 14:30 by ADMIN
To overcome this issue you can do the following:

- For anchor links (a) implement onclick event with window.location.
- For submit buttons set UseSubmitBehavior property to false.
Approved
Last Updated: 24 Mar 2017 14:50 by ADMIN
Workaround for the NextPrevAndNumeric mode is to set the AssociatedControlID of the label

	protected void RadGrid1_ItemDataBound(object sender, GridItemEventArgs e)
	{
		if (e.Item is GridPagerItem)
		{
			GridPagerItem pager = e.Item as GridPagerItem;
			Label lbl = pager.FindControl("ChangePageSizeLabel") as Label;
			Panel pnl = lbl.Parent as Panel;
			RadComboBox combo = pnl.FindControl("PageSizeComboBox") as RadComboBox;
			lbl.AssociatedControlID = combo.ID;
		}
	}

	<telerik:RadGrid RenderMode="Lightweight" ID="RadGrid1" runat="server" DataSourceID="SqlDataSource1" AllowSorting="True"
						AllowPaging="True" GridLines="None" Width="100%" OnItemDataBound="RadGrid1_ItemDataBound">
		<PagerStyle Mode="NextPrevAndNumeric" Position="TopAndBottom" PageSizeControlType="RadComboBox"></PagerStyle>
	</telerik:RadGrid>
			
	<asp:SqlDataSource ID="SqlDataSource1" ConnectionString="<%$ ConnectionStrings:NorthwindConnectionString %>"
						ProviderName="System.Data.SqlClient" SelectCommand="SELECT CustomerID, CompanyName, ContactName, ContactTitle, Address, PostalCode FROM Customers"
						runat="server"></asp:SqlDataSource>
Pending Review
Last Updated: 23 Feb 2017 19:31 by cw
Created by: cw
Comments: 0
Category: Grid
Type: Feature Request
1
Would be nice to have RadGrid offer the feature to have options to Merge Cells with same contents so the report/grid won't be so busy. Users typically expect this kind of look and feel. 

Example & code included:
    http://www.marss.co.ua/2010/01/how-to-merge-cells-with-equal-values-in.html

This ticket discussed it also: 1091013

Others in forums asked about this also in the past since about 2009, if we google on: telerik grid asp.net merge cell. .
http://www.telerik.com/forums/problems-with-merge-row-in-radgrid

http://www.telerik.com/forums/merge-cells-by-column

http://www.telerik.com/forums/merge-rows

Then I found this link among the results from google. Though, I wish there are RowMerge and ColumnMerge properties in RadGrid for us to turn it on/off. That will be wonderful.

http://www.telerik.com/support/kb/winforms/details/radgridview-merge-celss

This example is also from the following link from the same google search result, the first link.

http://www.telerik.com/forums/merge-cell-in-radgrid

Thanks.

Pending Review
Last Updated: 10 Feb 2017 15:15 by Doug
radgrid exporttoexcel and all exports (word, pdf, csv, excel) should be able to export to file on server without the browser also sending the file to the client.
Pending Review
Last Updated: 11 Jan 2017 14:15 by Albert Shenker
When using keyboard navigation, the ESC key currently does some things properly (like closing out of batch editing forms). However, it does not prevent the firing of certain update events (like BatchEditCellValueChanged). The ESC key should act like a "cancel" key, so no update events should fire when it is pressed.
Pending Review
Last Updated: 11 Jan 2017 14:12 by Albert Shenker
Created by: Albert Shenker
Comments: 0
Category: Grid
Type: Feature Request
1
The client-side KeyPress event is falling out of favor and the KeyDown even is being used more. Please implement an OnKeyDown event for the Grid, just like you currently have an OnKeyPress event