Visual Basic (Declaration) | |
---|---|
Public Sub ShowCell( _ ByVal rowViewportIndex As Integer, _ ByVal columnViewportIndex As Integer, _ ByVal row As Integer, _ ByVal column As Integer, _ ByVal verticalPosition As VerticalPosition, _ ByVal horizontalPosition As HorizontalPosition _ ) |
Visual Basic (Usage) | Copy Code |
---|---|
Dim instance As SpreadView Dim rowViewportIndex As Integer Dim columnViewportIndex As Integer Dim row As Integer Dim column As Integer Dim verticalPosition As VerticalPosition Dim horizontalPosition As HorizontalPosition instance.ShowCell(rowViewportIndex, columnViewportIndex, row, column, verticalPosition, horizontalPosition) |
C# | |
---|---|
public void ShowCell( int rowViewportIndex, int columnViewportIndex, int row, int column, VerticalPosition verticalPosition, HorizontalPosition horizontalPosition ) |
Parameters
- rowViewportIndex
- Viewport row index
- columnViewportIndex
- Viewport column index
- row
- Row index in that viewport
- column
- Column index in that viewport
- verticalPosition
- New vertical position of cell
- horizontalPosition
- New horizontal position of cell
This method scrolls the spreadsheet so that the specified cell in the specified viewport appears in the specified position.
This method has no effect on the location or positioning of the active cell.
C# | Copy Code |
---|---|
FarPoint.Win.Spread.SpreadView sv = fpSpread1.GetRootWorkbook(); sv.AddViewport(0, 0); sv.ShowCell(1, 1, 6, 4, FarPoint.Win.Spread.VerticalPosition.Center, FarPoint.Win.Spread.HorizontalPosition.Center); |
VB.NET | Copy Code |
---|---|
Dim sv As FarPoint.Win.Spread.SpreadView = FpSpread1.GetRootWorkbook Dim hp As New FarPoint.Win.Spread.HorizontalPosition() Dim vp As New FarPoint.Win.Spread.VerticalPosition() sv.AddViewport(0, 0) sv.ShowCell(1, 1, 6, 4, vp.Center, hp.Center) |
Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8
Reference
SpreadView ClassSpreadView Members
ShowActiveCell Method
ShowColumn Method
ShowRow Method