Spread for ASP.NET 18 Product Documentation

AutoFilteredColumn

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

Syntax

[Inline HTML]

<ELEMENT AutoFilteredColumn = "handler" ...>

[JavaScript]

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

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.

<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>