Spread Windows Forms 13.0 Product Documentation
FarPoint.Win.Spread Assembly / FarPoint.Win.Spread Namespace / HorizontalPosition Enumeration
Example Example

In This Topic
    HorizontalPosition Enumeration
    In This Topic
    Specifies the horizontal position of the cell or column in the component.
    Public Enum HorizontalPosition 
       Inherits System.Enum
    Dim instance As HorizontalPosition
    public enum HorizontalPosition : System.Enum 
    CenterPositions the cell or column in the center
    LeftPositions the cell or column to the left
    NearestPositions the cell or column to the nearest edge
    RightPositions the cell or column to the right

    For vertical position of the cell or row, refer to the VerticalPosition 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;
    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
    fpSpread1.ActiveSheet.SetActiveCell(15, 15)
    fpSpread1.ShowActiveCell(FarPoint.Win.Spread.VerticalPosition.Center, FarPoint.Win.Spread.HorizontalPosition.Center)
    Inheritance Hierarchy


    See Also