This is a migrated thread and some comments may be shown as answers.

protected sheet pop up window

1 Answer 40 Views
Spreadsheet
This is a migrated thread and some comments may be shown as answers.
Tim
Top achievements
Rank 1
Tim asked on 15 Apr 2014, 05:56 PM
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

1 Answer, 1 is accepted

Sort by
0
Boryana
Telerik team
answered on 17 Apr 2014, 12:54 PM
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.

 
Tags
Spreadsheet
Asked by
Tim
Top achievements
Rank 1
Answers by
Boryana
Telerik team
Share this question
or