RadGrid Export ExcelML issue

[Prakash Jothi]

Overview of the Implementation

We are using the RadGrid extensively. And we had few common functionalities to be implemnted for each grid. That's the reason, we inherited RadGrid. We as well are overriding,
    OnInit, 
    OnItemCreated
    OnItemDataBound
    OnSortCommand
    OnRowSelect

for our own needs. But it is always ensured that the base function's for the overriden function is always called.
Also, for our purposes we have inherited, the GridBoundColumn as well as
GridHyperLinkColumn.

PROBLEM:

SCENARIO: EXCELML
The Export Format is set to ExcelML. and the code written for it is:

grid.ExportSettings.Excel.Format = GridExcelExportFormat.ExcelML;
grid.ExportSettings.ExportOnlyData = true;
grid.ExportSettings.IgnorePaging = true;
grid.ExportSettings.OpenInNewWindow = true;
grid.MasterTableView.ExportToExcel();

The Export functionality is able to export the Hypelink Columns but, it fails to expport the GridBound Columns. So essentially we are just getting one column exported in excel, which tends to be the Hyperlink Column.

SCENARIO: HTML

//grid.ExportSettings.Excel.Format = GridExcelExportFormat.ExcelML;
grid.ExportSettings.ExportOnlyData = true;
grid.ExportSettings.IgnorePaging = true;
grid.ExportSettings.OpenInNewWindow = true;
grid.MasterTableView.ExportToExcel();

Now the Export functionality is able to export all but the Hypelink Columns. So essentially we are just getting all the column exported in excel, ,other than the Hyperlink one.

When we use the trick provided in

RadGrid for ASP.NET AJAX Q2 2008
Exporting tips and tricks

We were able get all the columns exported in excel in Html Format.
But we would like to have it in pure Excel format.

Any help to resolve the issue would be greatly appreciated.
Thanks

[Rosen]

Hello Prakash Jothi,

I'm afraid that I was unable to recreate the described behavior with the given details. Please find attached a simple implementation of the described scenario with which I have test locally. Please take a look and let me know if I'm missing something obvious.

Kind regards,
Rosen
the Telerik team

Check out Telerik Trainer, the state of the art learning tool for Telerik products.