SpreadsheetControl.CopiedRangePasting Event

Occurs before the range content is pasted into target cells.

Namespace: DevExpress.Xpf.Spreadsheet

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

NuGet Package: DevExpress.Wpf.Spreadsheet

Declaration

C#

public event CopiedRangePastingEventHandler CopiedRangePasting

VB.NET

Public Event CopiedRangePasting As CopiedRangePastingEventHandler

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:

C#

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;
    }
}

VB.NET

Imports DevExpress.Spreadsheet

Private Sub spreadsheetControl_CopiedRangePasting(ByVal sender As Object, ByVal e As CopiedRangePastingEventArgs)
  If e.TargetRange.IsIntersecting
    (spreadsheetControl.Document.Range("A1:B5")) Then
    e.PasteSpecialFlags = PasteSpecial.Values
  End If
End Sub