'DeclarationPublic Event AutoFilteredColumn As AutoFilteredColumnEventHandler
'UsageDim instance As FpSpread Dim handler As AutoFilteredColumnEventHandler AddHandler instance.AutoFilteredColumn, handler
public event AutoFilteredColumnEventHandler AutoFilteredColumn
The event handler receives an argument of type AutoFilteredColumnEventArgs containing data related to this event. The following AutoFilteredColumnEventArgs properties provide information specific to this event.
| Property | Description |
|---|---|
| Col | Gets or sets the filter column. |
| FilterString | Gets the filter string. |
| Spread | Gets or sets the Spread object. |
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)