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 the viewport
- columnViewportIndex
- Column index of the viewport
- row
- Row index of the cell
- column
- Column index of the cell cell
- verticalPosition
- New position (vertical coordinate) of the cell
- horizontalPosition
- New position (horizontal coordinate) of the 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 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8
Reference
FpSpread ClassFpSpread Members
HorizontalPosition Enum
VerticalPosition Enumeration