hidden DetailTemplateItemDataCell causes blank Excel row

[Benjamin]

I am hiding the detail template item in the OnItemDataBound method which works, but this causes a blank row when I export to Excel.  How can the row be removed completely?

Dim item = CType(e.Item, GridDataItem)

item.DetailTemplateItemDataCell.Visible = false

[Attila Antal]

Hi Benjamin,

The method from your description only hides the Cell inside the DetailTemplateItem, but the item itself remains visible.

To hide them when exporting, try the following example:

protected void RadGrid1_PreRender(object sender, EventArgs e)
{
    if (RadGrid1.IsExporting)
    {
        foreach (GridDetailTemplateItem detailTemplateItem in RadGrid1.MasterTableView.GetItems(GridItemType.DetailTemplateItem))
        {
            detailTemplateItem.Visible = false;
        }
    }
}

 

Kind regards,
Attila Antal
Progress Telerik

[Benjamin]

That worked, thanks!