Spread Windows Forms 13.0 Product Documentation
FarPoint.Win.Spread Assembly / FarPoint.Win.Spread Namespace / DragMoveCompletedEventArgs Class / ToIndex Property
Example


In This Topic
    ToIndex Property
    In This Topic
    Gets the column or row index of the destination of the drag
    Syntax
    'Declaration
     
    Public ReadOnly Property ToIndex As Integer
    'Usage
     
    Dim instance As DragMoveCompletedEventArgs
    Dim value As Integer
     
    value = instance.ToIndex
    public int ToIndex {get;}

    Property Value

    Integer index of the column of the destination
    Example
    This example allows the user to move columns.
    fpSpread1.AllowColumnMove = true;
    
    fpSpread1.ColumnDragMoveCompleted += new FarPoint.Win.Spread.DragMoveCompletedEventHandler(fpSpread1ColumnDragMoveCompleted);
    
    private void fpSpread1ColumnDragMoveCompleted(object sender, FarPoint.Win.Spread.DragMoveCompletedEventArgs e)
    {
          e.View.Sheets[e.View.ActiveSheetIndex].Columns[e.FromIndex].BackColor = Color.Yellow;
          e.View.Sheets[e.View.ActiveSheetIndex].Columns[e.ToIndex].BackColor = Color.Yellow;
    }
    
    FpSpread1.AllowColumnMove = True
    
    Dim eh As FarPoint.Win.Spread.DragMoveCompletedEventHandler = AddressOf Fpspread1ColumnDragMoveCompleted
    AddHandler FpSpread1.ColumnDragMoveCompleted, eh
    
    Private Sub Fpspread1ColumnDragMoveCompleted(ByVal sender As Object, ByVal e As FarPoint.Win.Spread.DragMoveCompletedEventArgs)
    Handles FpSpread1.ColumnDragMoveCompleted
          e.View.Sheets(e.View.ActiveSheetIndex).Columns(e.FromIndex).BackColor = Color.Yellow
          e.View.Sheets(e.View.ActiveSheetIndex).Columns(e.ToIndex).BackColor = Color.Yellow
    End Sub
    See Also