protected sheet pop up window

2 posts, 0 answers
  1. Tim
    Tim avatar
    1 posts
    Member since:
    Mar 2014

    Posted 15 Apr 2014 Link to this post

    When the user tries to edit a protected cell in a protected sheet, it pops up a message that says "The cell you are trying to change is on a protected sheet.  To make changes, unprotect the sheet."

    Is there a way to turn off the pop up message?

    I just want it to do nothing when they try to type into a protected cell.

  2. Boryana
    Boryana avatar
    330 posts

    Posted 17 Apr 2014 Link to this post

    Hi Tim,

    Thank you for contacting us.

    Currently, RadSpreadsheet does not have a mechanism to suppress the warning messages. For this reason, we have introduced a MessageShowing event to the RadSpreadsheet class that allows you to prevent the alerts displayed to the user. For example, the following snippet will suppress all protection errors:

    private void RadSpreadsheet_MessageShowing(object sender, MessageShowingEventArgs e)
        string content = LocalizationManager.GetString("Spreadsheet_ProtectedWorksheet_Error");
        if (string.Equals(e.Content, content))
            e.IsHandled = true;

    Please note that the event will be included in the LIB expected next week.

    Let me know if you have further queries. I will do my best to assist you. 


    Check out the Telerik Platform - the only platform that combines a rich set of UI tools with powerful cloud services to develop web, hybrid and native mobile apps.

Back to Top