SpreadsheetSelectionOptions.MoveActiveCellMode Property

Specifies the direction in which an active cell moves on an ENTER key press.

Namespace: DevExpress.XtraSpreadsheet

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

Declaration

C#

[DefaultValue(MoveActiveCellModeOnEnterPress.Down)]
public MoveActiveCellModeOnEnterPress MoveActiveCellMode { get; set; }

VB.NET

<DefaultValue(MoveActiveCellModeOnEnterPress.Down)>
Public Property MoveActiveCellMode As MoveActiveCellModeOnEnterPress

Property Value

Type	Default	Description
MoveActiveCellModeOnEnterPress	**Down**	A MoveActiveCellModeOnEnterPress enumeration value.

Available values:

Name	Description
None	An active cell does not move on an ENTER or a SHIFT+ENTER press.
Down	An active cell moves one cell down on an ENTER press, and one cell up on a SHIFT+ENTER press.
Right	An active cell moves one cell to the right on an ENTER press, and one cell to the left on a SHIFT+ENTER press.
Up	An active cell moves one cell up on an ENTER press, and one cell down on a SHIFT+ENTER press.
Left	An active cell moves one cell to the left on an ENTER press, and one cell to the right on a SHIFT+ENTER press.

Property Paths

You can access this nested property as listed below:

Object Type	Path to MoveActiveCellMode
SpreadsheetBehaviorOptions	.Selection.MoveActiveCellMode

Remarks

By default, when the ENTER key is pressed, the SpreadsheetControl moves an active cell one cell down. Use the MoveActiveCellMode property to set another direction to move an active cell (for example, Up, Right or Left). To keep an active cell on an ENTER press, set the MoveActiveCellMode property to the MoveActiveCellModeOnEnterPress.None value.

The SHIFT+ENTER key combination moves an active cell in the opposite direction of what the MoveActiveCellMode property specifies.

TAB and SHIFT+TAB moves an active cell one cell to the right and to the left respectively, and this behavior is not customized.

Note

If a cell range or multiple ranges are selected in a worksheet, ENTER, SHIFT+ENTER, TAB and SHIFT+TAB move an active cell within this selection only.