Spread Windows Forms 17
GrapeCity.Spreadsheet Assembly / GrapeCity.Spreadsheet Namespace / Worksheet Class / Swap Method
Row index of starting position of range to move
Column index of starting position of range to move
Row index of starting position of destination
Column index of starting position of destination
Number of rows in range
Number of columns in range
The options indicates which data type will be performed.


In This Topic
    Swap Method (Worksheet)
    In This Topic
    Swaps the specified ranges of cells.
    Syntax
    'Declaration
     
    
    Public Function Swap( _
       ByVal row As Integer, _
       ByVal column As Integer, _
       ByVal toRow As Integer, _
       ByVal toColumn As Integer, _
       ByVal rowCount As Integer, _
       ByVal columnCount As Integer, _
       ByVal options As ManipulationOptions _
    ) As ActionResult(Of Object)
    'Usage
     
    
    Dim instance As Worksheet
    Dim row As Integer
    Dim column As Integer
    Dim toRow As Integer
    Dim toColumn As Integer
    Dim rowCount As Integer
    Dim columnCount As Integer
    Dim options As ManipulationOptions
    Dim value As ActionResult(Of Object)
     
    value = instance.Swap(row, column, toRow, toColumn, rowCount, columnCount, options)

    Parameters

    row
    Row index of starting position of range to move
    column
    Column index of starting position of range to move
    toRow
    Row index of starting position of destination
    toColumn
    Column index of starting position of destination
    rowCount
    Number of rows in range
    columnCount
    Number of columns in range
    options
    The options indicates which data type will be performed.

    Return Value

    true if the cell range is swapped successful, false otherwise.
    See Also