Cancel Property (AutoFilteringColumnEventArgs)

Gets or sets whether to cancel the default processing of automatically filtering columns.

Syntax

Visual Basic
C#

'Declaration
 
Public Property Cancel As Boolean

'Usage
 
Dim instance As AutoFilteringColumnEventArgs
Dim value As Boolean
 
instance.Cancel = value
 
value = instance.Cancel

public bool Cancel {get; set;}

Property Value

Boolean: true if cancelled; false otherwise

Example

This example cancels the auto filtering for the specified column.

private void fpSpread1_AutoFilteringColumn(object sender, FarPoint.Win.Spread.AutoFilteringColumnEventArgs e) 
{ 
    if(e.Column <= 3)
             {
             e.Cancel = true;
             } 
}

Visual Basic

Private Sub FpSpread1_AutoFilteringColumn(ByVal sender As Object, ByVal e As
FarPoint.Win.Spread.AutoFilteringColumnEventArgs) Handles FpSpread1.AutoFilteringColumn
If e.Column <= 3 Then
e.Cancel = True
End If
End Sub

Requirements

Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8

Reference

AutoFilteringColumnEventArgs Class
AutoFilteringColumnEventArgs Members