getCellFilter

returns the filter set in a cell

object getCellFilter(number row,number column, [string page] );
row
numberthe row id column
numberthe column id page
stringoptional, the name of the sheet
objectan object with a set of options and the IDs of the row and column (see the details)

Example

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

Details

The returned object contains 3 properties:

See also
  • API
  • Back to top
    Join Our Forum
    We've retired comments here. Visit our forum for faster technical support, connect with other developers, and share your feedback there.