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

Glossary Item Box

InsertCols Method


See Also    DLL    Example

Applies To

fpSpread control

Description

Inserts a column or columns before the specified column.

Syntax

C++

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

Visual Basic

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

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