Spread 8.0 Documentation
BeforeEditMode Event
Support Options
ActiveX Reference > ActiveX Events > BeforeEditMode Event

Glossary Item Box

BeforeEditMode Event


See Also    Example

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

© 2002-2014 ComponentOne, a division of GrapeCity. All Rights Reserved.