Completed
Last Updated: 11 Dec 2020 15:01 by ADMIN
Release R1 2021
Doug
Created on: 14 Mar 2019 15:51
Category: Grid
Type: Bug Report
4
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>