Multiselect in Kendo Jquery Spreadsheet

Hi Ian,

I would suggest taking a look at the Knowledge Base article linked below that demonstrates how a custom editor can be configured in Spreadsheet.

https://docs.telerik.com/kendo-ui/controls/data-management/spreadsheet/custom-editors

Once, the custom editor is defined, you can apply it to a range of cells, using the range method. 

var spreadsheet = $("#spreadsheet").data('kendoSpreadsheet')
var sheet = spreadsheet.activeSheet();
sheet.range("B1:B200").background('#fef0cd').editor("dropdownlist");

Here you will find a Dojo example where a custom editor is added for the second column.

I hope this helps.

Regards,
Neli
Progress Telerik

Hi Neli,
Thanks for your reply, I was hoping to use a solution that keeps the dropdown in the spreadsheet cell, like the 'list' validation that I currently have in place.
Is there a way to use the multiselect instead of a list? Once the values are selected they appear in the spreadsheet cell like they look in a multi-select
 I have looked at the cell validation documentation and I can see that I can use a 'custom' datatype, 
how can I make this work with a multi select dropdown?
 
var range = spreadsheet.activeSheet().range("1:1");
    range.enable(false);
    var columnSens = spreadsheet.activeSheet().range("C2:C30");
    columnSens.validation({
      dataType: "list",
      from: "ListValues!A$1:B$1",
      allowNulls: true,
      type: "reject",
      titleTemplate: "Value Invalid",
      messageTemplate: "Valid Values: 'true' or 'false'."
    });