RadGrid export to excel throws exception Index was outside the bonds of the array

Progress® Telerik® UI for ASP.NET AJAX Feedback Portal

Create an account Log In

Back to Feed

Request a Feature Report a Bug

Unplanned

Last Updated: 07 Jan 2020 08:51 by ADMIN

Doug

Created on: 14 Mar 2019 15:51

Category: Grid

Type: Bug Report

RadGrid export to excel throws exception Index was outside the bonds of the array

When there is at least one ColumnGroup which is not assigned to any of the columns in RadGrid, exporting to Excel throws an exception "Index was outside the bonds of the array"

3 comments

ADMIN

Attila Antal

Posted on: 07 Jan 2020 08:51

Hi Vasssek,

This issue has been registered in our system and is placed on the waiting list to be resolved. We have our road map planned ahead and we are working according to the plan. At this moment we are unable to provide with an estimated time for the fix.

Until the issue will be fixed, we can offer the workaround shared in the previous post.

Please excuse us for any inconvenience this may have caused.

Kind regards,
Attila Antal
Progress Telerik

Get quickly onboarded and successful with your Telerik and/or Kendo UI products with the Virtual Classroom free technical training, available to all active customers. Learn More.

Vasssek

Posted on: 01 Jan 2020 16:29

When will be this bug fixed ?

ADMIN

Attila Antal

Posted on: 14 Mar 2019 15:56

The only workaround at the moment is to remove the ColumngGroup if not in use.

<telerik:RadGrid ID="RadGrid1" runat="server">
    <ExportSettings IgnorePaging="true" ExportOnlyData="true">
        <Excel Format="Xlsx" />
    </ExportSettings>
    <MasterTableView AutoGenerateColumns="False" DataKeyNames="OrderID" CommandItemDisplay="Top">
        <CommandItemSettings ShowExportToExcelButton="true" />
        <%--<ColumnGroups>
            <telerik:GridColumnGroup Name="Group1" HeaderText="Group 1"></telerik:GridColumnGroup>
        </ColumnGroups>--%>
        <Columns>
            <telerik:GridBoundColumn DataField="OrderID" DataType="System.Int32"
                FilterControlAltText="Filter OrderID column" HeaderText="OrderID"
                ReadOnly="True" SortExpression="OrderID" UniqueName="OrderID">
            </telerik:GridBoundColumn>
            <telerik:GridDateTimeColumn DataField="OrderDate" DataType="System.DateTime"
                FilterControlAltText="Filter OrderDate column" HeaderText="OrderDate"
                SortExpression="OrderDate" UniqueName="OrderDate">
            </telerik:GridDateTimeColumn>
        </Columns>
    </MasterTableView>
</telerik:RadGrid>