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

C++

BOOL CSpreadSheet::GetMoveActiveOnFocus( );
void CSpreadSheet::SetMoveActiveOnFocus(BOOL value);

Visual Basic

[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)

DLL Correspondence

SSGetBool (SSB_MOVEACTIVEONFOCUS), SSSetBool (SSB_MOVEACTIVEONFOCUS) functions