[Solved] Can I disabled the cell when I load from JSON?

[東祐]

Hello,

 

I'm trying to disabled the cell after I loaded Data but I failed.

What should I do to achieve my need?

Some action I already tried below:

1.

$(function() {
    $("#spreadsheet").kendoSpreadsheet({
    });
    spreadsheet = $("#spreadsheet").data("kendoSpreadsheet");
     $.getJSON("<%=request.getContextPath()%>/data.json")
     .done(function (sheets) {
         spreadsheet.fromJSON( sheets);
     });
     var rangeChange = spreadsheet.activeSheet().range("A1:H9");
    rangeChange.enable(false);
});

2.

add the attribute : "enable" : "false" to JSON Data.

[Ivan Danchev]

Hello,

As mentioned in the documentation when the fromJSON method is called the existing sheet data and configuration (disabled cells for instance) is cleared. So try calling the method in the done() callback method after calling fromJSON:

.done(function (sheets) {
    spreadsheet.fromJSON(sheets);
    var rangeChange = spreadsheet.activeSheet().range("A1:H9");
    rangeChange.enable(false);
});

otherwise rangeChange.enable(false) will be called before the fromJSON method and this method will clear the disabled cells. 

Regards,
Ivan Danchev
Progress Telerik