How to lock/disable/readonly spreadsheet cells?

[Jack]

Spreadsheet is a nice addition to the Kendo UI framework.

After running the samples and reading the documentation, I could not find a way to lock cells and prevent user changes especially to protect formulas. Frozen rows and columns do not seem to achieve the same. Take the demos and consider the invoice, would you implement it as a spreadsheet if you could not lock the ​tax rate and total?

If there is a way to lock cells, please advise, otherwise please implement before RTM. 

 

[Alan]

Looks like there may be a request on the Kendo Voice site for this...

 http://kendoui-feedback.telerik.com/forums/127393-telerik-kendo-ui-feedback/suggestions/10069761-spreadsheet-enable-disable-cell

[Babanpreet]

Hi Kendo Team,

 

I couldn't find any way to make whole row, column, spreadsheet, workbook read-only. Please suggest if this feature is available or should I log a ticket for this feature?

[Ivan Danchev]

Hi Babanpreet,

Currently only a specific range can be made read only by disabling it through the enable method (.enable(false)) as demonstrated in the API documentation.
Such option currently is not implemented for rows/columns/sheets so disabling the whole sheet would require calling the method for a range that covers the whole row, column or sheet respectively, for instance:

sheet.range("A1:AX200").enable(false);

We would suggest logging a feature request in our Feedback Portal for the addition of a configuration option/method, similar to that of the Range object, for the Sheet object.

Regards,
Ivan Danchev
Progress Telerik