Spread Windows Forms 13.0 Product Documentation
FarPoint.Win.Spread Assembly / FarPoint.Win.Spread Namespace / DragFillBlockCompletedEventArgs Class / ColumnEnd Property
Example


In This Topic
    ColumnEnd Property (DragFillBlockCompletedEventArgs)
    In This Topic
    Gets the column index of the bottom right cell of the range being used for the fill.
    Syntax
    'Declaration
     
    Public ReadOnly Property ColumnEnd As Integer
    'Usage
     
    Dim instance As DragFillBlockCompletedEventArgs
    Dim value As Integer
     
    value = instance.ColumnEnd
    public int ColumnEnd {get;}

    Property Value

    Integer index of the ending column
    Remarks
    This example changes the background color of the cells in the dragged columns.
    Example
    This example changes the background color of the columns in the drag.
    private void fpSpread1DragFillBlockCompleted(object sender, FarPoint.Win.Spread.DragFillBlockCompletedEventArgs e) 
    {
         fpSpread1.ActiveSheet.Columns(e.ColumnBegin, e.ColumnEnd).BackColor = Color.Yellow;
    }
    
    Private Sub FpSpread1DragFillBlockCompleted(ByVal sender As Object, ByVal e As FarPoint.Win.Spread.DragFillBlockCompletedEventArgs)
    Handles FpSpread1.DragFillBlockCompleted
         FpSpread1.ActiveSheet.Columns(e.ColumnBegin, e.ColumnEnd).BackColor = Color.Yellow
    End Sub
    See Also