I want to set the max number of columns in the grid to 10, which I do in properties, at design time. However, if the user pastes some data with more than 10 columns, additional columns are added to the grid. How can I prevent this from happening? I would rather that the data from extra columns was not recorded at all or an error was given.
Thank you.