SpreadsheetSelectionOptions.AllowExtendSelection Property

Gets or sets whether end-users are allowed to extend selection in a worksheet by dragging or using arrow keys.

Namespace: DevExpress.XtraSpreadsheet

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

Declaration

C#

[DefaultValue(true)]
public bool AllowExtendSelection { get; set; }

VB.NET

<DefaultValue(True)>
Public Property AllowExtendSelection As Boolean

Property Value

Type	Default	Description
Boolean	**true**	true, if end-users can extend the selected range of cells; otherwise, false.

Property Paths

You can access this nested property as listed below:

Object Type	Path to AllowExtendSelection
SpreadsheetBehaviorOptions	.Selection.AllowExtendSelection

Remarks

The selected range of cells can be extended by dragging the selection handles with the mouse or pressing the arrow keys while holding the SHIFT key. When the AllowExtendSelection is set to false, this behavior is unavailable.

Related GitHub Examples

The following code snippets (auto-collected from DevExpress Examples) contain references to the AllowExtendSelection property.

Note

The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.

C#

how-to-display-a-custom-control-over-the-worksheet-cell-t208764/CS/SpreadsheetCustomization/Form1.cs#L30

// Specify the SpreadsheetControl's options.
spreadsheetControl1.Options.Behavior.Selection.AllowExtendSelection = false;
spreadsheetControl1.Options.VerticalScrollbar.Visibility = DevExpress.XtraSpreadsheet.SpreadsheetScrollbarVisibility.Hidden;

how-to-display-custom-controls-instead-of-the-standard-cell-editor-t259398/CS/SpreadsheetCustomization/Form1.cs#L37

// Specify the SpreadsheetControl's options.
spreadsheetControl1.Options.Behavior.Selection.AllowExtendSelection = false;
spreadsheetControl1.Options.Behavior.Drag = DevExpress.XtraSpreadsheet.DocumentCapability.Disabled;

VB.NET

how-to-display-a-custom-control-over-the-worksheet-cell-t208764/VB/SpreadsheetCustomization/Form1.vb#L29

' Specify the SpreadsheetControl's options.
spreadsheetControl1.Options.Behavior.Selection.AllowExtendSelection = False
spreadsheetControl1.Options.VerticalScrollbar.Visibility = DevExpress.XtraSpreadsheet.SpreadsheetScrollbarVisibility.Hidden

how-to-display-custom-controls-instead-of-the-standard-cell-editor-t259398/VB/SpreadsheetCustomization/Form1.vb#L39

' Specify the SpreadsheetControl's options.
spreadsheetControl1.Options.Behavior.Selection.AllowExtendSelection = False
spreadsheetControl1.Options.Behavior.Drag = DevExpress.XtraSpreadsheet.DocumentCapability.Disabled