MoveActiveOnFocus Property
Applies To
fpSpread control
Description
Sets or returns the location of the active cell when the user moves the focus to the control with the mouse.
Syntax
BOOL CSpreadSheet::GetMoveActiveOnFocus( );
void CSpreadSheet::SetMoveActiveOnFocus(BOOL value);
[form.]fpSpread.MoveActiveOnFocus[ = boolean%]
Remarks
The default value for the MoveActiveOnFocus property is True.
This setting is applied to the entire workbook, including all sheets in the control.
When the MoveActiveOnFocus property is set to True, the active cell is moved to the location of the pointer when the user moves the focus to the control with the mouse. When the MoveActiveOnFocus property is set to False, the active cell remains where it was before the user moved the focus.
If you set the MoveActiveOnFocus property to False and you move focus back to the control by clicking the left mouse button, the Click event does not fire and the active cell does not move.
Spread Designer
Choose the Book menu, then the Environment menu, select the Environment tab, and then choose the On Focus Set Cell to Cursor check box in the Book Settings dialog box.
In the Spread Designer the MoveActiveOnFocus property is temporarily reset to True when in design mode, to assist you in the design process. When you switch to run-time mode, the sheet behaves according to the setting you have chosen for this property.
Data Type
Integer (Boolean)
See Also
Preventing Active Cell Change on Focus
Click event
DLL Correspondence
SSGetBool (SSB_MOVEACTIVEONFOCUS), SSSetBool (SSB_MOVEACTIVEONFOCUS) functions