getCellEditor

returns the editor set in a cell

object getCellEditor(number row,number column, [string page] );

row

numberthe row id column

numberthe column id page

stringoptional, the name of the sheet

object

an object with editor type and a set of options (see the details)

Example

// setting a cell editor
$$("ss1").setCellEditor(8, 1, {
    editor: "ss_richselect", 
    options: ["One","Two","Three"]
    }, "Sheet1");
 
// getting the cell editor
$$("ss1").getCellEditor(8, 1, "Sheet1"); 
// -> { editor:"ss_richselect", options: ["One","Two","Three"] }

Related samples

Dropdowns

Details

The returned object contains two properties:

editor - (string) the type of the editor
options - (string,array) an array of editor options or a range of cell references

{ editor:"ss_richselect", options:["One","Two","Three"] }
 
// or
{ editor:"ss_richselect", options:"B3:B7" }