Setting the Top Row to Display

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

Set the AllowPage property.
Set the TopRow property.

Example

This example code sets the top row.

C#	Copy Code
FpSpread1.ActiveSheetView.RowCount = 20; FpSpread1.ActiveSheetView.ColumnCount = 7; FpSpread1.ActiveSheetView.AllowPage = false; FpSpread1.ActiveSheetView.TopRow = 4; FpSpread1.ActiveSheetView.IgnoreHiddenRowsWhenPaging = false;

Copy Code

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

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

Copy Code

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