I am working with a large grid which has some read only columns. When I try to paste cells out of the xls in to the grid I get an error message that the cell is read only for each read only cell in every row. Even if the cell is blank in xls it gives the error message.
Message: The "Label" cell is read-only. Continue with the remaining cells?
Is there a setting that can be used to ignore these warnings?
During a single paste operation you would get that error once for each read-only field but you shouldn't get it for the same field in different rows in the same operation. The message is intended to make the end user aware that not all of the information being pasted, etc. could be processed. Are you sure you're getting it a separate time for each record in the same operation? With regards to the specific question there are two options. One is to handle the ClipboardOperationError event and set the DisplayErrorMessage to false if the e.Error is ReadOnlyCell. Another option would be to set the Field's DisallowModificationViaClipboard to true.
That resolved some of the errors I was getting. Thanks
The error now is slightly different. I was able to stop the message, but will have to revisit it later on.
When pasting in to a grid I am preforming actions on the cells, filter combo box, set defaults and things like that. The first row works correctly, but once past the add row each line errors. The event is risen that a cell has been changed, but there is no row in the grid yet. So when we try to reference the cell it comes up as null. I can see it happening as I cycle in to each row of the paste. Once all cells have been populated a new row is added.
Ok when you have time later to put together a sample we can certainly look into the issue.