SpreadJS 13
GC.Spread.Sheets.Filter Namespace / RowFilterBase type / openFilterDialog Method
The hit test information about the filter button.
In This Topic
    openFilterDialog Method
    In This Topic
    Opens the filter dialog when the user clicks the filter button.
    Syntax
    var instance = new GC.Spread.Sheets.Filter.RowFilterBase(range);
    var value; // Type: any
    value = instance.openFilterDialog(filterButtonHitInfo);
    function openFilterDialog( 
       filterButtonHitInfo : GC.Spread.Sheets.IFilterButtonHitInfo
    ) : any;

    Parameters

    filterButtonHitInfo
    The hit test information about the filter button.
    Example
    This example uses the openFilterDialog method.
    <!DOCTYPE html>
    <html>
    <head>
        <title>SpreadJS</title>
        <!--jQuery References-->
        <link href="./css/gc.spread.sheets.12.0.0.css" rel="stylesheet" type="text/css" />
    <script type="text/javascript" src="./scripts/gc.spread.sheets.all.12.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>
    See Also