Spread 8.0 Documentation
Col2 Property
Support Options
ActiveX Reference > ActiveX Properties > Col2 Property

Glossary Item Box

Col2 Property


See Also    Example

Applies To

fpSpread control

Description

Sets or returns the last column of a block of cells on which an operation is to occur. This property is available at run time only.

Syntax

C++

long CSpreadSheet::GetCol2( );
void CSpreadSheet::SetCol2(long value);

Visual Basic

[form.]fpSpread.Col2[ = value&]

Remarks

The Col2 property is zero-based. The default value for the Col2 property is 0.

Use the Col2 property in conjunction with other properties to specify characteristics for a column or a block of cells, as listed in the following table, then set the properties that affect the designated cells, such as the BackColor property.

To specify . . . Set these properties . . .
A range of columns Col, Col2
A block of cells Col, Row, Col2, Row2, and (sometimes) BlockMode

For more information about how the Col2 property works with other properties, see Using Column and Row Properties.

This setting is applied to the current sheet setting unless you first set the Sheet property to specify the sheet for which you are setting the property.

Spread Designer

If you select a block of cells in the Spread Designer, the Col2 property is set for the last column and the Row2 property is set for the last row in the block. If you select multiple columns, the Col2 property is set for the last column.

For instructions about selecting portions of the sheet in the Spread Designer, see Selecting an Item in Spread Designer.

If you are using Learn Mode and work with a block of cells or multiple columns, the Col2 property is set in the generated code. For more information on Learn Mode and viewing code generated by the Spread Designer, see Using Learn Mode in Spread Designer.

Data Type

Long Integer

See Also

Working with a Range of Cells

BlockMode, Col, Row, Row2, Sheet properties

Copyright © GrapeCity, inc. All rights reserved.