ScrollBars Property
Applies To
fpSpread control
Description
Sets or returns whether the control displays horizontal and vertical scroll bars.
Syntax
long CSpreadSheet::GetScrollBars( );
void CSpreadSheet::SetScrollBars(long value);
[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:
- Specify that the scroll bars are only displayed when needed by setting the ScrollBarExtMode property.
- Specify whether the user can use the scroll bars to scroll through all the columns and rows by setting the ScrollBarShowMax property.
- Specify whether the scroll box follows pointer movement using the ScrollBarTrack property.
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