.NET Framework 4.5.2+
.NET Framework 4.5.2+
.NET Standard 2.0+

SpreadsheetBehaviorOptions.Drag Property

Gets or sets whether the Drag operation is permitted.

Namespace: DevExpress.XtraSpreadsheet

Assembly: DevExpress.Spreadsheet.v20.1.Core.dll


public DocumentCapability Drag { get; set; }
Public Property Drag As DocumentCapability

Property Value

Type Description

A DocumentCapability enumeration value specifying the document's capability to perform an operation.

Property Paths

You can access this nested property as listed below:

Object Type Path to Drag


When the Drag property is set to DocumentCapability.Disabled value, all drag operations in the SpreadsheetControl are disabled, including dragging ranges, pictures and comments. However, there are certain details concerning cell range operations which are described below.

The effect of different Drag settings on the selected range is as follows:

  • Default All drag operations are allowed. Fill handle (a small square in the lower-right corner of the selection, used to automatically fill adjacent cells with a data series) is enabled. The end-user can also move range data by dragging the selected range to another location.


  • Enabled

    Drag operations are allowed. Fill handle and move range operations are enabled. You can use the SpreadsheetBehaviorOptions.FillHandle and SpreadsheetBehaviorOptions.MoveRange properties to disable the features individually.


  • Disabled

    All drag operations are prohibited. If the SpreadsheetBehaviorOptions.MoveRange value is DocumentCapability.Default, the fill handle is disabled, ignoring any SpreadsheetBehaviorOptions.FillHandle value and the end-user cannot move range data by dragging the selected range to another location.


    However, if the MoveRange capability is set to either Enabled or Disabled, the FillHandle value is in effect.


See Also