Spread 8.0 Documentation
GetCellSpan Method
Support Options
ActiveX Reference > ActiveX Methods > GetCellSpan Method

Glossary Item Box

GetCellSpan Method


See Also    DLL    Example

Applies To

fpSpread 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

C++

long CSpreadSheet::GetCellSpan(long lCol, long lRow, VARIANT* pvColAnchor, VARIANT* pvRowAnchor, VARIANT* pvNumCols, VARIANT* pvNumRows);

Visual Basic

fpSpread1.GetCellSpan(ByVal lCol As Long, ByVal lRow As Long, pvColAnchor As Variant, pvRowAnchor As Variant, pvNumCols As Variant, pvNumRows As Variant) As GetCellSpanConstants

Parameters

The following parameters are available:

Parameter Description
lCol Column number of cell about which to return span information
lRow Row number of cell about which to return span information
pvColAnchor Column number of anchor cell for span
pvRowAnchor Row number of anchor cell for span
pvNumCols Number of columns in the span range
pvNumRows Number of rows in the span range

Remarks

Call the GetCellSpan method 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.

This method is called for the current sheet setting unless you first set the Sheet property to specify the sheet with which you want to work.

Create a span of cells by calling the AddCellSpan method. Remove a span of cells from the sheet by calling the RemoveCellSpan method.

Return Type

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

Value Constant Description
0 GetCellSpanNo Cell is not in a span
1 GetCellSpanYes Cell is in a span
2 GetCellSpanAnchor Cell is the anchor cell for the span

See Also

Spanning Cells

Sheet property

AddCellSpan, RemoveCellSpan methods

DLL Correspondence

SSGetCellSpan function

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