Spread ASP.NET 14
Spread for ASP.NET 14 Product Documentation / Developer's Guide / Customizing the Appearance / Customizing the Appearance of Rows and Columns / Setting the Top Row to Display
In This Topic
    Setting the Top Row to Display
    In This Topic

    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