Spreadsheet Control for WPF - Assign Custom In-place Editors to Worksheet Cells

This example demonstrates how to use custom editors for in-place editing of cell content. Both predefined editors supported by the SpreadsheetControl for in-place editing (ComboBoxEdit, DateEdit, and CheckEdit) and the custom editor (SpinEdit) are used to edit cells located in the specific columns of a worksheet table.

Implementation Details

To assign an in-place editor of a predefined type to a specific cell range in a worksheet, use the Add method of the CustomCellInplaceEditorCollection collection, which stores the custom cell editors specified in a worksheet.

To assign your own custom editor to a cell, handle the SpreadsheetControl.CustomCellEdit event. This event fires when a user is about to start editing a cell and allows you to supply a custom in-place editor to the edited cell by setting a corresponding BaseEditSettings descendant to the event's EditSettings parameter.

Files to Review

• MainWindow.xaml (VB: MainWindow.xaml)
• MainWindow.xaml.cs (VB: MainWindow.xaml.vb)

Documentation

• Custom Cell In-place Editors