ScrollBarExtMode Property

Applies To

fpSpread control

Description

Sets or returns whether to display scroll bars at all times or only when needed.

Syntax

C++

BOOL CSpreadSheet::GetScrollBarExtMode( );
void CSpreadSheet::SetScrollBarExtMode(BOOL value);

Visual Basic

[form.]fpSpread.ScrollBarExtMode[ = boolean%]

Remarks

The default value for the ScrollBarExtMode property is False.

This setting is applied to the entire workbook, including all sheets in the control.

When the ScrollBarExtMode property is set to True, the application hides the scroll bars when the maximum number of rows or columns fit in the control boundaries. When the ScrollBarExtMode property is set to False, the application displays the scroll bars at all times.

The ScrollBarExtMode property does not have an effect unless the ScrollBars property is set to a value other than 0 (None).

Spread Designer

Choose the Book menu, then the Scroll Bars menu, select the Scroll Bars tab, and then choose the Display Only if Needed check box in the Book Display Settings dialog.

Data Type

Integer (Boolean)

DLL Correspondence

SSGetBool (SSB_SCROLLBAREXTMODE), SSSetBool (SSB_SCROLLBAREXTMODE) functions