This is a migrated thread and some comments may be shown as answers.

How to lock/disable/readonly spreadsheet cells?

3 Answers 1906 Views
Spreadsheet
This is a migrated thread and some comments may be shown as answers.
Jack
Top achievements
Rank 2
Iron
Jack asked on 08 Oct 2015, 06:55 AM

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. 

 

3 Answers, 1 is accepted

Sort by
0
Alan
Top achievements
Rank 1
answered on 08 Oct 2015, 07:40 PM

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

0
Babanpreet
Top achievements
Rank 1
answered on 17 Aug 2017, 01:15 PM

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?

0
Ivan Danchev
Telerik team
answered on 21 Aug 2017, 11:36 AM
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
Try our brand new, jQuery-free Angular 2 components built from ground-up which deliver the business app essential building blocks - a grid component, data visualization (charts) and form elements.
Tags
Spreadsheet
Asked by
Jack
Top achievements
Rank 2
Iron
Answers by
Alan
Top achievements
Rank 1
Babanpreet
Top achievements
Rank 1
Ivan Danchev
Telerik team
Share this question
or