Visual Basic (Declaration) | |
---|---|
Public Sub ShowActiveCell( _ ByVal verticalPosition As VerticalPosition, _ ByVal horizontalPosition As HorizontalPosition _ ) |
Visual Basic (Usage) | Copy Code |
---|---|
Dim instance As FpSpread Dim verticalPosition As VerticalPosition Dim horizontalPosition As HorizontalPosition instance.ShowActiveCell(verticalPosition, horizontalPosition) |
C# | |
---|---|
public void ShowActiveCell( VerticalPosition verticalPosition, HorizontalPosition horizontalPosition ) |
Parameters
- verticalPosition
- New position (vertical coordinate) of active cell
- horizontalPosition
- New position (horizontal coordinate) of active cell
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.
This example moves the active cell 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.ActiveSheet.SetActiveCell(15, 15); fpSpread1.ShowActiveCell(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.ActiveSheet.SetActiveCell(15, 15) fpSpread1.ShowActiveCell(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 Enum
User-Task Documentation
Customizing the Position in the DisplayWorking with the Active Cell