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
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
7 Answers, 1 is accepted
0
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
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
If you want to get updates on new releases, tips and tricks and sneak peeks at our product labs directly from the developers working on the RadControls for ASP.NET AJAX, subscribe to their blog feed now
0
JJ
Top achievements
Rank 1
answered on 17 Jan 2012, 10:29 AM
thanks Pavlina.
I used :
but thierarchical grid expand button area still show grey image on the exported excel.
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.
0
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
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
If you want to get updates on new releases, tips and tricks and sneak peeks at our product labs directly from the developers working on the RadControls for ASP.NET AJAX, subscribe to their blog feed now
0
JJ
Top achievements
Rank 1
answered on 17 Jan 2012, 03:41 PM
I tried your sample, I still see grey image from your sample export - see attached image file.
I use asp.net ajax Q12011 Net40
I use asp.net ajax Q12011 Net40
0
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
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
If you want to get updates on new releases, tips and tricks and sneak peeks at our product labs directly from the developers working on the RadControls for ASP.NET AJAX, subscribe to their blog feed now
0
JJ
Top achievements
Rank 1
answered on 19 Jan 2012, 02:07 PM
Actually I tried Q3 on your sample project. The child table image gone but master table expand grid still there on the export.
0
Hi,
Please refer to the support ticket post for additional information on the matter.
All the best,
Pavlina
the Telerik team
Please refer to the support ticket post for additional information on the matter.
All the best,
Pavlina
the Telerik team
If you want to get updates on new releases, tips and tricks and sneak peeks at our product labs directly from the developers working on the RadControls for ASP.NET AJAX, subscribe to their blog feed now