The DevExpress ASP.NET MVC Spreadsheet provides provides a client API that you can use to assign a custom in-place editor to worksheet's cells to facilitate and validate user input. This API includes the following members:
- CellBeginEdit, CellEndEdit, CellCancelEdit - the events that occur when users start, finish, and cancel editing a cell
- ApplyCellEdit, CancelCellEdit - the methods that apply or cancel the value stored in the cell's editor
- SetCellEditorText - the method that specifies the cell's editor value while it is edited
- GetCellBounds - the method that receives the cell's bounds
In this demo, custom in-place editors are implemented for the DATE and WHERE columns using the DevExpress DateEdit and ComboBox extensions. The client code that renders the editor in place of the edited cell and passes the editor's value to the cell is placed in the ASPxClientSpreadsheetInplaceEditorHelper in a separate file. To assign a DevExpress editor as an in-place editor in your project you can copy the helper's code to your project and call the helper's AssignEditor method to apply the editor to the edited cell.