Spread 8.0 Documentation
SSGetBackColorStyle, SSSetBackColorStyle Functions
Support Options
DLL Reference > DLL Functions > SSGetBackColorStyle, SSSetBackColorStyle Functions

Glossary Item Box

SSGetBackColorStyle, SSSetBackColorStyle Functions


See Also    ActiveX

Applies To

fpSpread DLL control

Description

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

Syntax

C

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.

See Also

Customizing Grid Lines

SSGetColor, SSSetColor, SSSetColorRange functions

ActiveX Correspondence

BackColorStyle property

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