GridControl ClipboardPaste Event

[Maqsood Ahmed]

Hello!
I Copy some text from Excel and Paste it to the GridControl grid. If no. of Columns Copied from Excel are greater than the ColCount of GridControl, it simply adds more columns to the grid, a behaviour that I don''t want in my task. I started to use ClipboardPaste Event and tried to check the Range in GridCutPasteEventArgs''s RangeList.ActiveRange GridRangeInfo. But when I copy something from out of the Grid and want to paste it to the grid, e.RangeList.ActiveRange returns null, i-e. I could not check the copied data range. Is there anyway to restrict grid to not adding more columns while copy/pasting data from Excel???

[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

[Maqsood Ahmed]

Thanks for your answer. Its working fine now