onAutoFilteredColumn

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

Syntax

[Inline HTML]

[Event Property]

FpSpread1.onAutoFilteredColumn = handler

[Named Script]

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 language="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() { alert(event.filterString); } </SCRIPT>

JavaScript

Copy Code

<script language="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() {
      alert(event.filterString);
    } 
</SCRIPT>