BeforeEditMode Event
Applies To
fpSpread control
Description
Occurs before edit mode begins.
Syntax
C++
afx_msg void OnBeforeEditModefpSpread(UINT, int, CWnd*, LPVOID);
Visual Basic
Event fpSpread_BeforeEditMode(ByVal Col As Long, ByVal Row As Long, ByVal UserAction As FPSpreadADO.BeforeEditModeActionConstants, CursorPos As Variant, Cancel As Variant)
Parameters
The following parameters are available:
Parameter | Description | ||
---|---|---|---|
Col | Column of cell going into edit mode | ||
Row | Row of cell going into edit mode | ||
UserAction | User's action | ||
Value | Constant | Description | |
0 | BeforeEditModeKeyboard | Keyboard action is changing edit mode | |
1 | BeforeEditModeMouse | Mouse action is changing edit mode | |
2 | BeforeEditModeCode | Code is changing edit mode | |
CursorPos | Cursor position when going into edit mode | ||
Value | Constant | Description | |
0 | BeforeEditModeCursorPosDefault | Default cursor position | |
1 | BeforeEditModeCursorPosSelectAll | Edit mode change selects all contents | |
2 | BeforeEditModeCursorPosBeginning | Edit mode change moves cursor to beginning of contents | |
3 | BeforeEditModeCursorPosEnd | Edit mode change moves cursor to end of contents | |
4 | BeforeEditModeCursorPosMouse | Edit mode change moves cursor to pointer position | |
5 | BeforeEditModeCursorPosDecimal | Edit mode change moves cursor to decimal portion of contents | |
Cancel | Cancels going into edit mode |
Remarks
The EditMode event occurs when edit mode begins and when a cell leaves edit mode.
Use the SheetSendingEvent property if you want to return the sheet for which this event occured.
See Also
Allowing Users To Sort By Columns
SheetSendingEvent property
EditMode event