Spreadsheet Row Dropdown List

2 posts, 0 answers
  1. Judd
    Judd avatar
    7 posts
    Member since:
    Jul 2014

    Posted 03 Nov 2017 Link to this post

    Does the Kendo Spreadsheet have the functionality to have a drop down list in a row like Excel?
  2.
  3. Veselin Tsvetanov
    Admin
    Veselin Tsvetanov avatar
    744 posts

    Posted 07 Nov 2017 Link to this post

    Hi Judd,

    Yes, the Kendo Spreadsheet offers such functionality. Here you will find the Custom cell editors demo, where a drop-down is configured for the values in the B1 cell. Note, that Cell editor is specified using the cell validation:
    cells: [
       { value: "Select item:", bold: true },
       { background: "#fef0cd",
         validation: {
             dataType: "list",
             showButton: true,
             comparerType: "list",
             from: '{ "Foo item 1", "Bar item 2", "Baz item 3" }',
             allowNulls: true,
             type: "reject"
         }
        }
    ]

    Keep in mind, that the Cell editor could be configured per cell, as in the above example, or per range of cells, using the Spreadsheet.Range.validation() method.

    Regards,
    Veselin Tsvetanov
    Progress Telerik
    Try our brand new, jQuery-free Angular components built from ground-up which deliver the business app essential building blocks - a grid component, data visualization (charts) and form elements.
Back to Top