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

Glossary Item Box

StartingRowNumber Property


See Also    DLL    Example

Applies To

fpSpread control

Description

Sets or returns the number displayed in the header of the first row.

Syntax

C++

long CSpreadSheet::GetStartingRowNumber( );
void CSpreadSheet::SetStartingRowNumber(long value);

Visual Basic

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

Remarks

The default value for the StartingRowNumber property is 1.

The StartingRowNumber property changes the number for the first row for display purposes only. Therefore, for cell references, use the row numbers as if the numbering started at 1 or A. The sheet displays subsequent row 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 column number displayed for the first column by setting the StartingColNumber property.

Spread Designer

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

Data Type

Long Integer

See Also

Changing Column and Row Numbering

Sheet, StartingColNumber properties

DLL Correspondence

SSGetStartingNumbers, SSSetStartingNumbers functions

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