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

Glossary Item Box

StartingColNumber Property


See Also    DLL    Example

Applies To

fpSpread control

Description

Sets or returns the number displayed in the first column.

Syntax

C++

long CSpreadSheet::GetStartingColNumber( );
void CSpreadSheet::SetStartingColNumber(long value);

Visual Basic

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

Remarks

The default value for the StartingColNumber property is 1.

The StartingColNumber property changes the number for the first column for display purposes only. Therefore, for cell references, use the column numbers as if the numbering started at 1 or A. The sheet displays subsequent column numbers sequentially.

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.

You can change the starting row number displayed for the first row by setting the StartingRowNumber property.

Spread Designer

Choose the Sheet menu, then the Headers menu, and then the General menu, select the Columns tab, and then choose or type a number in the Start Column Number spin box in the Header Settings dialog box.

Data Type

Long Integer

See Also

Changing Column and Row Numbering

Sheet, StartingRowNumber properties

DLL Correspondence

SSGetStartingNumbers, SSSetStartingNumbers functions

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