wpf-devexpress-dot-xpf-dot-spreadsheet-dot-spreadsheetcontrol-48fbf249.md
Occurs when a user starts to drag the selected cell range.
Namespace : DevExpress.Xpf.Spreadsheet
Assembly : DevExpress.Xpf.Spreadsheet.v25.2.dll
NuGet Package : DevExpress.Wpf.Spreadsheet
public event BeforeDragRangeEventHandler BeforeDragRange
Public Event BeforeDragRange As BeforeDragRangeEventHandler
The BeforeDragRange event's data class is BeforeDragRangeEventArgs. The following properties provide information specific to this event:
| Property | Description |
|---|---|
| Cancel | Gets or sets whether to cancel the drag-and-drop or fill operation for the selected cell range. |
| DataTransferMode | Returns the operation type a user performs on the selected cells. |
| Range | Returns a cell range a user starts to drag. |
Handle the BeforeDragRange event to perform any actions when a user starts to drag a cell range in a worksheet. This event occurs first in a sequence of events related to the drag-and-drop and fill operations.
The following table lists events that can fire depending on the operation type (DataTransferMode):
|
Operation Type
|
Events
| | --- | --- | |
|
SpreadsheetControl.BeforeDropRange - Occurs when a user is about to drop the selected cell range in a new location.
SpreadsheetControl.AfterDropRange - Occurs after a user dropped the selected cell range in a new location.
| |
|
SpreadsheetControl.BeforeFillRange - Occurs when a user drags the fill handle to populate the adjacent cells with data based on the source cells’ values.
SpreadsheetControl.AfterFillRange - Occurs after the AutoFill operation is completed.
|
Set the event’s Cancel parameter to true to cancel the drag operation.
See Also