How to lock/disable/readonly spreadsheet cells?

4 posts, 0 answers
  1. Jack
    Jack avatar
    100 posts
    Member since:
    Jan 2007

    Posted 08 Oct 2015 Link to this post

    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. 

     

  2. Alan
    Alan avatar
    16 posts
    Member since:
    Apr 2013

    Posted 08 Oct 2015 in reply to Jack Link to this post

    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

  3. Babanpreet
    Babanpreet avatar
    1 posts
    Member since:
    Aug 2017

    Posted 17 Aug Link to this post

    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?

  4. Ivan Danchev
    Admin
    Ivan Danchev avatar
    1329 posts

    Posted 21 Aug Link to this post

    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.
Back to Top