Skip to main content

SpreadsheetControl.CopiedRangePasting Event

Occurs before the range content is pasted into target cells.

Namespace: DevExpress.Xpf.Spreadsheet

Assembly: DevExpress.Xpf.Spreadsheet.v24.2.dll

NuGet Package: DevExpress.Wpf.Spreadsheet

Declaration

public event CopiedRangePastingEventHandler CopiedRangePasting

Event Data

The CopiedRangePasting event's data class is CopiedRangePastingEventArgs. The following properties provide information specific to this event:

Property Description
Cancel Gets or sets a value indicating whether the operation of pasting data should be canceled.
IsCut Gets or sets a value indicating whether the copied data is cut from the source range.
PasteSpecialFlags Gets or sets the part of copied data to be pasted into target range.
TargetRange Gets the cell range into which data are going to be pasted.

Remarks

Handle the CopiedRangePasting event to perform any actions before the content of copied cells is pasted into the target range. The event parameters allow you define paste options, specify whether the cut operation should be performed, or cancel the paste operation.

The SpreadsheetControl.CopiedRangePasted event is raised when the paste operation is completed.

The code sample below shows how to insert only cell values if the range is pasted to the specific cell range:

using DevExpress.Spreadsheet;

private void spreadsheetControl_CopiedRangePasting(object sender,
  s CopiedRangePastingEventArgs e)
{
    if (e.TargetRange.IsIntersecting
      (spreadsheetControl.Document.Range["A1:B5"])) 
    {
        e.PasteSpecialFlags = PasteSpecial.Values;
    }
}
See Also