how to hide expand image when export thierarchical grid

[JJ]

I have a thierarchical grid needs to export.

I need to use  grid.ExportSettings.ExportOnlyData = false; becaues I need to keep the dropdown list template for my grid export.

But when export to excel I can see the expand image listed as a grey area in my excel export sheet. If it is a column, I know how to hide, but this doesn't seem to be a column on the grid. How can  I remove the grey expand area?

Thanks

 

[Pavlina]

Hello,

Try setting the ExportSettings -> HideStructureColumns boolean property of grid in order to remove the expand column on export. For more information you can refer to the help article below:
http://www.telerik.com/help/aspnet-ajax/grid-export.html.

Kind regards,
Pavlina
the Telerik team

[JJ]

thanks Pavlina.

I used :

grid.ExportSettings.IgnorePaging =

 

true;

 

grid.ExportSettings.OpenInNewWindow =

 

true;

 

grid.ExportSettings.ExportOnlyData =

 

false;

 

grid.ExportSettings.HideStructureColumns =

 

true;

 

grid.AllowSorting =

 

false;

 

but thierarchical grid expand button area still show grey image on the exported excel.

[Pavlina]

Hi,

I am sending you a sample project where the expand column is not visible in the exported file. Please give it a try and let me know what is the difference in your case.

Greetings,
Pavlina
the Telerik team

[JJ]

I tried your sample, I still see grey image from your sample export - see attached image file.

I use asp.net ajax Q12011 Net40

[Pavlina]

Hi,

Indeed such problem persists in the official version of RadControls. However, it is fixed in Q3 2011 SP1, please upgrade your application to take care of this issue. I am also attaching the project with Telerik.Web.UI.dll from SP1 which is working properly.

Greetings,
Pavlina
the Telerik team

[JJ]

Actually I tried Q3 on your sample project. The child table image gone but master table expand grid still there on the export.

[Pavlina]

Hi,

Please refer to the support ticket post for additional information on the matter.

All the best,
Pavlina
the Telerik team