Skip to main content

SpreadsheetControl.BeforeDragRange Event

Occurs when a user starts to drag the selected cell range.

Namespace: DevExpress.XtraSpreadsheet

Assembly: DevExpress.XtraSpreadsheet.v22.1.dll


public event BeforeDragRangeEventHandler BeforeDragRange

Event Data

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




Set the event’s Cancel parameter to true to cancel the drag operation.

See Also