Hello Jon,

Thank you for your feedback. I am glad that you resolved your issue and I believe that other community members may benefit from this as well.

Thanks again.

I know this is a very old post.  I'm on 14.1.  Is there a way to do this now?

If not built-in, is there a way to split the values that are to be pasted?  I want to paste the available records and then add the remaining records.  ClipboardPastingEventArgs.Values doesn't have a setter, so I can't modify it that way and then just run both commands.

gasdausps said:

When copying from Excel i do not want to modify existing records. I would like to add new Records and fill these with the values copied from Excel.

The only time that new records are generated is when the addrecord or one of its cells is active (and you are not in edit mode) and you paste. In that case a new record will be created for each item that is in the clipboard data. If focus wasn't in the addrecord and you still wanted to do this then you would probably have to handle the clipboardpasting event, set e.cancel to true so it doesn't paste into the existing records (assuming the record in the args is not an add record) and asynchronously start another paste operation. E.g.

private void grid_ClipboardPasting(object sender, Infragistics.Windows.DataPresenter.Events.ClipboardPastingEventArgs e)
{
 DataRecord targetRecord = e.GetTargetRecord(0);

 if (!targetRecord.IsAddRecord) // yes insert records
 {
  // cancel the paste at this location and asynchronously
  // start another paste operation after we activate the 
  // add record at this location
  e.Cancel = true;
  DataPresenterBase dp = targetRecord.DataPresenter;
  // clear the selection so the grid won't use those as the target
  dp.SelectedItems.Records.Clear();
  dp.SelectedItems.Cells.Clear();
  // activte the add record
  targetRecord = targetRecord.RecordManager.CurrentAddRecord;
  if (null != targetRecord)
  {
   targetRecord.IsActive = true;
   Cell cell = targetRecord.Cells[e.GetTargetField(0)];
   if (null != cell)
    cell.IsActive = true;
   DispatcherOperationCallback callback = delegate(object param)
   {
    ((DataPresenterBase)param).ExecuteCommand(DataPresenterCommands.Paste);
    return null;
   };
   dp.Dispatcher.BeginInvoke(DispatcherPriority.Normal, callback, dp);
  }
 }
}

Since the records in view are going to change you might also consider giving the user a messagebox prompt.