VScrollSpecial Property

Applies To

fpSpread control

Description

Sets or returns whether all the sheets display a special vertical scroll bar.

Syntax

C++

BOOL CSpreadSheet::GetVScrollSpecial( );
void CSpreadSheet::SetVScrollSpecial(BOOL value);

Visual Basic

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

Remarks

Although virtual mode improves performance, it prevents the default scroll bar on the fpSpread control from accurately representing the position of the currently displayed record in the database. You can display a customized scroll bar by setting the VScrollSpecial property.

The VScrollSpecial property displays a special, customized vertical scroll bar instead of the default Windows scroll bar. Instead of a scroll box, this scroll bar has arrows the user clicks to go to the first page or last page, the previous or next page, and the previous or next line. You can remove some of these arrows by setting the VScrollSpecialType property. The user can also click the area between the arrows in the special vertical scroll bars to advance up or down a page at a time.

This customized scroll bar works well with an fpSpread control in virtual mode (when the VirtualMode property is set to True). In virtual mode, the fpSpread control reads only as many database records as necessary to fill the list.

The default value for the VScrollSpecial property is False, which means the customized vertical scroll bar is not displayed.

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

Spread Designer

Choose the Book menu, then the Virtual Mode menu, and then choose the Use Special Scrollbar check box in the Virtual Scroll Bar group box in the Virtual Mode dialog box.

Data Type

Integer (Boolean)

DLL Correspondence

SSVScrollGetSpecial, SSVScrollSetSpecial functions