Copy & Paste
Is there any way to copy and paste like multiple rows and paste directly into excel as opposed to having to use the Export opion in RadGridView
As the RadGridView Export always insists on the user saving the file first as this can be sometime quite cumbersome?
Thanks and regards,
Suman
11 Answers, 1 is accepted
All you need to do is set the SelectionMode property on RadGridView to Multiple or Extended, in order to achieve multiple row selectio, press CTRL + C and that's all. RadGridView has robust Clipboard integration, which allows you to copy and/or paste cell or entire rows.
Best wishes,Yavor Georgiev
the Telerik team
Rank 1
I was able to copy and paste the entire row, but I am unable to select, copy the GridHeader
How do we copy the Grid Header (Entire header row) ?
Thanks and regards,
Suman
You need to include the GridViewClipboardCopyMode.Header flag in the ClipboardCopyMode property of RadGridView. You can set it like so "<telerik:RadGridView .... ClipboardCopyMode="Cells,Header"/>" in XAML or like so "radGridView1.ClipboardCopyMode = GridViewClipboardCopyMode.Cells | GridViewClibpoardCopyMode.Header;" in code-behind.
When this flag is present, RadGridView will also include the column header for any selected cells.
Yavor Georgiev
the Telerik team
Rank 1
You can use RadGridViewCommands.Copy and RadGridViewCommands.Paste, which are routed UI commands that we ship with RadGridView. You can see an example of the different RadGridViewCommands being used here.
Best wishes,
Yavor Georgiev
the Telerik team
Rank 2
Could you clarify what exactly you want to accomplish ? Do you want to copy a row and paste it to multiple other selected rows ? Or you want to insert a new row on pasting ?
Maya
Telerik
Explore the entire Telerik portfolio by downloading Telerik DevCraft Ultimate.
Rank 2
I just do a deep clone of DataContext object for the selected row and add the copy to the collection and issue a Grid.Rebind and do a SelectedItem = to the new object also a CurrentItem = to the new object and it works fine
Ok, great. Let me know if you need further assistance.
Maya
Telerik
Explore the entire Telerik portfolio by downloading Telerik DevCraft Ultimate.
Rank 1
i'm not sure if my problem has a solution on these forums which i didn't get to see . I actually made a lot of searches before posting this :
i am using telerik winforms 2013 q2 radgridview and trying to paste texts copied from MS word files in arabic language . if the pasted text exceeds a certain number of caracters, my form ends up hanging forever.
i tried to do so with texts from word ,excel or from the web even in arabic ...it's all working like a charm ! (till now i supposed the problem is only with my text )
I,finally ,tried doing something with the code i'm not sure if it's helpful :
on keydown event, after testing if the buttons clicked are ctrl+v , i used setdata() function to change the data format to text instead of unicode text . Surprisingly, it pasted an incomprehensible text (eventually its equivalente in another language) and my form didn't hang .
Could you please help me out? i'm running out of solutions .
Thanks in advance
This forum thread is for the UI for Silverlight RadGridView components. Please note, that we are constantly trying to keep our support communication consistent. So, since you are using the UI for Winforms RadGridView, I would kindly ask you to post your inquiry in the relevant forum section.
Thank you in advance for your understanding.
Regards,
Stefan
Progress Telerik