Syntax
| Visual Basic (Declaration) | |
|---|---|
Public Sub ShowActiveCell( _ ByVal verticalPosition As VerticalPosition, _ ByVal horizontalPosition As HorizontalPosition _ ) | |
| Visual Basic (Usage) |  Copy Code |
|---|---|
Dim instance As SpreadView Dim verticalPosition As VerticalPosition Dim horizontalPosition As HorizontalPosition instance.ShowActiveCell(verticalPosition, horizontalPosition) | |
| C# | |
|---|---|
public void ShowActiveCell( VerticalPosition verticalPosition, HorizontalPosition horizontalPosition ) | |
Parameters
- verticalPosition
- New vertical position of cell
- horizontalPosition
- New horizontal position of cell
Remarks
This method scrolls the spreadsheet so that the active cell appears in the specified position of the display. For example, you may wish to move the active cell to the center of the component display.
To set the active cell, refer to the SetActiveCell method.
Example
This example uses the ShowActiveCell method.
| C# | Copy Code |
|---|---|
FarPoint.Win.Spread.SpreadView sv = fpSpread1.GetRootWorkbook(); sv.AddViewport(0, 0); sv.ShowActiveCell(FarPoint.Win.Spread.VerticalPosition.Bottom, FarPoint.Win.Spread.HorizontalPosition.Right); | |
| VB.NET | Copy Code |
|---|---|
Dim sv As FarPoint.Win.Spread.SpreadView = FpSpread1.GetRootWorkbook sv.AddViewport(0, 0) sv.ShowActiveCell(FarPoint.Win.Spread.VerticalPosition.Bottom, FarPoint.Win.Spread.HorizontalPosition.Right) | |
Requirements
Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8
See Also
Reference
SpreadView ClassSpreadView Members
ShowCell Method
HorizontalPosition Enum
VerticalPosition Enum
SetActiveCell Method