Spread for ASP.NET 11 Product Documentation
AutoFilteredColumn
Spread for ASP.NET 11 Product Documentation > Client-Side Scripting Reference > Scripting Members > Events > AutoFilteredColumn

Occurs when the client receives the filtering result from the server.

Syntax

[Inline HTML]

<ELEMENT AutoFilteredColumn = "handler" ...>

[JavaScript]

FpSpread1.addEventListener("AutoFilteredColumn", handler, ...)

or

FpSpread1.onAutoFilteredColumn = handler

Arguments

event.col
Column index to filter
event.filterString
String to be filtered by
event.spread
Spread that raises the event

Return Type

None

Remarks

This event is triggered when 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).

Example

This example JavaScript code maps the event for the Spread on the client side.

JavaScript
Copy Code
<script lang="javascript" type="text/javascript">
    window.onload = function () {
      var spread1 = document.getElementById("<%=FpSpread1.ClientID %>");
      if (document.all) {
// IE
if (spread1.addEventListener) {
// IE9
spread1.addEventListener("AutoFilteredColumn", autofilter, false);
} else {
// Other versions of IE and IE9 quirks mode (no doctype set)
spread1.onAutoFilteredColumn = autofilter;
}
}
else {
// Firefox
spread1.addEventListener("AutoFilteredColumn", autofilter, false);
      }
      }
    
    function autofilter(event) {
      alert(event.filterString);
    }
</script>
See Also