creates a select filter
rowId | number | the row id |
columnId | number | the column id |
filterObject | object | filter object |
page | string | optional, the name of the sheet |
const values = {/* your custom values */}
// an array of options
$$("ss1").setCellFilter(1, 2, {
options: ["", "Europe", "Asia", "America"],
mode: "text",
value: values,
lastRow: 3
}, "Sheet1");
The filter object can have the following properties:
It is possible to specify a range of cells references the values of which will be filtered or an array of filter options as a third parameter instead of the filter object:
$$("ssheet").setCellFilter(2,1, ["", "Europe", "Asia", "America"] );
// or
$$("ssheet").setCellFilter(2,2, "B3:B7");
You can pass null as a third parameter. In this case the filter will be removed from the cell.