Spread Windows Forms 13.0 Product Documentation
FarPoint.Win.Spread Assembly / FarPoint.Win.Spread Namespace / FpSpread Class / ShowColumn Method
Column index of the viewport that has this column
Column index to move
New position of the column
Example


In This Topic
    ShowColumn Method (FpSpread)
    In This Topic
    Moves a column of cells in the specified viewport to the specified position in the component.
    Syntax
    'Declaration
     
    Public Sub ShowColumn( _
       ByVal columnViewportIndex As Integer, _
       ByVal column As Integer, _
       ByVal horizontalPosition As HorizontalPosition _
    ) 
    'Usage
     
    Dim instance As FpSpread
    Dim columnViewportIndex As Integer
    Dim column As Integer
    Dim horizontalPosition As HorizontalPosition
     
    instance.ShowColumn(columnViewportIndex, column, horizontalPosition)
    public void ShowColumn( 
       int columnViewportIndex,
       int column,
       HorizontalPosition horizontalPosition
    )

    Parameters

    columnViewportIndex
    Column index of the viewport that has this column
    column
    Column index to move
    horizontalPosition
    New position of the column
    Remarks

    This method scrolls the spreadsheet so that the specified column in the specified viewport appears in the specified position.

    This method has no effect on the location or positioning of the active cell.

    Example
    This example moves the specified column in the specified viewport to the specified position.
    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.ShowColumn(0, 15, 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.AddViewport(0, 0)
    fpSpread1.ShowColumn(0, 15, FarPoint.Win.Spread.HorizontalPosition.Center)
    See Also