TopRow Property
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
long CSpreadSheet::GetTopRow( );
void CSpreadSheet::SetTopRow(long value);
[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: |
Data Type
Long Integer
See Also
Designating the Top Row to Display
LeftCol, RowsFrozen, Sheet properties
TopLeftChange event
DLL Correspondence
SSGetTopLeftCell, SSShowCell functions