Spread Windows Forms 11.0 Product Documentation
Cancel Property (LeaveCellEventArgs)
Example 


FarPoint.Win.Spread Assembly > FarPoint.Win.Spread Namespace > LeaveCellEventArgs Class : Cancel Property
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

Reference

LeaveCellEventArgs Class
LeaveCellEventArgs Members