I am trying to use a specialized text editor for spreadsheet cells. I have tried:
sheet.setCellEditor(row,column,{editor: “text”, options:[{value:“test”}]});
sheet.setCellEditor(row,column,{editor: “text”, options:{value:“test”}});
sheet.setCellEditor(row,column,{editor: “text”, value:“test”});
None of the above work. The below works fine, but is not what I need:
sheet.setCellEditor(row,column,{ editor:“richselect”, options:[“One”, “Two”, “Three”]});