SSGetGridType, SSSetGridType Functions
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
WORD SSGetGridType(HWND hWnd);
WORD SSSetGridType(HWND hWnd, WORD wGridType);
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
SSGetGridColor, SSSetGridColor, SSSetSheet functions
ActiveX Correspondence
GridShowHoriz, GridShowVert, GridSolid properties