Pasting data increases rowcount

[Administrator]

Hi,

If I have a grid with 5 rows, then try to paste 10 rows of data from excel, the grid is expanded to 10 rows. This is very nice behaviour (thanks!), but occasionally I need the row count to remain fixed. Is there any way I can prevent the number of rows changing?

Thanks
Akash

[Administrator]

There is a property flag that controls whether or not rows/columns can be appended during a paste.

//C#
this.gridControl1.CutPaste.ClipboardFlags |= (GridDragDropFlags.NoAppendCols | GridDragDropFlags.NoAppendRows);

''VB.NET
 Me.GridControl1.Model.CutPaste.ClipboardFlags = Me.GridControl1.Model.CutPaste.ClipboardFlags _
               Or GridDragDropFlags.NoAppendRows _

Or GridDragDropFlags.NoAppendCols

            

[Administrator]

Thanks - once again the support the excellent!

Akash

>There is a property flag that controls whether or not rows/columns can be appended during a paste.
>
>

>//C#
>this.gridControl1.CutPaste.ClipboardFlags |= (GridDragDropFlags.NoAppendCols | GridDragDropFlags.NoAppendRows);
>
>''VB.NET
> Me.GridControl1.Model.CutPaste.ClipboardFlags = Me.GridControl1.Model.CutPaste.ClipboardFlags _
>               Or GridDragDropFlags.NoAppendRows _
>
>Or GridDragDropFlags.NoAppendCols
>