setCellFilter

creates a select filter

void setCellFilter(number rowId,number columnId,object filterObject);

Parameters

rowId	number	the row id
columnId	number	the column id
filterObject	object	filter object.

Example

const values = {/* your custom values */}
// an array of options
$$("ss1").setCellFilter(1, 2, {
    options: ["", "Europe", "Asia", "America"],
    mode: "text",
    value: values
    lastRow: 3
});

Related samples

Filters

Details

The filter object can have the following properties:

options (string, array) - a range of cells references the values of which will be filtered or an array of filter options
mode (string) - filter mode. If not specified takes the type from the first not empty cell in the column
value (object) - sets a filter value. Call the filterSpreadSheet to invoke the filter.
lastRow (number) -a cell where the filtering will stop. If not specified, filtration will stop at the first empty cell that comes up.

You can pass null as third parameter. In this case the filter will be removed from the cell.