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 |
|
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 = 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.