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.
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; |
VB |
Copy Code
|
---|---|
FpSpread1.ActiveSheetView.AllowPage = False FpSpread1.ActiveSheetView.ColumnCount = 7 FpSpread1.ActiveSheetView.RowCount = 20 FpSpread1.ActiveSheetView.IgnoreHiddenRowsWhenPaging = False FpSpread1.ActiveSheetView.TopRow = 4 |