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