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 FpSpread 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
- Row index of viewport
- columnViewportIndex
- Column index of viewport
- row
- Index of row of cell
- column
- Index of column of cell
- verticalPosition
- New position (vertical coordinate) of cell
- horizontalPosition
- New position (horizontal coordinate) 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.
This example moves the specified cell in the specified viewport to the specified position.
C# | Copy Code |
---|---|
FarPoint.Win.Spread.FpSpread fpSpread1 = new FarPoint.Win.Spread.FpSpread(); FarPoint.Win.Spread.SheetView shv = new FarPoint.Win.Spread.SheetView(); fpSpread1.Location = new Point(10, 10); fpSpread1.Height = 200; fpSpread1.Width = 400; Controls.Add(fpSpread1); fpSpread1.Sheets.Add(shv); fpSpread1.AddViewport(0, 0); fpSpread1.ShowCell(0, 0, 15, 15, FarPoint.Win.Spread.VerticalPosition.Center, FarPoint.Win.Spread.HorizontalPosition.Center); |
Visual Basic | Copy Code |
---|---|
Dim fpSpread1 As New FarPoint.Win.Spread.FpSpread() Dim shv As New FarPoint.Win.Spread.SheetView() fpSpread1.Location = New Point(10, 10) fpSpread1.Height = 200 fpSpread1.Width = 400 Controls.Add(fpSpread1) fpSpread1.Sheets.Add(shv) fpSpread1.AddViewport(0, 0) fpSpread1.ShowCell(0, 0, 15, 15, FarPoint.Win.Spread.VerticalPosition.Center, FarPoint.Win.Spread.HorizontalPosition.Center) |
Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2
Reference
FpSpread ClassFpSpread Members
HorizontalPosition Enum
VerticalPosition Enumeration