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
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.
See also
Back to top