Spread Windows Forms 13.0 Product Documentation
FarPoint.Win.Spread Assembly / FarPoint.Win.Spread Namespace / FpSpread Class / SelectionChanging Event
Example


In This Topic
    SelectionChanging Event
    In This Topic
    Occurs when the selection of cells on the sheet is changing.
    Syntax
    'Declaration
     
    Public Event SelectionChanging As SelectionChangingEventHandler
    'Usage
     
    Dim instance As FpSpread
    Dim handler As SelectionChangingEventHandler
     
    AddHandler instance.SelectionChanging, handler
    public event SelectionChangingEventHandler SelectionChanging
    Event Data

    The event handler receives an argument of type SelectionChangingEventArgs containing data related to this event. The following SelectionChangingEventArgs properties provide information specific to this event.

    PropertyDescription
    Gets or sets whether the selection action should be cancelled.  
    Gets the column index of the cell that contains the mouse pointer.  
    Gets the row index of the cell that contains the mouse pointer.  
    Gets the range of cells encompassing the selection.  
    Gets the view that contains the selection.  
    Remarks

    This event is raised by the OnSelectionChanging method when the sheet selection is changing.

    For more details on the individual event arguments, refer to SelectionChangingEventArgs members.

    This event is raised both when the user selects and deselects.

    Example
    This example raises the event.
    private void fpSpread1_SelectionChanging(object sender, FarPoint.Win.Spread.SelectionChangingEventArgs e)
    {
         FarPoint.Win.Spread.Model.CellRange cr;
         cr = e.View.Sheets[0].GetSelection(0);
         Label1.BackColor = Color.Blue;
         Label1.Text = "The first column in the selection is " + cr.Column + " and the first row is " + cr.Row;
    }
    Private Sub FpSpread1_SelectionChanging(ByVal sender As Object, ByVal e As FarPoint.Win.Spread.SelectionChangingEventArgs)
    Handles FpSpread1.SelectionChanging
         Dim cr As FarPoint.Win.Spread.Model.CellRange
         cr = e.View.Sheets(0).GetSelection(0)
         Label1.BackColor = Color.Blue
         Label1.Text = "The first column in the selection is " & cr.Column & " and the first row is " & cr.Row
    End Sub
    
    See Also