I am using Telerik Silverlight version 2013.1.422.
I have RadGridView bound to a hierarchical dataset. Some of the columns in child tables have IsVisible set to false. When I export to Excel, the hidden columns are included, but I do not want them to be. How can I hide them or prevent them from being exported?
When I export a flat dataset (no child tables) where some columns are hidden in the RadGridView, the export to Excel DOES NOT export the hidden columns. This is the behaviour I want with hierarchical datasets too.
I have been trying to use the ElementExporing event to cancel the export if the element has a column with IsVisible set to false, but it it not working. Please, give me some guidance.
Kind Regards,
Albert
I have RadGridView bound to a hierarchical dataset. Some of the columns in child tables have IsVisible set to false. When I export to Excel, the hidden columns are included, but I do not want them to be. How can I hide them or prevent them from being exported?
When I export a flat dataset (no child tables) where some columns are hidden in the RadGridView, the export to Excel DOES NOT export the hidden columns. This is the behaviour I want with hierarchical datasets too.
I have been trying to use the ElementExporing event to cancel the export if the element has a column with IsVisible set to false, but it it not working. Please, give me some guidance.
Kind Regards,
Albert
2 Answers, 1 is accepted
0
Albert
Top achievements
Rank 1
Rank 1
answered on 19 Oct 2014, 03:57 PM
Figured it out. The problem was in some custom code in the ElementExporting event handler.
0
Hi Albert,
You can also check the Export FAQ article on more frequently asked questions.
Regards,
Dimitrina
Telerik
You can also check the Export FAQ article on more frequently asked questions.
Regards,
Dimitrina
Telerik
Check out the Telerik Platform - the only platform that combines a rich set of UI tools with powerful cloud services to develop web, hybrid and native mobile apps.