Is it possible to hide 'Add New Sheet' button in Sheetselector?

2 posts, 0 answers
  1. Ruslan
    Ruslan avatar
    4 posts
    Member since:
    Jul 2012

    Posted 16 Apr 2014 Link to this post

    1. Is it possible to hide 'Add New Sheet' button in the Sheetselector?
    2. How to disable the dialog with 'The cell you are trying to editing is on a protected sheet. To make changes, unprotect the sheet' message?
  2. Boryana
    Boryana avatar
    330 posts

    Posted 17 Apr 2014 Link to this post

    Hello Ruslan,

    Thank you for contacting us.

    Let me get straight to your questions: 

    1. You can hide the Add Sheet button using the IsAddButtonVisible attached property:
    RadSpreadsheetSheetSelector.SetIsAddButtonVisible(this.radSpreadsheet, false);

    2. Currently, RadSpreadsheet does not provide control over the warnings and messages displayed to the user. For this reason we added a MessageShowing event to the RadSpreadsheet class that allows you to suppress and customize the dialog. For example, the following snippet will disable only protection-related messages:

    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 MessageShowing event will be available in the LIB expected next week.

    I hope you will find my answer helpful. Do not hesitate to write back if you have further questions.


    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