RemoveCellSpan Method
Applies To
fpSpread control
Description
Removes the span from the range of cells that contain the specified anchor cell.
Syntax
void CSpreadSheet::RemoveCellSpan(long lCol, long lRow);
fpSpread1.RemoveCellSpan(ByVal lCol As Long, ByVal lRow As Long)
Parameters
The following parameters are available:
| Parameter | Description |
|---|---|
| lCol | Column number of anchor cell of span to remove |
| lRow | Row number of anchor cell of span to remove |
Remarks
You can remove a span range by calling this method, specifying the anchor cell of the span range to remove the range.
When you remove a span range, the data that was previously in each of the cells in the span is re-displayed in the cell. The data was never removed from the cell, but simply hidden by the span range. Also, the cell types of the cells combined in the span are not changed.
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. Return whether a cell is in a span range, and the size of the range if it is in one, by calling the GetCellSpan method.
Spread Designer
The Span dialog box.
Return Type
None
See Also
Sheet property
AddCellSpan, GetCellSpan methods
DLL Correspondence
SSRemoveCellSpan function