BuyLog In
Ticket T147705
Visible to All Users

Spreadsheet - Disable "New" and "Open" buttons in Ribbon menu

created 11 years ago

Hi,

We would want to disable some buttons in the MVC Spreadsheet control, for example the "New" and "Open" buttons in the "File" tab .  We checked your online demos and found this page which disable the "File" tab altogether (https://demos.devexpress.com/MVCxSpreadsheetDemos/SpreadsheetAPI/CellValue),,) but the feature uses a utility class that the website does not allow to see.  Would it be possible to remove only the required buttons and if so, how would you do this ?

Thank you and have a nice day

Sign in to comment on this post

Answers approved by DevExpress Support

created 11 years ago (modified 9 years ago)

Hi,

You can easily accomplish this task by handling the PreRender event in the following manner:

C#
@Html.DevExpress().Spreadsheet(settings => {  
    settings.Name = "Spreadsheet";  
    settings.PreRender = (s, e) => {  
        DevExpress.Web.ASPxSpreadsheet.ASPxSpreadsheet spreadsheet = (DevExpress.Web.ASPxSpreadsheet.ASPxSpreadsheet)s;  
        spreadsheet.CreateDefaultRibbonTabs(true);  
        DevExpress.Web.ASPxRibbon.RibbonTab fileTab = spreadsheet.RibbonTabs[0];  
        fileTab.Groups[0].Items[0].ClientEnabled = false;  
        fileTab.Groups[0].Items[1].ClientEnabled = false;  
    };  
}).GetHtml()

Attached is a corresponding code example. I hope this information helps.

Thanks,
Alessandro.

Updated:

If you are using ASPxRichEdit v15.1+, use the approach from the ASPxRichEdit - It is not possible to hide or disable items in the built-in ribbon using the Visible and ClientEnabled properties link to hide or disable a particular item in ASPxRichEdit.

    Comments (3)
    SN SN
    Sebastien Nadeau 11 years ago

      Thank you very much !  I tweaked the code to hide completely the buttons with the "Visible" property, but this is exactly what I was looking for !

      S S
      Sankarvarma 10 years ago

        Hi,
        how can we disable Open button in Spreadsheet (ASP.NET website).I raised a ticket regarding above issue but didn't found suitable solution yet.
        Please help me to reach out.

        Alessandro (DevExpress Support) 10 years ago

          Hi,

          At present, there is no built-in functionality for this purpose. This functionality will be implemented in the context of the following report:

          T190077: ASPxSpreadsheet - Add the capability to disable a certain functionality (work with clipboard, undo-redo, etc.)

          Sign in to comment on this post

          Disclaimer: The information provided on DevExpress.com and affiliated web properties (including the DevExpress Support Center) is provided "as is" without warranty of any kind. Developer Express Inc disclaims all warranties, either express or implied, including the warranties of merchantability and fitness for a particular purpose. Please refer to the DevExpress.com Website Terms of Use for more information in this regard.

          Confidential Information: Developer Express Inc does not wish to receive, will not act to procure, nor will it solicit, confidential or proprietary materials and information from you through the DevExpress Support Center or its web properties. Any and all materials or information divulged during chats, email communications, online discussions, Support Center tickets, or made available to Developer Express Inc in any manner will be deemed NOT to be confidential by Developer Express Inc. Please refer to the DevExpress.com Website Terms of Use for more information in this regard.