SpreadsheetControl.BeforeDragRange Event

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

Namespace: DevExpress.XtraSpreadsheet

Assembly: DevExpress.XtraSpreadsheet.v22.1.dll

NuGet Package: DevExpress.Win.Spreadsheet

Declaration

C#

public event BeforeDragRangeEventHandler BeforeDragRange

VB.NET

Public Event BeforeDragRange As BeforeDragRangeEventHandler

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.

Remarks

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
DragDrop	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.
Fill	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.