New to Telerik UI for ASP.NET MVC? Download free 30-day trial

Disabled Cells

The Telerik UI Spreadsheet for ASP.NET MVC allows you to control the enabled and disabled state of the cells.

Set Cell State at Initialization

You can set the state of a cell during the initialization of the Spreadsheet for ASP.NET MVC by using the .Enable() configuration option:

        .Sheets(sheets => {
                .Rows(rows => {
                    rows.Add().Cells(cells => {
                            .Value("Enabled Cell");

                            .Value("Disabled Cell")

Set Cell State after Initialization

You can set the state of a cell or range of cells after the initialization by using the kendo.spreadsheet.Range client-side API and the enable method.

The following example demosntrates how to toggle the state of cell A1 on button click:

$("#myButton").click(function () {
    var range = $("#spreadsheet").data("kendoSpreadsheet").activeSheet().range("A1");
    var enabled = range.enable();

    if (enabled === null) {
        enabled = true;

    //Enable / disable specified range

See Also

In this article