SSGetCellSpan Function

---

See Also    ActiveX

Applies To

fpSpread DLL control

Description

Returns whether the specified cell is in a span of cells, and returns the anchor cell and the number of cells in the span range.

Syntax

WORD SSGetCellSpan(HWND hWnd, SS_COORD lCol, SS_COORD lRow, LPSS_COORD lplColAnchor, LPSS_COORD lplRowAnchor, LPSS_COORD lplNumCols, LPSS_COORD lplNumRows);

WORD TSpread::GetCellSpan(SS_COORD lCol, SS_COORD lRow, LPSS_COORD lplColAnchor, LPSS_COORD lplRowAnchor, LPSS_COORD lplNumCols, LPSS_COORD lplNumRows);

Parameters

This function has the following parameters:

Parameter	Description
hWnd	Window handle of the fpSpread control
lCol	Column number of cell about which to return span information
lRow	Row number of cell about which to return span information
lplColAnchor	Column number of anchor cell for span
lplRowAnchor	Row number of anchor cell for span
plNumCols	Number of columns in the span range
plNumRows	Number of rows in the span range

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.

Call the SSGetCellSpan function to return whether a cell is in a span of cells, and if it is in a span of cells, the column and row number of the anchor cell and the number of columns and rows in the span range.

Create a span of cells by calling the SSAddCellSpan function. Remove a span of cells by calling the SSRemoveCellSpan function.

Return Value

Returns one of the following values to provide information about the specified cell:

Value	Constant	Description
0	SS_SPAN_NO	Cell is not in a span
1	SS_SPAN_YES	Cell is in a span
2	SS_SPAN_ANCHOR	Cell is the anchor cell for the span

See Also

Spanning Cells

SSAddCellSpan, SSRemoveCellSpan, SSSetSheet functions

ActiveX Correspondence

GetCellSpan method