CustomCellInplaceEditorType Enum

Lists types of the custom in-place editors that can be assigned to cells in a worksheet.

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

Declaration

C#
VB.NET

public enum CustomCellInplaceEditorType

Public Enum CustomCellInplaceEditorType

Members

Name	Description
`CheckBox`	Specifies that a WinForms CheckEdit (or WPF CheckEdit) editor is used to edit cell content.
`ComboBox`	Specifies that a WinForms ComboBoxEdit (or WPF ComboBoxEdit) editor is used to edit cell content.
`DateEdit`	Specifies that a WinForms DateEdit (or WPF DateEdit) editor is used to edit cell content.
`Custom`	Specifies that a custom editor is used to edit cell content. Handle the WinForms Spreadsheet control’s CustomCellEdit (or WPF Spreadsheet control’s CustomCellEdit) event to assign a custom editor to a cell.

Related API Members

The following properties accept/return CustomCellInplaceEditorType values:

Library	Related API Members
WinForms Controls	CellEditorOpenedEventArgs.CustomEditorType
WPF Controls	CellEditorOpenedEventArgs.CustomEditorType
Office File API	CustomCellInplaceEditor.EditorType

Remarks

To assign a custom in-place editor of a particular type to a cell or cell range in a worksheet, use the CustomCellInplaceEditorCollection.Add method and pass the appropriate CustomCellInplaceEditorType enumeration value as a parameter. Information about cell in-place editors of the listed types is saved to a file in XLS, XLSX, XLSB, XLT, or XLTX format, so the corresponding editors can be successfully restored when you load a document into the Spreadsheet control again. If you use an in-place editor of the CustomCellInplaceEditorType.Custom type, you must handle the SpreadsheetControl.CustomCellEdit event to define a specific editor to be assigned to the required cells.

For an example on how to use custom editors for in-place editing of cell content, refer to the How to: Assign Custom In-place Editors to Worksheet Cells article.

The following code snippets (auto-collected from DevExpress Examples) contain references to the CustomCellInplaceEditorType 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#
VB.NET

how-to-use-custom-cell-editors-to-create-a-data-entry-form-t419595/CS/DevAVInvoicing/Form1.cs#L38

Worksheet customers = workbook.Worksheets["Customers"];
invoice.CustomCellInplaceEditors.Add(invoice["B10:C10"], CustomCellInplaceEditorType.ComboBox, ValueObject.FromRange(customers["A2:A21"]));

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

// Assign custom editors to worksheet cells.
sheet.CustomCellInplaceEditors.Add(sheet["D8"], CustomCellInplaceEditorType.Custom, "RegularHoursWorked");
sheet.CustomCellInplaceEditors.Add(sheet["D10"], CustomCellInplaceEditorType.Custom, "VacationHours");

how-to-use-spreadsheetcontrol-to-create-a-data-entry-form/CS/WpfDataEntryFormSample/MainWindow.xaml.cs#L34

//Assign custom editors to worksheet cells.
sheet.CustomCellInplaceEditors.Add(sheet["D8"], CustomCellInplaceEditorType.Custom, "RegularHoursWorked");
sheet.CustomCellInplaceEditors.Add(sheet["D10"], CustomCellInplaceEditorType.Custom, "VacationHours");

how-to-assign-custom-in-place-editors-to-worksheet-cells-wpf-spreadsheet-t385458/CS/WpfSpreadsheet_CustomCellEditors/MainWindow.xaml.cs#L34

CellRange dateEditRange = worksheet["Table[Order Date]"];
worksheet.CustomCellInplaceEditors.Add(dateEditRange, CustomCellInplaceEditorType.DateEdit);

how-to-assign-custom-in-place-editors-to-worksheet-cells-t385401/CS/Spreadsheet_CustomCellEditors/Form1.cs#L34

CellRange dateEditRange = worksheet["Table[Order Date]"];
worksheet.CustomCellInplaceEditors.Add(dateEditRange, CustomCellInplaceEditorType.DateEdit);

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

Dim customers As Worksheet = workbook.Worksheets("Customers")
invoice.CustomCellInplaceEditors.Add(invoice("B10:C10"), CustomCellInplaceEditorType.ComboBox, ValueObject.FromRange(customers("A2:A21")))

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

'Assign custom editors to worksheet cells.
sheet.CustomCellInplaceEditors.Add(sheet("D8"), CustomCellInplaceEditorType.Custom, "RegularHoursWorked")
sheet.CustomCellInplaceEditors.Add(sheet("D10"), CustomCellInplaceEditorType.Custom, "VacationHours")

how-to-use-spreadsheetcontrol-to-create-a-data-entry-form/VB/WpfDataEntryFormSample/MainWindow.xaml.vb#L32

'Assign custom editors to worksheet cells.
sheet.CustomCellInplaceEditors.Add(sheet("D8"), CustomCellInplaceEditorType.Custom, "RegularHoursWorked")
sheet.CustomCellInplaceEditors.Add(sheet("D10"), CustomCellInplaceEditorType.Custom, "VacationHours")

how-to-assign-custom-in-place-editors-to-worksheet-cells-wpf-spreadsheet-t385458/VB/WpfSpreadsheet_CustomCellEditors/MainWindow.xaml.vb#L31

Dim dateEditRange As CellRange = worksheet("Table[Order Date]")
worksheet.CustomCellInplaceEditors.Add(dateEditRange, CustomCellInplaceEditorType.DateEdit)

how-to-assign-custom-in-place-editors-to-worksheet-cells-t385401/VB/Spreadsheet_CustomCellEditors/Form1.vb#L31

Dim dateEditRange As CellRange = worksheet("Table[Order Date]")
worksheet.CustomCellInplaceEditors.Add(dateEditRange, CustomCellInplaceEditorType.DateEdit)

.NET Subscription

Common Tools

Controls

Tools

Controls and Extensions

Tools

Maintenance Mode

.NET Subscription

Common Tools

Controls

Tools

Controls and Extensions

Tools

Maintenance Mode

CustomCellInplaceEditorType Enum

Declaration

Members

Related API Members

Related API Members

Remarks

CustomCellInplaceEditorType Enum

Declaration

Members

Related API Members

Related API Members

Remarks

Related GitHub Examples