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

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

Customizing Grid Lines

SSGetGridColor, SSSetGridColor, SSSetSheet functions

ActiveX Correspondence

GridShowHoriz, GridShowVert, GridSolid properties