I'm trying out the desktop grid in a windows forms application using Visual Studio 2005. I populate the grid with data from a database. The first column is populated with headings so those cells are locked, as are the cells in the first row. When I select multple cells from an external spreadsheet and paste them into a similar selection in the grid control things go slightly wrong. The paste is succesful and the data is pasted correctly. However the data in the row below the selection is also affected in the sense that the left hand cell immediately below the selection is cleared and data from the other cells in that row are moved along to fill the space.
Can you help me with this?