GridExcelExportFormat.Html Footer

[arnaud]

Hi,

Using Radgrid with grouping features (ShowFooter="True" + ShowGroupFooter="true") I'm unable to export to excel the footer (GroupFooters export fine).

I'm using GridExcelExportFormat.Html. The Footer data is a column aggregate sum. Using Telerik 2016, 1, 225, 45.

 

Protected Sub RadGrid1_ItemCommand(ByVal source As Object, ByVal e As GridCommandEventArgs) Handles RadGrid1.ItemCommand

If e.CommandName = Telerik.Web.UI.RadGrid.ExportToExcelCommandName Then
           
            RadGrid1.ExportSettings.Excel.Format = GridExcelExportFormat.Html
            RadGrid1.ExportSettings.SuppressColumnDataFormatStrings = True
            RadGrid1.ExportSettings.HideStructureColumns = True
            RadGrid1.MasterTableView.GroupsDefaultExpanded = True
            RadGrid1.ExportSettings.IgnorePaging = True
            RadGrid1.ExportSettings.ExportOnlyData = True
            RadGrid1.ExportSettings.OpenInNewWindow = True
            RadGrid1.MasterTableView.ExportToExcel()
End If

 

Thanks

Arnaud