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);
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
SSGetColor, SSSetColor, SSSetColorRange functions
ActiveX Correspondence
BackColorStyle property