Column-Level Dropdown Support in Spreadsheet Module

[Rakesh]

Hi Team,
I am using the Spreadsheet module for ASP.NET Core.
Currently, we can add a dropdown to a specific spreadsheet cell using (https://demos.telerik.com/aspnet-core/spreadsheet/custom-editors).
However, I would like to add a dropdown to an entire column without having to manually add it to each row or cell through code.
Could you please check if this is possible?

[Ivaylo]

Hi Rakesh,

Thank you for reaching out.

I am currently investigating the case, but will need some additional time before I can provide feedback. I will get back to you once I have further details on the matter.

Thank you in advance for your patience.

Regards,
Author nickname
Progress Telerik

[Ivaylo]

Hi Rakesh,

Thank you for your patience.

The article below provides documentation on how to apply a validation rule to a specified range of cells. For instance, you can assign a dropdownlist to each cell within a column using the following method:

$(function() {
    var range = $("#spreadsheet").data("kendoSpreadsheet").activeSheet().range("B1:B10");

    range.validation({
      dataType: "list",
      from: '"Foo item 1,Bar item 2,Baz item 3"',
      showButton: true,
      comparerType: "list",
      allowNulls: true,
      type: "reject",
      titleTemplate: "Invalid value",
      messageTemplate: "Valid values are 'true' and 'false'."
    });
})

Furthermore, I prepared a sample application where the code could be tested. 

I hope this information was helpful.

Regards,
Author nickname
Progress Telerik