Copy/Paste for UltraGrid | Infragistics Forums

Hi,

I tried it out and it looks like the error occurs before the BeforeMultiCellOperation event fires, so my suggestion won't work.

You might be able to use the grid's Error event, instead. It's going to be pretty tricky, though. I got this working in a very simple case and I have posted the code here, but please note that this code is not complete.

        void ultraGrid1_Error(object sender, Infragistics.Win.UltraWinGrid.ErrorEventArgs e)
        {
            // Is this an error from a Paste operation?
            if (e.MultiCellOperationErrorInfo != null &&
                e.MultiCellOperationErrorInfo.Operation == MultiCellOperation.Paste)
            {
                // Is there an Exception?
                InvalidOperationException exception = e.MultiCellOperationErrorInfo.Exception as InvalidOperationException;
                if (exception != null)
                {
                    // IS this an exception because there aren't enough selected rows?
                    string exceptionStart = "Contents being pasted have more rows than what's available starting from the anchor cell. Paste contents have ";
                    string exceptionMessage = exception.Message;
                    if (exceptionMessage.StartsWith(exceptionStart))
                    {
                        // Parse the exception message to determine the number of rows that we would need in
                        // or to successfully complete the Paste operation.
                        exceptionMessage = exceptionMessage.Substring(exceptionStart.Length);
                        int rowsIndex = exceptionMessage.IndexOf(" rows");
                        if (rowsIndex == -1)
                            return;

                        exceptionMessage = exceptionMessage.Substring(0, rowsIndex);
                        int rowCountNeeded = int.Parse(exceptionMessage);


                        UltraGrid grid = (UltraGrid)sender;

                        // Sort the selected rows in visible order to make the logic simpler.
                        grid.Selected.Rows.Sort();

                        // Add new rows to the grid and move them into position under the last selected row and
                        // select these rows.
                        while (grid.Selected.Rows.Count < rowCountNeeded)
                        {
                            UltraGridRow lastSelectedRow = grid.Selected.Rows[this.ultraGrid1.Selected.Rows.Count - 1];

                            UltraGridRow newRow = grid.DisplayLayout.Bands[0].AddNew();
                            newRow.ParentCollection.Move(newRow, lastSelectedRow.Index + 1);
                            grid.Selected.Rows.Add(newRow);
                        }

                        // The current operation has failed, but now we have new rows to paste into so
                        // cancel the error message and do another paste.
                        e.Cancel = true;
                        grid.PerformAction(UltraGridAction.Paste);
                    }
                }
            }
        }

This code won't handle hierarchical data.

Also, the exception message could be localized, so the parsing here would not work in such a case.