Setting objects(webix views) to cells in spreadsheet

Webix JS
1

Hi

I am trying to set a richselect/combo object to a cell on webix spreadsheet. Below is an example :

webix.ready(function(){
  webix.ui({
    view:"spreadsheet", id:"ssheet",
    data: base_data,
    toolbar: "full"
  });

  $$("ssheet").setCellEditor(8,1,{ editor:"richselect", options:["One", "Two", "Three"]});
  $$("ssheet").setCellEditor(8,2,{ editor:"richselect", options:"B3:B7" });
  $$("ssheet").setCellEditor(8,3,{ editor:"richselect", options:"//docs.webix.com/samples/15_datatable/04_editing/data/options.json"});
});

I get a script error when I am trying to get the option values dynamically in cell (8,3).

Below is the error in console

Uncaught TypeError: Cannot read property '4' of null
    at Ko (VM294 spreadsheet.js:1)
    at u.<anonymous> (VM294 spreadsheet.js:1)
    at u.callEvent (VM259 webix.js:8)
    at u.edit (VM259 webix.js:8)
    at u.t.on_click.ss_filter (VM294 spreadsheet.js:1)
    at u._M (VM259 webix.js:8)
    at u.fu (VM259 webix.js:8)
    at u.hu (VM259 webix.js:8)
    at HTMLDivElement.<anonymous> (VM259 webix.js:8)
Ko @ VM402 spreadsheet.js:1
(anonymous) @ VM402 spreadsheet.js:1
callEvent @ VM363 webix.js:8
edit @ VM363 webix.js:8
t.on_click.ss_filter @ VM402 spreadsheet.js:1
_M @ VM363 webix.js:8
fu @ VM363 webix.js:8
hu @ VM363 webix.js:8
(anonymous) @ VM363 webix.js:8

Thanks

2

Hi @rsant

To set options by url you can use this construction:

{ editor:"richselect", suggest:{ url:"..." } }

Example: Code Snippet

3

Thank you!! this works!!