officefileapi-devexpress-dot-xtraspreadsheet-dot-spreadsheetcelleditorbehavioroptions.md
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.v25.2.Core.dll
NuGet Package : DevExpress.Spreadsheet.Core
[DefaultValue(CellEditorCommitMode.Auto)]
public CellEditorCommitMode CommitMode { get; set; }
<DefaultValue(CellEditorCommitMode.Auto)>
Public Property CommitMode As CellEditorCommitMode
| 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.
|
You can access this nested property as listed below:
| Object Type | Path to CommitMode |
|---|---|
| SpreadsheetBehaviorOptions |
.CellEditor .CommitMode
|
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).
See Also
SpreadsheetCellEditorBehaviorOptions Class