setCellFilter

creates a select filter

void setCellFilter(number rowId,number columnId,object filterObject);
rowIdnumberthe row id
columnIdnumberthe column id
filterObjectobjectfilter 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
If you have not checked yet, be sure to visit site of our main product Webix javascript web framework and page of web based spreadsheet product.