Disable editing in spreadsheet

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

    Posted 01 May 2014 Link to this post

          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 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)
    03.    string protectionError = LocalizationManager.GetString("Spreadsheet_ProtectedWorksheet_Error");
    05.    if (e.Content.Equals(protectionError, StringComparison.CurrentCulture))
    06.    {
    07.        e.IsHandled = true;
    08.    }

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

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