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: 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
Pending Review
Last Updated: 06 Dec 2016 05:12 by Mirang
Created by: Mirang
Comments: 3
Category: Grid
Type: Feature Request
5
Hi,

Our Accessibility partner while evaluating our product for 508 compliance we got one report saying RadGrid control is not accessible. We do have enablearia attribute on the radgrid and is emitting the aria-attributes as mentioned in your demo. 
http://demos.telerik.com/aspnet-ajax/grid/examples/accessibility-and-internationalization/wai-aria-support/defaultcs.aspx

As per them : "So it does not alert the user that arrow keys may be used to navigate it".
I have attached a snippet of their report regarding radgrid accessibility. Can you please let me know if anything is missing.
Thanks and best regards,
Mirang
Pending Review
Last Updated: 30 May 2018 08:28 by Arnstein
Created by: Arnstein
Comments: 4
Category: Grid
Type: Feature Request
4
In RadGrid, we can use the ClientSettings.Scrolling.UseStaticHeaders property to have a fixed header when scrolling the grid. This requires a fixed height of the grid. However, what if we do not want a fixed height of the grid, but rather want the grid to flow down the page, using as much space as necessary do display its records. In such a scenario, the grid header will disappear when we scroll down the page.
I have implemented a kind of fix for this in one of my projects. Instead of trying to explain how it works, I have prepared an example. You can find it here:
http://www.ifag.no/RadGridHeader.aspx
Maybe some of you can suggest even better solutions to the scenario I have described. Comments are welcome!
Pending Review
Last Updated: 13 May 2015 13:42 by Polly
Created by: Polly
Comments: 0
Category: Grid
Type: Feature Request
4
Please add a setting for the Grid in batch edit mode to enable prompting to save changes.  The prompt should occur when navigating away from the page, when paging, when filtering, when refreshing, or any other action that would cause loss of changes without a save.
For details on how I implemented this manually, please see ticket 933229.
Pending Review
Last Updated: 27 Sep 2016 23:10 by Shamalee
This feature request is regarding the ExportToExcel button in Radgrid.

ExportToExcel button in Radgrid adds an extra row in the exported excel sheet. This is due to the presence of Filtering items.

Export to Excel code in radgrid:

<ExportSettings ExportOnlyData="true" IgnorePaging="true" Excel-Format="Biff" OpenInNewWindow="True">
<Excel Format="Biff" AutoFitImages="True"></Excel>
        </ExportSettings>
<CommandItemSettings ShowAddNewRecordButton="False" ShowRefreshButton="False" ShowExportToExcelButton="True" ExportToExcelText="Export Grid To Excel"/>

The above code produces an extra row.

I know there is a fix by disabling the Filtering items in the grid in OnItemCommand event. So I used that. The code is given below:

protected void RadGrid1_ItemCommand(object sender, GridCommandEventArgs e)
        {
            if (e.CommandName == RadGrid.ExportToExcelCommandName)
            {
                ReviewByCollegeGrid.AllowFilteringByColumn = false;
                ReviewByCollegeGrid.Rebind();
                ReviewByCollegeGrid.ExportSettings.Excel.Format = GridExcelExportFormat.Biff;
                ReviewByCollegeGrid.ExportSettings.IgnorePaging = true;
                ReviewByCollegeGrid.ExportSettings.ExportOnlyData = true;
                ReviewByCollegeGrid.ExportSettings.OpenInNewWindow = true;
            }
        }
But it is a lot of work when you have to do it for all the web pages in your application. Please provide a feature which will help to solve this issue in an easier way.
Pending Review
Last Updated: 05 Feb 2018 14:17 by Vasssek
Created by: Vasssek
Comments: 0
Category: Grid
Type: Feature Request
4
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: 06 Apr 2018 18:06 by Grant
ADMIN
Created by: Marin Bratanov
Comments: 1
Category: Grid
Type: Feature Request
4
The behavior described in the following KB should be fixed https://www.telerik.com/support/kb/aspnet-ajax/grid/details/horizontal-scroll-speed-is-slow-with-static-headers

In the meantime, you can use the workarounds from the article, or, if it fits your scenario, move to scrolling horizontally through frozen columns via the Prev/Next buttons the grid can provide. You can find an example of that in the second grid (Navigate through the columns by clicking on the Prev/Next buttons) in the following demo: https://demos.telerik.com/aspnet-ajax/grid/examples/columns-rows/columns/frozen-columns/defaultcs.aspx
Pending Review
Last Updated: 30 Apr 2019 10:06 by ADMIN
If anchor links of GridButtonColumn do not define a text links are still rendered and screen readers read their href attribute. Anchor links with no text could define an attribute area-hidden="true".
Pending Review
Last Updated: 02 Nov 2017 15:09 by David
Created by: Rick
Comments: 1
Category: Grid
Type: Feature Request
3
It would be useful for the header cell for Sort-able columns to display an indication that the column can be sorted.  This is useful to users when not all columns are sort-able, so they know which header cells will trigger resorting.

