Approved
Last Updated: 28 Aug 2017 11:03 by ADMIN
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;
		}
	}
}
Approved
Last Updated: 01 Sep 2017 12:09 by ADMIN
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
Approved
Last Updated: 03 Nov 2014 09:51 by Vince
The RadGrid OnDataBindingFailed event does not fire when WCF/WebService returns an IIS 500 Errror page.

It DOES, however, fire when IIS returns a proper 500 error JSON response.

In my case, the former was happening because my ASP.NET WCF services were incorrectly configured and thus throwing a standard IIS 500 error page. RadGrid should recognize the IIS 500 page as failure and spawned a OnDataBindingFailed  event.

NOTE: For example, RadScheduler *does* correctly interpret the IIS 500 page as a failure (RE: OnClientRequestFailed).
Approved
Last Updated: 03 Nov 2014 10:12 by Manish
Created by: Manish
Comments: 0
Category: Grid
Type: Bug Report
0
We have telerik Radgrid on the pages in our application. When viewed in the windows phone 8 browser the horizontal touch scroll does not work. Moreover the color of the scrollbar is almost invisible. Requests anyone to please suggest how to overcome this issue. we tried providing a skin as "Balck Metro touch" and also tried enabling "embedded skins" but none of this works.
Approved
Last Updated: 15 Oct 2013 11:31 by ADMIN
RadGrid throws a "Failed to load viewstate" exception in a specific setup with two level hierarchy and DateTimeColumns. 

Steps to reproduce:
1. Expand an item
2. Click on "Add new record button" in the expanded detail table view
3. Click "Cancel"
4. Click on"Add new record" this time on the master table view

Code to reproduce:

<telerik:RadGrid ID="rgComments"
    runat="server"
    AllowPaging="True"
    AutoGenerateColumns="false"
    DataSourceID="dsSpell">
    <MasterTableView Width="100%"
        CommandItemDisplay="Top" DataKeyNames="OrderID">
        <DetailTables>
            <telerik:GridTableView DataKeyNames="OrderID" DataSourceID="dsComment" Width="100%"
                runat="server" CommandItemDisplay="Top">
                <ParentTableRelation>
                    <telerik:GridRelationFields DetailKeyField="OrderID" MasterKeyField="OrderID"></telerik:GridRelationFields>
                </ParentTableRelation>
                <Columns>
                    <telerik:GridDateTimeColumn DataField="OrderDate" PickerType="DateTimePicker">
                    </telerik:GridDateTimeColumn>
                </Columns>
            </telerik:GridTableView>
        </DetailTables>
        <Columns>
            <telerik:GridDateTimeColumn DataField="OrderID" />
        </Columns>
    </MasterTableView>
</telerik:RadGrid>
<br />
<asp:SqlDataSource runat="server" ID="dsComment" ConnectionString="<%$ ConnectionStrings:NorthwindConnectionString %>"
    SelectCommand="SELECT [OrderID], [OrderDate] FROM [Orders]"></asp:SqlDataSource>
<asp:SqlDataSource runat="server" ID="dsSpell" ConnectionString="<%$ ConnectionStrings:NorthwindConnectionString %>"
    SelectCommand="SELECT [OrderID], [OrderDate] FROM [Orders]"></asp:SqlDataSource>
Approved
Last Updated: 07 Mar 2019 12:03 by ADMIN

When virtualization is enabled for RadGrid, NeedDataSource is called at every Post back with RebindReason = ExplicitRebind, regardless of the event target.

Steps to reproduce:

Use the following Code snippets for the runnable sample and debug the NeedDataSource event while doing post backs using other controls. For instance, you can use the RadButton1 from these snippets to make a standard Post Back.

Markup

        <telerik:RadAjaxManager ID="RadAjaxManager1" runat="server">
        </telerik:RadAjaxManager>

        <telerik:RadAjaxLoadingPanel ID="RadAjaxLoadingPanel1" runat="server" Skin="Default"></telerik:RadAjaxLoadingPanel>
        
        <telerik:RadButton runat="server" ID="RadButton1" Text="Postback" AutoPostBack="true" />

        <telerik:RadGrid ID="RadGrid1" runat="server" AllowPaging="false" Width="800px" OnNeedDataSource="RadGrid1_NeedDataSource">
            <MasterTableView AutoGenerateColumns="true" DataKeyNames="OrderID">
            </MasterTableView>
            <ClientSettings>
                <Scrolling AllowScroll="true" />
                <Virtualization EnableVirtualization="true" InitiallyCachedItemsCount="500" ItemsPerView="200" RetrievedItemsPerRequest="200" LoadingPanelID="RadAjaxLoadingPanel1" />
            </ClientSettings>
        </telerik:RadGrid>


