setCellEditor

creates an editor in a cell

void setCellEditor(number rowId,number columnId,object editorObject, [string page] );

rowId

numberthe row id columnId

numberthe column id editorObject

objectan object with editor type and options (for richselect) pagestringoptional, the name of the sheet

Example

$$("ss1").setCellEditor(8, 1, { 
    editor: "ss_richselect", 
    options: ["One", "Two", "Three"] 
   }, "Sheet1");
 
// or
$$("ss1").setCellEditor(8, 2, { 
    editor:"ss_richselect", 
    options:"B3:B7", 
    empty:true 
   }, "Sheet1");

Related samples

Dropdowns

Details

The editorObject parameter can have the following properties:

editor - (string) the editor type ("ss_richselect", "popup", "excel_date", "text")
options - (string,array) a range of cell references or an array of editor options
empty - (boolean) specifies whether to add an empty option

You can pass null as the editorObject parameter. In this case the editor will be removed from the cell.