You can handle events of subeditors within a cell in the Spread component.

The subeditor has a SubEditorClosed event and a SubEditorOpening event. This allows you to know when the subeditor opens and closes.

The cell type brings up an editor when editing the cell. The editor control can be text based or graphics based. The editor control can drop-down lists, bring up pop-up dialogs, etc. This is known as the subeditor. The ISubEditor interface can be used to create a custom subeditor. The IEditor interface can be used to create a custom editor.

Existing editors can be used in cells. The following line of code uses the default date time cell formatting on cell (1,1):

[C#]

fpSpread1.Sheets[0].Cells[1, 1].Editor = new FarPoint.Win.Spread.CellType.DateTimeCellType();

[Visual Basic]

FpSpread1.Sheets(0).Cells(1,1).Editor = New FarPoint.Win.Spread.CellType.DateTimeCellType