Problem pasting multiple rows in grid view

[Ricardo]

Hi,

I have a problem using "paste" in radgridView of 2012.2.607.40. (it Works well of 2011.3.1116.40).

I select 3 rows in Excel,copy them and I want to paste these in  my grid.  I click new row then click paste. I hope that the 3 rows will in the last 3 rows in my grid. it means that these 3 rows will be 3 new rows of my grid. BUT the result is , it will erase the first 3 rows of my current grid. Sometimes il will erasing the last few rows.

For exemple : I have 1,2,3,4 in my grid, each number in a different row (4 rows). Now, i want to paste 5,6,7 in the grid, I click add rows (now I have 1,2,3,4,0 in 5 rows), and click paste, the result that I want is 1,2,3,4,5,6,7, BUT the result is 5,6,7,4,0 .

Here is my grid :   
           <telerik:RadGridView
                SelectionMode="Extended" MaxHeight="150" x:Name="gridView"
                IsReadOnly="{Binding Path=ObjectBase.IsReadOnly, RelativeSource={RelativeSource FindAncestor, AncestorType=sc:GridDesigner}}"
                VerticalAlignment="Top" CanUserDeleteRows="True" RowIndicatorVisibility="Visible"
                CanUserFreezeColumns="False" CanUserInsertRows="True" ShowGroupPanel="False"
                AutoGenerateColumns="True" CanUserSelect="True" SelectionUnit="FullRow"
                ClipboardCopyMode="Cells" ClipboardPasteMode="Default" BorderThickness="0" EnableRowVirtualization="True">
            </telerik:RadGridView>

Then I have tried to use the control of Pasting like this :
private void gridView_Pasting(object sender, GridViewClipboardEventArgs e)
{
    var newItem = this.radGridView1.Items.AddNew();
    this.gridView.SelectedItem = newItem;
}

And also like this:

        private void gridView_Pasting(object sender, Telerik.Windows.Controls.GridViewClipboardEventArgs e)
        {
            this.gridView.Items.MoveCurrentToLast();
        }

but it doesn't work.

Thank you in advance for your help.

Ricardo Chorro.

[Maya]

Hi Ricardo,

Indeed, that would be the expected behavior. What you can try is to handle Pasting event, cancel it and add the items you have just copied explicitly in the source of the grid. 

All the best,
Maya
the Telerik team

[Ankur]

Hi Ricardo,

I am facing the same problem. Did you manage to resolve it?

Thanks in advance.

Ankur

[Maya]

Hello Ankur,

Did you try the approach suggested above ?  

All the best,
Maya
the Telerik team

[Ankur]

Thanks Maya for your reply.

Can you point me to a link on how to implement it? I have just started using Telerik controls for the first time so still in the learning phase...

[Maya]

Hi Ankur,

Firstly, you need to add handler for the Pasting event of RadGridView and get the text being copied from the Clipboard. Check out this article for more information. Once you get the values, you can create new business object, assign the values and add it to the source of the grid (you can get the source from the ItemsSource of the grid or from its Items collection).

Kind regards,
Maya
the Telerik team