FarPoint.Win.Spread
ToIndex Property
See Also  Example
FarPoint.Win.Spread Assembly > FarPoint.Win.Spread Namespace > DragMoveCompletedEventArgs Class : ToIndex Property


Gets the column or row index of the destination of the drag

Syntax

Visual Basic (Declaration) 
Public ReadOnly Property ToIndex As Integer
Visual Basic (Usage)Copy Code
Dim instance As DragMoveCompletedEventArgs
Dim value As Integer
 
value = instance.ToIndex
C# 
public int ToIndex {get;}

Return Value

Integer index of the column of the destination

Example

This example allows the user to move columns.
C#Copy Code
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;
}
Visual BasicCopy Code
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