1. By default I cannot paste data on the radgrid if I don't have any rows created.For e.g in a grid with no rows I cannot paste data on the radgrid.Is there any setting to chane this behavior?
2. When I copy data from excel and paste in the grid the column order has to be the same as that in the excel.For e.g in the excel the columns are A,B,C and in the grid the order is C,B,A..Then 'paste' copies A' data to C and C's data on excel to column A on the grid.
Is it possible to trap the pasting programmatically to paste A's data in excel to A's column of the grid.ie. one to one. irrespective of the column order mismatch between the excel and the grid?
Also I should be able to paste data to an empty grid by identifying how many rows needs to be created.