filterButtonVisible Method

Gets or sets whether the sheet column's filter button is displayed.

Syntax

Javascript (Usage)
Javascript (Specification)

var instance = new GcSpread.Sheets.RowFilterBase(range);
var returnValue; // Type: boolean
returnValue = instance.filterButtonVisible(col, value);

function filterButtonVisible( 
   col : number,
   value : boolean
) : boolean;

Parameters

col: The column index of the filter button.
value: Whether the filter button is displayed.

Return Value

Whether the sheet column's filter button is displayed.

Example

This example shows a filter button.

Javascript

//Create a custom condition.
function CustomFilter(){};
CustomFilter.prototype = {
    conditionType: "CustomFilter",
    evaluate: function (evaluator, row, col) {
        var value = evaluator.getValue(row, col);

        if(value !== null && value >= 10 && value <= 50){
            //Return True only when the following conditions are satisfied.
            // (1)Values are entered.
            // (2)Values are not lower than 10.
            // (3)Values are not greater than 50.
            return true;
        }else{
            return false;
        }
    }
};

    activeSheet.setValue(0, 0, 10);
    activeSheet.setValue(1, 0, 100);
    activeSheet.setValue(2, 0, 50);
    activeSheet.setValue(3, 0, 40);
    activeSheet.setValue(4, 0, 80);
    activeSheet.setValue(5, 0, 1);
    activeSheet.setValue(6, 0, 65);
    activeSheet.setValue(7, 0, 20);
    activeSheet.setValue(8, 0, 30);
    activeSheet.setValue(9, 0, 35);

    //Set a row Filter.
    var rowFilter = new GcSpread.Sheets.HideRowFilter(new GcSpread.Sheets.Range(0, 0, 7, 1));
    activeSheet.rowFilter(rowFilter);
    rowFilter.addFilterItem(0, new CustomFilter());
    rowFilter.filter(0);
rowFilter.filterButtonVisible(0, true);
alert(rowFilter.filterButtonVisible(0));

Reference

RowFilterBase type