openFilterDialog Method

Opens the filter dialog when the user clicks the filter button.

Syntax

Javascript (Usage)
Javascript (Specification)

var instance = new GC.Spread.Sheets.Filter.RowFilterBase(range);
var value; // Type: any
value = instance.openFilterDialog(filterButtonHitInfo);

function openFilterDialog( 
   filterButtonHitInfo : object
) : any;

Parameters

filterButtonHitInfo: The hit test information about the filter button.

Example

This example uses the openFilterDialog method.

Javascript

<!DOCTYPE html>
<html>
<head>
    <title>SpreadJS</title>
    <!--jQuery References-->
    <link href="./css/gc.spread.sheets.11.0.0.css" rel="stylesheet" type="text/css" />
<script type="text/javascript" src="./scripts/gc.spread.sheets.all.11.0.0.min.js"></script>
<script src="http://code.jquery.com/jquery-2.0.2.js" type="text/javascript"></script>

    <script type="text/javascript">
        $(document).ready(function () {
            var spread = new GC.Spread.Sheets.Workbook($("#ss").get(0));
            var sheet = spread.getActiveSheet();
            spread.suspendPaint();
            for (var i = 0; i < 10; i++) {
                sheet.setValue(i, 0, i);
            }
            sheet.rowFilter(new GC.Spread.Sheets.Filter.HideRowFilter(new GC.Spread.Sheets.Range(1, 0, 10, 1)));
            spread.resumePaint();
            $("#btn").click(function () {
                sheet.rowFilter().openFilterDialog(sheet.hitTest(97, 30).filterButtonHitInfo);
            })
        });
    </script>
</head>
<body>
    <div id="ss" style="width:100%;height:500px;border:1px solid gray"></div>
    <input type="button" id="btn" value="Click" />
</body>
</html>

Reference

RowFilterBase type