I understand your requirement and I can confirm that the built-in grid behavior is to cancel the operation in this situation. Modifying this behavior can be achieved by following the same approach and validating and canceling the action with the help of the grid’s Error event and some logic over the event arguments, grid’s columns and rows and the Clipboard’s contents. Actually, a similar question has already been discussed in our forum, please check out this thread. In an effort to test the suggestion there, I have adapted the previous sample to fit the requirement of accepting the pasted values within the available range and rejecting the others. As you will see, the logic is pretty custom and my suggestion is to test and debug it in order to adapt it to best fit your requirement. As this is a custom workaround solution, which is not fully tested, it may not cover all possible scenarios and will require further adjustment on your side. The purpose of the sample is to give you an idea of how you may go on about implementing your requirement, however, according to our Support Policy, implementing specific application scenarios is considered out of the scope of the service. Also, please, keep in mind that we handle a single question per support case, which is to ensure that all your issues are addressed correctly.

Thank you for your cooperation.

In conclusion, please, check out the suggested sample on your side and let me know if it helps.

Best regards,
Bozhidara Pachilova
Associate Software Developer

8255.UGMultiCellPaste3.zip

Regarding the error when pasting more cells/rows than available, yes, the UltraGrid already has a built-in validation message for this and will not allow it. The default error message is quite descriptive as it informs the user on the reason and the number of cells/rows exceeding the available space. Nevertheless, if you still require to handle this on your own, a possible approach is to handle the grid’s Error event, which is also Cancelable and provides some useful arguments about the raised error. As you can read in the referenced API document, the ErrorText message could be modified, or alternatively the default dialog box can be prevented from being displayed and your own custom one can be shown instead by canceling the event.

Attached you will find the updated sample from before, which includes a demo solution for this case:

private void ultraGrid1_Error(object sender, ErrorEventArgs e)
        {
            if(e.ErrorType == ErrorType.MultiCellOperation
                && e.ErrorText.Contains("Contents being pasted have more rows than what's available starting from the anchor cell."))
            {
                MessageBox.Show("Custom error message!");
                e.Cancel=true;
            }
        }

I hope this helps. Let me know if I can help with anything else regarding this matter.

Best regards,
Bozhidara Pachilova
Associate Software Developer

6366.UGMultiCellPaste2.zip