InsertCols Method

---

See Also    DLL    Example

Applies To

fpSpread control

Description

Inserts a column or columns before the specified column.

Syntax

void CSpreadSheet::InsertCols(long lCol, long lNumCols);

fpSpread1.InsertCols(ByVal lCol As Long, ByVal lNumCols As Long)

Parameters

The following parameters are available:

Parameter	Description
lCol	Column number of column before which to insert new column or columns (Value must be greater than 0.)
lNumCols	Number of columns to insert

Remarks

Call the InsertCols method to insert columns.

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.

Caution: Inserting columns does not increase the number of columns set by the MaxCols property. To avoid losing data, increase the value of the MaxCols property before inserting columns.

Call the InsertRows method to insert rows.

Return Type

None

See Also

MaxCols, Sheet properties

DeleteCols, InsertRows methods

DLL Correspondence

SSInsCol function