CellEditorEnterValueMode Enum

Lists values that specify how to commit a cell value when closing the cell editor.

Namespace: DevExpress.XtraSpreadsheet

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

Declaration

C#

public enum CellEditorEnterValueMode

VB.NET

Public Enum CellEditorEnterValueMode

Members

Name	Description
ActiveCell	Commits a value entered via the cell editor to an active cell.
Default	Defines the same behavior as the CellEditorEnterValueMode.ActiveCell mode.
SelectedCells	Commits a value entered via the cell editor to all currently selected cells.
ArrayFormula	Commits a formula entered via the cell editor as an array formula to an active cell or selected cells.
Cancel	Cancels any changes to a cell value made in the cell editor.

Remarks

A CellEditorEnterValueMode enumeration value is used in the SpreadsheetControl.CloseCellEditor method as a parameter.

Related GitHub Examples

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

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-use-custom-cell-editors-to-create-a-data-entry-form-t419595/CS/DevAVInvoicing/Form1.cs#L160

if (spreadsheetControl1.IsCellEditorActive)
    spreadsheetControl1.CloseCellEditor(CellEditorEnterValueMode.Cancel);
sheet.Rows.Remove(sheet.SelectedCell.TopRowIndex, 1);

how-to-use-spreadsheet-control-to-create-a-data-entry-form/CS/DataEntryFormSample/SpreadsheetBindingManager.cs#L169

{
    DeactivateCellEditor(CellEditorEnterValueMode.ActiveCell);
    UnsubscribePropertyChanged();

how-to-use-spreadsheetcontrol-to-create-a-data-entry-form/CS/WpfDataEntryFormSample/SpreadsheetBindingManager.cs#L156

{
    DeactivateCellEditor(DevExpress.XtraSpreadsheet.CellEditorEnterValueMode.ActiveCell);
    UnsubscribePropertyChanged();

how-to-bind-a-spreadsheet-to-an-ms-sql-server-database-wpf-spreadsheet-t480591/CS/WpfSpreadsheet_BindToDataSource/MainWindow.xaml.cs#L175

    if (spreadsheetControl.IsCellEditorActive)
        spreadsheetControl.CloseCellEditor(DevExpress.XtraSpreadsheet.CellEditorEnterValueMode.Default);
}

how-to-bind-a-spreadsheet-to-an-ms-sql-server-database-t472324/CS/SuppliersExample/Form1.cs#L149

    if (spreadsheetControl1.IsCellEditorActive)
        spreadsheetControl1.CloseCellEditor(DevExpress.XtraSpreadsheet.CellEditorEnterValueMode.Default);
}

VB.NET

how-to-use-custom-cell-editors-to-create-a-data-entry-form-t419595/VB/DevAVInvoicing/Form1.vb#L164

If spreadsheetControl1.IsCellEditorActive Then
    spreadsheetControl1.CloseCellEditor(CellEditorEnterValueMode.Cancel)
End If

how-to-use-spreadsheet-control-to-create-a-data-entry-form/VB/DataEntryFormSample/SpreadsheetBindingManager.vb#L145

'Update the data entry form when the current item changes.
DeactivateCellEditor(CellEditorEnterValueMode.ActiveCell)
UnsubscribePropertyChanged()

how-to-use-spreadsheetcontrol-to-create-a-data-entry-form/VB/WpfDataEntryFormSample/SpreadsheetBindingManager.vb#L142

Try
    DeactivateCellEditor(DevExpress.XtraSpreadsheet.CellEditorEnterValueMode.ActiveCell)
    UnsubscribePropertyChanged()

how-to-bind-a-spreadsheet-to-an-ms-sql-server-database-wpf-spreadsheet-t480591/VB/WpfSpreadsheet_BindToDataSource/MainWindow.xaml.vb#L148

If spreadsheetControl.IsCellEditorActive Then
    spreadsheetControl.CloseCellEditor(DevExpress.XtraSpreadsheet.CellEditorEnterValueMode.Default)
End If

how-to-bind-a-spreadsheet-to-an-ms-sql-server-database-t472324/VB/SuppliersExample/Form1.vb#L144

If spreadsheetControl1.IsCellEditorActive Then
    spreadsheetControl1.CloseCellEditor(DevExpress.XtraSpreadsheet.CellEditorEnterValueMode.Default)
End If