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.

    Thanks
  2. Boryana
    Admin
    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. 

    Regards,
    Boryana
    Telerik
     

    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.

     
  3. UI for WPF is Visual Studio 2017 Ready
Back to Top