Spread for ASP.NET 10 Product Documentation
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

  1. Set the AllowPage property.
  2. 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;
VB
Copy Code
FpSpread1.ActiveSheetView.AllowPage = False
FpSpread1.ActiveSheetView.ColumnCount = 7
FpSpread1.ActiveSheetView.RowCount = 20
FpSpread1.ActiveSheetView.IgnoreHiddenRowsWhenPaging = False
FpSpread1.ActiveSheetView.TopRow = 4
See Also

 

 


Copyright © GrapeCity, inc. All rights reserved.

Support Options | Documentation Feedback