Spread Windows Forms 13.0 Product Documentation
FarPoint.Win.Spread Assembly / FarPoint.Win.Spread Namespace / LeaveCellEventArgs Class / Cancel Property
Example


In This Topic
    Cancel Property (LeaveCellEventArgs)
    In This Topic
    Gets or sets whether to cancel the cell navigation.
    Syntax
    'Declaration
     
    Public Property Cancel As Boolean
    'Usage
     
    Dim instance As LeaveCellEventArgs
    Dim value As Boolean
     
    instance.Cancel = value
     
    value = instance.Cancel
    public bool Cancel {get; set;}

    Property Value

    Boolean: true if cancelled; false otherwise
    Example
    private void fpSpread1_LeaveCell(object sender, FarPoint.Win.Spread.LeaveCellEventArgs e)
    {
        string s;
        s = fpSpread1.ActiveSheet.Cells[e.Row, e.Column].Text;
        if (s == "")
        {
            e.Cancel = true;
        }
    }
    
    Private Sub FpSpread1_LeaveCell(ByVal sender As Object, ByVal e As FarPoint.Win.Spread.LeaveCellEventArgs) Handles FpSpread1.LeaveCell
        Dim s As String
        s = FpSpread1.ActiveSheet.Cells(e.Row, e.Column).Text
        If s = Nothing Then
            e.Cancel = True
        End If
    End Sub
    See Also