Disable editing in spreadsheet

4 posts, 1 answers
  1. Ishita
    Ishita avatar
    30 posts
    Member since:
    Nov 2013

    Posted 01 May 2014 Link to this post

    Hi,
          I want to disable editing in my spreadsheet but it should allow to change sheets.(If i set IsEnable = false, it does not allow me to change the sheet.).

    Thanks in advance :)
  2. Answer
    Svetoslav
    Admin
    Svetoslav avatar
    55 posts

    Posted 06 May 2014 Link to this post

    Hello Ishita,

    Thank you for contacting us.

    If you would like to prevent the user from modifying the contents of sheets, you can use worksheet protection. You will be able to find information about the feature in the Worksheet Protection article in our online documentation. Additionally, if you do not want to allow the user to add, remove and rename sheets, you can use workbook protection.

    When the user attempts to change the value of a protected cell, a warning message pops up. If you would like to get rid of that message, you need to download the latest LIB where the RadSpreadsheet class contains a MessageShowing event. This event allows you to modify or suppress all messages displayed to the user. The following snippet hides only alerts related to protection:
    01.private void RadSpreadsheet_MessageShowing(object sender, MessageShowingEventArgs e)
    02.{
    03.    string protectionError = LocalizationManager.GetString("Spreadsheet_ProtectedWorksheet_Error");
    04.  
    05.    if (e.Content.Equals(protectionError, StringComparison.CurrentCulture))
    06.    {
    07.        e.IsHandled = true;
    08.    }
    09.}

    I hope you find my answer useful. Let me know if you have further questions.

    Regards,
    Svetoslav
    Telerik
     
    Check out Telerik Analytics, the service which allows developers to discover app usage patterns, analyze user data, log exceptions, solve problems and profile application performance at run time. Watch the videos and start improving your app based on facts, not hunches.
     
  3. vinutha
    vinutha avatar
    1 posts
    Member since:
    Dec 2016

    Posted 28 Dec 2016 Link to this post

    hi,

    the above link what u have given for workbook and worksheet protection are not working

  4. Boby
    Admin
    Boby avatar
    627 posts

    Posted 29 Dec 2016 Link to this post

    Hi vinutha,

    Thanks for letting us know. The new links are the following:
    Worksheet Protection
    Workbook Protection

    Regards,
    Boby
    Telerik by Progress
    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