Copy only visible columns in radgridview

4 posts, 0 answers
  1. lucerias
    lucerias avatar
    16 posts
    Member since:
    Nov 2011

    Posted 05 Jan 2012 Link to this post

    Hi, may i know how to copy only visible columns of radgridview to clipboard so that it can be pasted to Excel or vice versa?
    Or i must modify the item source to remove those columns that are not needed for display?

    I am using Silverlight 4.0.

    Thank you very much.
  2.
  3. Maya
    Admin
    Maya avatar
    4062 posts

    Posted 06 Jan 2012 Link to this post

    Hello Lucerias,

    Actually, copying a particular item will copy only the values of the visible columns. Nevertheless, if you want to perform any custom action during this process, you can handle Copying/ CopyingCellClipboardContent events. You can find more information in our online documentation. 

    Kind regards,
    Maya
    the Telerik team

    Explore the entire Telerik portfolio by downloading the Ultimate Collection trial package. Get it now >>

  5. lucerias
    lucerias avatar
    16 posts
    Member since:
    Nov 2011

    Posted 06 Jan 2012 Link to this post

    Hi,

    That is not my case now, i have binded observable collection to radgridview.
    The observable collection contains id, name and age.
    They are displayed as three columns in radgridview.

    I have set id column visibility to false so that it will not be shown in radgridview.
    However, when i peform copy and paste, it actually copies the hidden column value to excel spreadsheet, which means id, name and age all are copied over.

    Please help on this.

    Thanks.

  7. Maya
    Admin
    Maya avatar
    4062 posts

    Posted 06 Jan 2012 Link to this post

    Hello,

    I have tested the case and everything works as expected on my side. Please take a look at this small video for a reference. 
     

    All the best,
    Maya
    the Telerik team

    Explore the entire Telerik portfolio by downloading the Ultimate Collection trial package. Get it now >>

  8.
Back to Top