Right,

The problem is that, when I have ultragrid - single column with date values and need to have functionality for the user to copy list of dates from excel spreadsheet to this column. I can able to paste just one row but if the copy content is more than 1 row, then I see an error:

Error performing paste operation. Contents being paste have more rows than whats available starting from the anchor cell. Paste contents have 8 rows where as the available rows starting from the anchor cell are 1.

Can you suggest any solution ?

Hi,

So you are trying to add multiple rows into the grid in a single paste operation? That kind of operation is not currently supported.

You might be able to work around this by handling the BeforeMultiCellOperation event and adding the necessary number of extra rows to the grid or it's data source, but I'm no sure if this is possible.

I tried handling BeforeMultiCellOperation event, but it appears the number of cells that were copied from Excel spreadsheet is not passed through this event handler, as I couldn't get exactly how many number of rows to add from e.Cells.RowsCount.

Can you suggest, how exactly BeforeMultiCellOperation can be handled in this case?

If this is not possible through UltraGrid, is there anyother workaround using other controls?

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.