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

Glossary Item Box

RemoveCellSpan Method


See Also    DLL    Example

Applies To

fpSpread control

Description

Removes the span from the range of cells that contain the specified anchor cell.

Syntax

C++

void CSpreadSheet::RemoveCellSpan(long lCol, long lRow);

Visual Basic

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

Spanning Cells

Sheet property

AddCellSpan, GetCellSpan methods

DLL Correspondence

SSRemoveCellSpan function

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