GridDataBoundGrid crashes when pasting full row of data containing incorrect data type

Question

Hi, I'm using Syncfusion 4.2.0.37.

I created a GridDataBoundGrid instance and bound it to a data table containing two columns that have string and integer data types.

If I *click on the row header* (this is important) paste a line of text "ABC123", it works but if i paste "ABCDEF", it crashes the whole application immediately.

It seems that none of the validation event handlers are called - is there anyway to work around this? Must I change the numeric column to string and validate the cell myself?

Thanks.

Administrator · Answer

To do validation when paste in a GridDataBoundGrid, you need to subscribe to grid.Model.PasteCellText event. There you can validate e.Text based on e.RowIndex, e.ColIndex, e.Style, etc. If you want to not paste a cell but continue pasteing other cells, you can set e.Cancel = true. If you want to stop all pasteing, you set e.Abort = true.