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

Glossary Item Box

TopRow Property


See Also    DLL    Example

Applies To

fpSpread control

Description

Sets or returns the row to position as the topmost row in the displayed sheet. This property is available at run time only.

Syntax

C++

long CSpreadSheet::GetTopRow( );
void CSpreadSheet::SetTopRow(long value);

Visual Basic

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

Remarks

Set the TopRow property to a row number to position that row next to the top edge of the fpSpread control.

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.

If you set the RowsFrozen property to a value other than 0, the value returned using the TopRow property will be the value of the topmost scrolling row.

When the topmost displayed row changes, the TopLeftChange event occurs.

Note: Positioning a row using the TopRow property does not affect the position of the active cell.

Use the LeftCol property to set or return the number of the column to position as the leftmost column in the displayed sheet.

Spread Designer

Choose the Sheet menu, then the Columns and Rows menu, select the Rows tab, and then choose or type a number in the Top Row spin box in the Settings-All Rows group box in the Column and Row Settings dialog box.

Notes:
  • Spread Designer displays the change only in run-time mode.
  • This setting is not preserved when you save your changes to a file or apply your changes to the selected control.

Data Type

Long Integer

See Also

Designating the Top Row to Display

LeftCol, RowsFrozen, Sheet properties

TopLeftChange event

DLL Correspondence

SSGetTopLeftCell, SSShowCell functions

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