Spread ASP.NET 14
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread Namespace / SheetView Class / MoveColumn Method
Column index at which to start the move (first column)
Number of columns to move
Destination before which to copy the range of columns
Example


In This Topic
    MoveColumn Method (SheetView)
    In This Topic
    Moves the column or columns to a specified location.
    Syntax
    'Declaration
     
    Public Sub MoveColumn( _
       ByVal column As Integer, _
       ByVal count As Integer, _
       ByVal toColumn As Integer _
    ) 
    'Usage
     
    Dim instance As SheetView
    Dim column As Integer
    Dim count As Integer
    Dim toColumn As Integer
     
    instance.MoveColumn(column, count, toColumn)
    public void MoveColumn( 
       int column,
       int count,
       int toColumn
    )

    Parameters

    column
    Column index at which to start the move (first column)
    count
    Number of columns to move
    toColumn
    Destination before which to copy the range of columns
    Remarks

    Use this method to move the data and formatting in a range of columns in the sheet. It cuts and moves all contents to the column in front of the specified destination column.

    Moving a range of columns with this method moves the data and formatting, including formulas and cell notes.

    Moving a range of columns with this method cuts the columns and pastes them in front of the specified location. The pasted columns are inserted before the specified column. For example, moving columns B and C to column F cuts columns B and C and pastes them in front of column F.

    Example
    This example moves two columns.
    FarPoint.Web.Spread.SheetView sv;
    sv = FpSpread1.ActiveSheetView;
    sv.SetValue(0, 0, 1);
    sv.SetValue(0, 1, 2);
    sv.SetValue(0, 2, 3);
    sv.SetValue(0, 3, 4);
    
    sv.MoveColumn(0, 1, 2);
    
    Dim sv As FarPoint.Web.Spread.SheetView
    sv = FpSpread1.ActiveSheetView
    sv.SetValue(0, 0, "One")
    sv.SetValue(0, 1, "Two")
    sv.SetValue(0, 2, "Three")
    sv.SetValue(0, 3, "Four")
    
    sv.MoveColumn(0, 1, 2)
    
    See Also