Skip to main content

SpreadsheetBehaviorOptions.MoveRange Property

Gets or sets whether the end-user operation, which includes dragging the selected range and moving it, is permitted.

Namespace: DevExpress.XtraSpreadsheet

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

NuGet Package: DevExpress.Spreadsheet.Core

Declaration

[DefaultValue(DocumentCapability.Default)]
public DocumentCapability MoveRange { get; set; }

Property Value

Type Default Description
DocumentCapability Default

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

Available values:

Name Description
Default

The value is determined by the current setting. The default value is automatically set if it is not explicitly specified.

Disabled

The feature is not allowed and the corresponding commands are shown disabled.

Enabled

The feature is available and the corresponding commands are shown enabled.

Hidden

The feature is not available and the corresponding commands are hidden.

Property Paths

You can access this nested property as listed below:

Object Type Path to MoveRange
SpreadsheetControlOptions
.Behavior .MoveRange

Remarks

The following picture illustrates how certain values of the different SpreadsheetBehaviorOptions class properties affect the SpreadsheetControl functionality.

SpreadsheetBehaviorOptions.Drag.Default.MoveRange.Default.FillHandle.True

SpreadsheetBehaviorOptions.Drag.Disabled

The mouse pointer in the picture above is a move pointer indicating that the end-user can move the range by dragging the selection to a new location.

The actual effect of the MoveRange‘s Default value is dependent on the SpreadsheetBehaviorOptions.Drag value, as illustrated in the table below.

Drag = Default, MoveRange = Default Drag = Disabled, MoveRange = Default Drag = Enabled, MoveRange = Default
End-user can move a cell range. End-user cannot move a cell range. End-user can move a cell range.

For a use example, review the Operation Restrictions module in the XtraSpreadsheet MainDemo.

See Also