FarPoint.Web.Spread Assembly > FarPoint.Web.Spread Namespace > SheetView Class : TopRow Property |
'Declaration Public Property TopRow As Integer
'Usage Dim instance As SheetView Dim value As Integer instance.TopRow = value value = instance.TopRow
public int TopRow {get; set;}
This property is available at run time only.
Set this property to a row index to position that row next to the top edge of the sheet. The row index is zero-based.
When the top displayed row changes, the TopRowChanged event occurs.
Positioning a row using this property does not affect the position of the active cell.
The IgnoreHiddenRowsWhenPaging property should be false when using the TopRow property.
FarPoint.Web.Spread.SheetView sv=FpSpread1.ActiveSheetView; FarPoint.Web.Spread.StyleInfo altrowstyle=new FarPoint.Web.Spread.StyleInfo(); FarPoint.Web.Spread.Model.DefaultSheetStyleModel altrowmodel=new FarPoint.Web.Spread.Model.DefaultSheetStyleModel(1000,7); sv.ColumnCount=7; sv.RowCount=1000; altrowstyle.BackColor=Color.LightCyan; altrowstyle.ForeColor=Color.Navy; altrowstyle.Font.Bold=true; altrowmodel.SetDirectAltRowInfo(1,altrowstyle); sv.StyleModel=altrowmodel; sv.TopRow=4;
Dim sv As FarPoint.Web.Spread.SheetView Dim altrowstyle As New FarPoint.Web.Spread.StyleInfo() Dim altrowmodel As New FarPoint.Web.Spread.Model.DefaultSheetStyleModel(1000,7) sv=FpSpread1.ActiveSheetView sv.ColumnCount=7 sv.RowCount=1000 altrowstyle.BackColor=Color.LightCyan altrowstyle.ForeColor=Color.Navy altrowstyle.Font.Bold=True altrowmodel.SetDirectAltRowInfo(1,altrowstyle) sv.StyleModel=altrowmodel sv.TopRow=4
Target Platforms: Windows 7, Windows 8, Windows Vista, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6