C# 

    protected void RadGrid1_NeedDataSource(object sender, GridNeedDataSourceEventArgs e)
    {
        RadGrid1.DataSource = OrdersTable();
    }

    private DataTable OrdersTable()
    {
        DataTable dt = new DataTable();

        dt.Columns.Add(new DataColumn("OrderID", typeof(int)));
        dt.Columns.Add(new DataColumn("OrderDate", typeof(DateTime)));
        dt.Columns.Add(new DataColumn("Freight", typeof(decimal)));
        dt.Columns.Add(new DataColumn("ShipName", typeof(string)));
        dt.Columns.Add(new DataColumn("ShipCountry", typeof(string)));

        dt.PrimaryKey = new DataColumn[] { dt.Columns["OrderID"] };

        for (int i = 0; i < 10000; i++)
        {
            int index = i + 1;

            DataRow row = dt.NewRow();

            row["OrderID"] = index;
            row["OrderDate"] = new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day, 0, 0, 0).AddHours(index);
            row["Freight"] = index * 0.1 + index * 0.01;
            row["ShipName"] = "Name " + index;
            row["ShipCountry"] = "Country " + index;

            dt.Rows.Add(row);
        }

        return dt;
    }

Approved
Last Updated: 02 Jan 2020 16:43 by ADMIN
Created by: Grant
Comments: 1
Category: Grid
Type: Bug Report
0
If exporting a sorted RadGrid to  Excel XLSX a white space is prepended to the header text in the output file
Approved
Last Updated: 02 Jan 2020 16:43 by ADMIN
Created by: David Hassan
Comments: 1
Category: Grid
Type: Bug Report
0

To replicate the problem:

  1. Create RadGrid and bind it a datasource
  2. Set ClientSettings - Selecting - AllowRowSelect to true
  3. Set ClientSettings - EnablePostBackOnRowClick to true
  4. Add a GridEditCommandColumn or a ButtonColumn with Edit/Save/Cancel CommandNames
  5. Enable AJAX for the Grid
  6. Run the application in FireFox

Clicking on the Edit button fires the RowClick event of the Grid instead of Edit/Save/Cancel.

Approved
Last Updated: 01 Aug 2019 18:12 by ADMIN
When you have both a Detail Item Template and a Detail Table inside a Grid and then when you show a hidden column using the context menu it only shows for the first row and the grid doesn't display properly.  It also throws the javasecript error "Unable to get property '_getVisibleColumnsCount' of undefined or null reference".
Approved
Last Updated: 02 Jan 2020 16:32 by ADMIN

Issue seems to happen with RadGrid with Bootstrap Skin, RenderMode Lightweight when RequireFieldValidator is enabled in combination with Batch Editing.

Unexpected look (Bootstrap skin):

Other skins seems to have it right.

Expected look (Default skin):

Expected look (Silk skin):


 

Approved
Last Updated: 23 Dec 2019 09:27 by ADMIN

I have a Telerik RadGrid, and there is a date column on the grid layout. The date format I am using to display date values is "dd/MM/yyyy". Then, I export that grid data to Excel file with GridExcelExportFormat.Biff type. The problem here is when I open the newly exported Excel file, the date format is changed to "MM/dd/yyyy". 

I want to keep displaying my date format "dd/MM/yyyy" in the Excel file after exporting the grid data.

Approved
Last Updated: 02 Jan 2020 16:18 by ADMIN

If AJAX is enabled for the RadGrid and re-ordering its columns, a JavaScript exception is thrown: "uncaught typeerror: cannot set property 'control' of undefined"

Approved
Last Updated: 30 Oct 2019 11:43 by ADMIN

We are still experiencing a problem with the RadGrid and JAWS when aria support is enabled. The JAWS form fields dialog (INS+F5) renders all elements of the grid on a single line.

1 2 3