Elsewhere in our application, we use a double headed arrow icon to indicate use can click on header to resort on the column; the app displays the up or down arrow indicating when sort order is active.

Suggest adding a third Sort-Image-URL attribute to specify an image to use when column is not sorted ascending or descending.

At present, best I can do declaratively (w/o custom coding) is the set one of the HeaderStyle-Font properties (for example the HeaderStyle-Font-Underline) to provide a visual indication that column is sort-able.
Pending Review
Last Updated: 03 Oct 2016 08:03 by Support
Created by: Imported User
Comments: 2
Category: Grid
Type: Feature Request
3
Please add support for tags in exported PDF documents. We need these tags for accessibility purposes. Currently, when we export a PDF from a RadGrid, it is created without any tag structure, which can make it difficult for a screen reader to process correctly.
Pending Review
Last Updated: 23 Oct 2015 13:01 by David
Applies to all model-bound controls; Tree-list, etc..

Current data-annotation support includes validation.

Please include handling of the following attributes
- Display Name defaults for databound columns
- Text boxes and labels width based on max-length
- Display attributes
- auto-generation of drop-downs for enum datatypes and foreign keys
- readonly based on editable attribute


Pending Review
Last Updated: 13 Nov 2015 15:18 by David
Created by: David
Comments: 0
Category: Grid
Type: Feature Request
2
Current RadGrid (Q3 2015) does supports model binding of master/detail records.

Request the functionality to set ItemType on the detail gridview and pass the master's datakey as the id for the detail select method.

Or, alternatively, if the model has a virtual IQuerable binding, set the detail view's datasource to the models virtual entity

For example, a model with a one to many relationship to the color options for a car:
Model Cars()
{ string name
int colorRange
virtual colorOptionsModel colorOptions
}
Model colorOptionsModel
{
int colorRange
 string colorName;
} 

In the RadGrid:
<mastertable DataKeyName = "colorRange">
<DetailView datasource="Item.colorOptions">
Pending Review
Last Updated: 15 May 2015 12:01 by Minculescu
Created by: Minculescu
Comments: 0
Category: Grid
Type: Feature Request
2
It would be nice to have a "remove" button on the edit template, where the user could delete an image that was uploaded and saved on the database before. 
Pending Review
Last Updated: 01 Sep 2015 13:15 by 小章
Created by: 小章
Comments: 0
Category: Grid
Type: Feature Request
2
Because linq to entities no support DateTime.Parse() , So can you DateTime.Parse() to DateTime method

http://www.telerik.com/forums/how-override-filter-pattern-from-radgrid
Pending Review
Last Updated: 19 Oct 2017 15:23 by Cameron
Created by: Cameron
Comments: 0
Category: Grid
Type: Feature Request
2
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: 21 Jun 2017 18:33 by moegal
The FooterAggregateFormatString functionality of the Grid does not affect the Aggregates values format in a client-bound Grid.

Code to reproduce:
            <telerik:RadGrid RenderMode="Lightweight" ID="RadGrid1" runat="server" ClientDataSourceID="RadClientDataSource1" AllowPaging="true" AllowSorting="true" AllowFilteringByColumn="true" ShowFooter="true">
                <MasterTableView ClientDataKeyNames="CustomerID" EditMode="Batch" CommandItemDisplay="Top" BatchEditingSettings-HighlightDeletedRows="true">
                    <Columns>
                        <telerik:GridBoundColumn DataField="CustomerID" HeaderText="Customer ID"  Aggregate="Count" FooterAggregateFormatString="No currency sign here: {0:C}">
                        </telerik:GridBoundColumn>
                        <telerik:GridBoundColumn DataField="CompanyName" HeaderText="Company Name" ColumnEditorID="GridTextBoxEditor">
                        </telerik:GridBoundColumn>
                        <telerik:GridBoundColumn DataField="ContactName" HeaderText="Contact Name" ColumnEditorID="GridTextBoxEditor">
                        </telerik:GridBoundColumn>
                        <telerik:GridBoundColumn DataField="ContactTitle" HeaderText="Contact Title" ColumnEditorID="GridTextBoxEditor">
                        </telerik:GridBoundColumn>
                        <telerik:GridClientDeleteColumn HeaderText="Delete">
                            <HeaderStyle Width="70px" />
                        </telerik:GridClientDeleteColumn>
                    </Columns>
                </MasterTableView>
                <ClientSettings>
                    <ClientEvents OnUserAction="UserAction" />
                </ClientSettings>
            </telerik:RadGrid>
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: 04 Mar 2019 15:22 by Rodney
There should be RadGrid.ExportSettings.WorksheetName property to name a Sheet inside the Excel file, instead of having it named after the RadGrid.ExportSettings.FileName property as well as to avoid additional coding to Work around this.
Pending Review
Last Updated: 01 Sep 2017 19:20 by Erich
Created by: Erich
Comments: 0
Category: Grid
Type: Feature Request
2
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!!!
1 2 3