Copy only visible columns in radgridview

[lucerias]

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.

[Maya]

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

[lucerias]

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.

[Maya]

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