officefileapi-devexpress-dot-xtraspreadsheet-dot-spreadsheetbehavioroptions-6747acb4.md
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
[DefaultValue(DocumentCapability.Default)]
public DocumentCapability MoveRange { get; set; }
<DefaultValue(DocumentCapability.Default)>
Public Property MoveRange As DocumentCapability
| 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.
|
You can access this nested property as listed below:
| Object Type | Path to MoveRange |
|---|---|
| SpreadsheetControlOptions |
.Behavior .MoveRange
|
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 = 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
Operation Restrictions module in the XtraSpreadsheet MainDemo
SpreadsheetBehaviorOptions Class