Spread ASP.NET 18
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread Namespace / FpSpread Class / AutoFilteringColumn Event
Example


In This Topic
    AutoFilteringColumn Event
    In This Topic
    Occurs when the user is filtering.
    Syntax
    'Declaration
 

    Public Event AutoFilteringColumn As AutoFilteringColumnEventHandler
    'Usage
 

    Dim instance As FpSpread
Dim handler As AutoFilteringColumnEventHandler
 
AddHandler instance.AutoFilteringColumn, handler
    public event AutoFilteringColumnEventHandler AutoFilteringColumn
    Event Data

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

    PropertyDescription
    CancelGets or sets whether to cancel the filtering.  
    ColGets or sets the filter column. (Inherited from FarPoint.Web.Spread.AutoFilteredColumnEventArgs)
    FilterStringGets the filter string. (Inherited from FarPoint.Web.Spread.AutoFilteredColumnEventArgs)
    SpreadGets or sets the Spread object. (Inherited from FarPoint.Web.Spread.AutoFilteredColumnEventArgs)
    Remarks

    The client-side AutoFilteringColumn event is fired before the client sends the filtering request to the server . If the filtering request is not canceled, the client will send the filtering request to the server.

    The server-side AutoFilteringColumn event is fired before the filtering operation is executed.  If the filtering is not canceled on the server, the server-side AutoFilteredColumn event will be fired after the filtering operation has been executed.

    The client-side AutoFilteredColumn event will be fired after the client receives the filtering result from the server.

    If the sheetview RowFilter property is null, the following events will not be fired:
    AutoFilteringColumn event (server-side), AutoFilteredColumn event (server-side), and the AutoFilteredColumn event (client-side).

    If the columns are filtered with code, for example (FpSpread1.ActiveSheetView.AutoFilterColumn(1,”apple”)), then the client-side AutoFilteringColumn event will not be fired. The other three events are fired in the following order:

    AutoFilteringColumn (server-side)
    AutoFilteredColumn (server-side)
    AutoFilteredColumn (client-side)

    Example
    This example uses the AutoFilteringColumn event. 
    
	
    
	
    
		
    
	
    
	

    

    
            
            
            
            
            
    See Also
    Reference
    FpSpread Class

    FpSpread Members