Spread 8.0 Documentation
ScrollBars Property
Support Options
ActiveX Reference > ActiveX Properties > ScrollBars Property

Glossary Item Box

ScrollBars Property


See Also    DLL    Example

Applies To

fpSpread control

Description

Sets or returns whether the control displays horizontal and vertical scroll bars.

Syntax

C++

long CSpreadSheet::GetScrollBars( );
void CSpreadSheet::SetScrollBars(long value);

Visual Basic

[form.]fpSpread.ScrollBars[ = setting%]

Remarks

The following settings are available:

Setting Description Constant
0 - None Does not display scroll bars ScrollBarsNone
1 - Horizontal Displays horizontal scroll bar ScrollBarsHorizontal
2 - Vertical Displays vertical scroll bar ScrollBarsVertical
3 - Both (Default) Displays horizontal and vertical scroll bars ScrollBarsBoth

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

If you set the ScrollBars property to a value other than 0 (None), you can customize the scroll bars as follows:

Spread Designer

Choose the Book menu, then the Scroll Bars menu, select the Scroll Bars tab, and then choose an option in the Display group box in the Book Display Settings dialog.

In the Spread Designer, the ScrollBars property is temporarily reset to 3 (Both) 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.

For more information about design mode and run-time mode, see Using Design Versus Run-Time Mode.

Data Type

Integer (Enumerated)

See Also

Using Design Versus Run-Time Mode
Specifying Whether Scroll Bars Are Displayed
Displaying the Special Vertical Scroll Bar

ScrollBarExtMode, ScrollBarMaxAlign, ScrollBarShowMax, ScrollBarTrack properties

DLL Correspondence

SSGetBool (SSB_HORZSCROLLBAR, SSB_VERTSCROLLBAR), SSSetBool (SSB_HORZSCROLLBAR, SSB_VERTSCROLLBAR) functions

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