Spread 8.0 Documentation
SSGetGridType, SSSetGridType Functions
Support Options
DLL Reference > DLL Functions > SSGetGridType, SSSetGridType Functions

Glossary Item Box

SSGetGridType, SSSetGridType Functions


See Also    ActiveX

Applies To

fpSpread DLL control

Description

Set or return whether horizontal and vertical grid lines are displayed, and the style of the grid lines displayed.

Syntax

C

WORD SSGetGridType(HWND hWnd);

WORD SSSetGridType(HWND hWnd, WORD wGridType);

C++

WORD TSpread::GetGridType(void);

WORD TSpread::SetGridType(WORD wGridType);

Parameters

The SSGetGridType function has the following parameter:

Parameter Description
hWnd Window handle of the fpSpread control

The SSSetGridType function has the following parameters:

Parameter Description
hWnd Window handle of the fpSpread control
wGridType Grid type to display
Combine any of the following values with the (|) OR operator:
Constant Description
SS_GRID_HORIZONTAL Displays horizontal grid lines
SS_GRID_VERTICAL Displays vertical grid lines
SS_GRID_SOLID Displays solid grid lines
(If this flag is omitted, the grid lines are dotted.)

Remarks

This function is applied to the current sheet setting unless you first call the SSSetSheet function to specify the sheet for which you are calling this function.

By default, the grid is displayed with dotted vertical and horizontal lines. Use the SSSetGridType function to change the lines to solid lines and to display only horizontal or vertical lines, or no lines.

If you use a solid grid, set the grid color to gray using the SSSetGridColor function to improve the appearance.

Return Value

Previous grid type (any combination of the values listed for the wGridType parameter).

See Also

Customizing Grid Lines

SSGetGridColor, SSSetGridColor, SSSetSheet functions

ActiveX Correspondence

GridShowHoriz, GridShowVert, GridSolid properties

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