'Declaration Public Enum VerticalPosition Inherits System.Enum
'Usage Dim instance As VerticalPosition
public enum VerticalPosition : System.Enum
'Declaration Public Enum VerticalPosition Inherits System.Enum
'Usage Dim instance As VerticalPosition
public enum VerticalPosition : System.Enum
| Member | Description |
|---|---|
| Bottom | Positions the cell or row to the bottom |
| Center | Positions the cell or row in the center |
| Nearest | Positions the cell or row to the nearest edge |
| Top | Positions the cell or row to the top |
For horizontal position of the cell or column, refer to the HorizontalPosition enumeration.
When using methods in FpSpread or SheetView class to move the cell into the display, if the specified cell is already visible, then the Nearest parameter does nothing If the specified cell is not visible then the sheet is scrolled just enough to make the specified cell visible. For example, setting the ActiveRowIndex and ActiveColumnIndex properties scrolls the sheet. Setting the active cell to a cell that is outside the displayed area scrolls the cell into view. Setting the active cell to a cell already in the view does nothing since the cell is already visible. The Nearest parameter only changes or moves the cells in the display if the specified cell is not displayed.
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);
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)
System.Object
System.ValueType
System.Enum
FarPoint.Win.Spread.VerticalPosition