You can set the display of a sheet to display a particular row as the top row with the SheetView.TopRow property. Rows above that top row are not rendered in the client. Use the ScrollTo method to move the specified cell.

If the AllowPage property is False, the TopRow property takes effect. If AllowPage is True; then TopRow only takes effect the first time the page is loaded.

Using Code

1. Set the AllowPage property.
2. Set the TopRow property.

Example

This example code sets the top row.

FpSpread1.ActiveSheetView.RowCount = 20;
FpSpread1.ActiveSheetView.ColumnCount = 7;
FpSpread1.ActiveSheetView.AllowPage = false;
FpSpread1.ActiveSheetView.TopRow = 4;
FpSpread1.ActiveSheetView.IgnoreHiddenRowsWhenPaging = false;

FpSpread1.ActiveSheetView.AllowPage = False
FpSpread1.ActiveSheetView.ColumnCount = 7
FpSpread1.ActiveSheetView.RowCount = 20
FpSpread1.ActiveSheetView.IgnoreHiddenRowsWhenPaging = False
FpSpread1.ActiveSheetView.TopRow = 4