Skip to Content
author's profile photo Former Member
Former Member

CustomUI/Ribbon functionality appears in Quick access toolbar?!

Hello everyone,

I've got a question about the custom UI Ribbons in BOA for MS Office...

I read through this posting: http://scn.sap.com/message/13412892

and this documentation: http://msdn.microsoft.com/en-us/library/aa338202(v=office.12).aspx

...but still I don't find the right solution :-(

I edited the customUI.xml file so that it looks like this right now:

<mso:customUI xmlns:mso="http://schemas.microsoft.com/office/2006/01/customui" xmlns:AO="SBOP.AdvancedAnalysis.Addin.1">

<mso:ribbon>

<mso:qat>

<mso:documentControls>

<mso:control idQ="AO:com.sap.ip.bi.pioneer.core.command.refresh" visible="true"/>

<mso:control idQ="AO:com.sap.ip.bi.newpioneer.excel.display" visible="true"/>

<mso:control idQ="AO:com.sap.ip.bi.pioneer.core.command.togglePauseAutoRefresh" visible="true"/>

<mso:control idQ="AO:com.sap.ip.bi.newpioneer.excel.promptsmenu" visible="true"/>

<mso:control idQ="AO:com.sap.ip.bi.newpioneer.excel.settings.menu" visible="true"/>

<mso:control idQ="AO:com.sap.ip.bi.newpioneer.excel.settings.helpmenu" visible="true"/>

</mso:documentControls>

</mso:qat>

</mso:ribbon>

</mso:customUI>

I followed these steps:

1) Create New workbook

2) Options Quick Access Toolbar

3) Chose to modify "This Workbook" NOT "For all documents"

4) Add an analysis button

5) Save

... and basically everything was generated automatically, I just exchanged "doc:" to "AO:", and edited the first line.

The outcome looks like this... I find my buttons in the Quick Access Toolbar (blue), but not in the Analysis ribbon list (red)

In the posting mentioned above it looks like it works as desired... but it just doesn't do in my version.

Does anybody see the error or could provide a correct version of the .xml file?

Thank you very much,

Martin

Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • Best Answer
    Posted on Feb 11, 2014 at 03:39 PM

    Hi,

    I always build up my ribbons with the Custom UI Editor Tool - Download - heise online

    Maybe that helps?

    All the best

    Dirk

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Feb 03, 2014 at 01:29 PM

    Hi Martin,

    Are you running Office 2010 or Office 2007?

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Feb 11, 2014 at 09:54 AM

    Hello everybody.

    I still hope that anyone has an idea or a kind of template for me? :-)


    I think my Problem in above XML file is that <mso:qat> stands for "Quick Access Toolbar" ... and so I tried a dozen different versions but none is showing any positive result.


    So, in the meanwhile I tried going back to scratch:

    - I copy&pasted the example coding of the Microsoft page into a blank word document

    - I updated the .rels file with this line:


    <Relationship Id="rId4" Type="http://schemas.microsoft.com/office/2006/relationships/ui/userCustomization" Target="userCustomization/customUI.xml"/>


    But, still not a single change to see in the ribbon list of my word document :-(

    Basically I understand the structure and contents of the XML file, but actually nothing works in my Excel or Word files...


    My goal is to include Regular Buttons, Radio Buttons and Checkboxes from the sheet into the ribbon list, but I have no idea how :-/

    Is anybody able to provide an example "customUI.xml" file to me?

    Any help is appreciated,

    Martin


    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Martin,

      the problem is that when you copy & paste out of my last reply, the first line is interpreted to contain a hyperlink and an extra < and > will be inserted (pos 18, 71). Double-check that and give it a try.

      Best regards,

      Victor

      PS: Yes, examples/templates are provided in the user guide.

  • author's profile photo Former Member
    Former Member
    Posted on Jul 10, 2015 at 09:40 PM

    I recently Upgraded to AO 2.0 and existing Workbook Custom Ribbon is no longer working?

    Any thoughts?

    Thanks

    Jim Brower

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.