setCellEditor

creates an editor in a cell

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

rowId	number	the row id
columnId	number	the column id
editorObject	object	an object with editor type and options (for richselect)
page	string	optional, 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 or excel_date)
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.