how to hide expand image when export thierarchical grid

8 posts, 0 answers
  1. JJ
    JJ avatar
    147 posts
    Member since:
    May 2010

    Posted 16 Jan 2012 Link to this post

    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

     

  2. Pavlina
    Admin
    Pavlina avatar
    6084 posts

    Posted 17 Jan 2012 Link to this post

    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
    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
  3. UI for ASP.NET Ajax is Ready for VS 2017
  4. JJ
    JJ avatar
    147 posts
    Member since:
    May 2010

    Posted 17 Jan 2012 Link to this post

    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.
  5. Pavlina
    Admin
    Pavlina avatar
    6084 posts

    Posted 17 Jan 2012 Link to this post

    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
    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
  6. JJ
    JJ avatar
    147 posts
    Member since:
    May 2010

    Posted 17 Jan 2012 Link to this post

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

    I use asp.net ajax Q12011 Net40
  7. Pavlina
    Admin
    Pavlina avatar
    6084 posts

    Posted 19 Jan 2012 Link to this post

    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
    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
  8. JJ
    JJ avatar
    147 posts
    Member since:
    May 2010

    Posted 19 Jan 2012 Link to this post

    Actually I tried Q3 on your sample project. The child table image gone but master table expand grid still there on the export.
  9. Pavlina
    Admin
    Pavlina avatar
    6084 posts

    Posted 19 Jan 2012 Link to this post

    Hi,

    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
Back to Top
UI for ASP.NET Ajax is Ready for VS 2017