returns the filter set in a cell

object getCellFilter(number row,number column);
rownumberthe row id
columnnumberthe column id
objectan object with a set of options and the IDs of the row and column (see the details)


// setting the cell filter
$$("ssheet").setCellFilter(2,1, ["", "Europe", "Asia", "America"]);
// getting the cell filter
$$("ssheet").getCellFilter(2,1); // -> {options: Array(4), row: 2, column: 1}


The returned object contains 3 properties:

  • options - (string/array) a string or an array with the filter option(s)
  • row - (number) the ID of the row
  • column - (number) the ID of the column
See also
Back to top