Back to Devexpress

SpreadsheetBehaviorOptions.MoveRange Property

officefileapi-devexpress-dot-xtraspreadsheet-dot-spreadsheetbehavioroptions-6747acb4.md

latest3.6 KB
Original Source

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.v25.2.Core.dll

NuGet Package : DevExpress.Spreadsheet.Core

Declaration

csharp
[DefaultValue(DocumentCapability.Default)]
public DocumentCapability MoveRange { get; set; }
vb
<DefaultValue(DocumentCapability.Default)>
Public Property MoveRange As DocumentCapability

Property Value

TypeDefaultDescription
DocumentCapabilityDefault

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

|

Available values:

NameDescription
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 TypePath to MoveRange
SpreadsheetControlOptions

.Behavior .MoveRange

|

Remarks

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

|

|

|

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 = DefaultDrag = Disabled, MoveRange = DefaultDrag = 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

Operation Restrictions module in the XtraSpreadsheet MainDemo

SpreadsheetBehaviorOptions Class

SpreadsheetBehaviorOptions Members

DevExpress.XtraSpreadsheet Namespace