Spread Windows Forms 12.0 Product Documentation
Cancel Property (AdvanceEventArgs)

FarPoint.Win.Spread Assembly > FarPoint.Win.Spread Namespace > AdvanceEventArgs Class : Cancel Property
Gets or sets whether to cancel default processing.
Public Property Cancel As Boolean
Dim instance As AdvanceEventArgs
Dim value As Boolean
instance.Cancel = value
value = instance.Cancel
public bool Cancel {get; set;}

Property Value

Boolean: true if cancelled; false otherwise
By default, focus will not move to the previous or next control. Set Cancel to false or set the focus to move to the next control.
This example shows the use of the property by popping up a message box if the user clicks in the last cell of the spreadsheet and presses the Tab key to move to the next control on the form.
private void fpSpread1_Advance(object sender, FarPoint.Win.Spread.AdvanceEventArgs e)
    if (e.AdvanceNext == true)
        MessageBox.Show("We're going to the next control!!");
        e.Cancel = false;
Private Sub FpSpread1_Advance(ByVal sender As Object, ByVal e As FarPoint.Win.Spread.AdvanceEventArgs) Handles FpSpread1.Advance
    If e.AdvanceNext = True Then
          MessageBox.Show("We're going to the next control!!")
          e.Cancel = False
    End If
End Sub
See Also


AdvanceEventArgs Class
AdvanceEventArgs Members