SSGetBackColorStyle, SSSetBackColorStyle Functions

Applies To

fpSpread DLL control

Description

Set or return whether the background colors of cells overlap the grid lines.

Syntax

WORD SSGetBackColorStyle(HWND hWnd);

WORD SSSetBackColorStyle(HWND hWnd, WORD wStyle);

C++

WORD TSpread::GetBackColorStyle( );

WORD TSpread::SetBackColorStyle(WORD wStyle);

Parameters

The SSGetBackColorStyle function has the following parameter:

Parameter	Description
hWnd	Window handle of the fpSpread control

The SSSetBackColorStyle function has the following parameters:

Parameter	Description
hWnd	Window handle of the fpSpread control
wStyle	Style of the displayed color Use one of the following values:
	Description
	Hides the right and bottom sides of the cells' grid lines under the background color
	Constant: SS_BACKCOLORSTYLE_OVERGRID
	Displays complete grid lines
	Constant: SS_BACKCOLORSTYLE_UNDERGRID
	Hides the horizontal grid lines under the background color
	Constant: SS_BACKCOLORSTYLE_OVERHORZGRIDONLY
	Hides the vertical grid lines under the background color
	Constant: SS_BACKCOLORSTYLE_OVERVERTGRIDONLY

Remarks

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

When the SSSetBackColorStyle wStyle parameter is set to SS_BACKCOLORSTYLE_OVERGRID, the background color of cells overlaps the bottom and right sides of the surrounding grid lines, hiding those portions of the grid lines from view. When the parameter is set to SS_BACKCOLORSTYLE_UNDERGRID, all sides of the grid lines are displayed.

When the wStyle parameter is set to SS_BACKCOLORSTYLE_OVERHORZGRIDONLY, the background color of cells hides only the horizontal grid lines (the vertical grid lines are still displayed). When the parameter is set to SS_BACKCOLORSTYLE_OVERVERTGRIDONLY, the background color of cells hides only the vertical grid lines (the horizontal grid lines are still displayed).

Return Value

SSGetBackColorStyle: Current style setting.
SSSetBackColorStyle: Previous style setting.

ActiveX Correspondence

BackColorStyle property