SpreadsheetCellEditorBehaviorOptions.CommitMode Property

Gets or sets a mode that specifies when the SpreadsheetControl.CellValueChanged event should be raised after a cell value has been edited via the cell editor and committed.

Namespace: DevExpress.XtraSpreadsheet

Assembly: DevExpress.Spreadsheet.v23.2.Core.dll

NuGet Package: DevExpress.Spreadsheet.Core

Declaration

C#

[DefaultValue(CellEditorCommitMode.Auto)]
public CellEditorCommitMode CommitMode { get; set; }

VB.NET

<DefaultValue(CellEditorCommitMode.Auto)>
Public Property CommitMode As CellEditorCommitMode

Property Value

Type	Default	Description
CellEditorCommitMode	Auto	A CellEditorCommitMode enumeration value.

Available values:

Name	Description
Auto	Defined automatically when the SpreadsheetControl.CellValueChanged event should be raised for cells whose values have been edited via the cell editor and committed.
Always	The SpreadsheetControl.CellValueChanged event is raised for each cell whose value has been edited via the cell editor and committed (even if a new cell value is the same as the value before editing).
ChangedOnly	The SpreadsheetControl.CellValueChanged event is raised for each cell whose value has been changed via the cell editor and committed. If a new cell value is the same as the value before editing, the event does not occur.

Property Paths

You can access this nested property as listed below:

Object Type	Path to CommitMode
SpreadsheetBehaviorOptions	.CellEditor .CommitMode

Remarks

To access the CommitMode property, use the SpreadsheetControl.Options.Behavior.CellEditor.CommitMode notation. This property allows you to specify when the SpreadsheetControl.CellValueChanged event should be raised after a cell value has been edited via the cell editor and committed: each time (CellEditorCommitMode.Always) or only if a cell value has been changed (CellEditorCommitMode.ChangedOnly).