CustomUI/Ribbon functionality appears in Quick access toolbar?!

[Former Member]

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

[former_member131154 · Accepted solution]

Hi,

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

Maybe that helps?

All the best

Dirk

[Former Member · Accepted solution]

Thanks for the link.

I will try the tool at home, since I'm not sure if I'm allowed to install it on the company PC.

Regards, Martin

[Former Member · Accepted solution]

After some, or better "a lot more" try&error and testing, I found out that the problem of the missing tab/ribbons is lying in our company's Office 2007 Excel Version 😞

Regardless of what I've been trying ... even with correct code, no new tab did appear. It's working only in Office 2010 and 2013! However, I did not try anymore to incorporate it into the Analysis tab, but created a new one. My XML file looks like this:

<customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui">
<ribbon>
<tabs>
<tab id="CustomTab" label="MyLabel">

<group id="Group1" label="Prepare Data">
<toggleButton id="ToggleButton1" size="large" label="1 Preparation" imageMso="ModuleInsert" />
</group>

<group id="Group3" label="Analyse Data">
<toggleButton id="Button1" size="large" label="2 Analysis" imageMso="AccessFormDatasheet" />
</group>

<group id="Group4" label="Datenziele">
<checkBox id="CheckBox1" label="Report 1" />
<checkBox id="CheckBox2" label="Report 2" />
<checkBox id="CheckBox3" label="Report 3" />
<checkBox id="CheckBox4" label="Report 4" />
</group>

</tab>
</tabs>
</ribbon>
</customUI>

The only thing which I still can't get created is a group of 3 Radio Buttons 😞

When I include this part, the whole new Tab will not be displayed anymore:

<group id="Group2" label="Select Data">

<radioGroup id="RadioGroup" label="Data Selection">

<radioButton id="RB1" label="Report 1" />

<radioButton id="RB2" label="Report 2" />

<radioButton id="RB3" label="Report 3" />

</radioGroup>

</group>

... I don't know if I need the additional <group></group> tags... but in either way it doesn't work. As alternative <combobox></comboBox> is also not working 😕

Any idea why this fails?

Thanks, Martin

[maagp · Accepted solution]

Hi Martin,

As far as I know Microsoft does not support radio buttons in the (customUI) ribbon tabs.

You could use toggle buttons / buttons with images or checkboxes with some VBA coding as a workaround to simulate radio buttons. You can find a sample on this external website: mrexcel.com: ribbon 2007, radio button

Nevertheless, the ComboBox is a valid ribbon control and should work. Can you share your customUI XML?

Best regards,

Patrik

[Former Member · Accepted solution]

Hi Patrik,

I found this example, so I thought Radio Buttons should work: [MS-CUSTOMUI2]: Backstage

However, this is my example with the Combobox. Without the <group id="Group2...> part the XML works fine, but in this way, no tab is displayed 😕

Thanks, Martin

[maagp · Accepted solution]

Hi Martin,

You're right, that's a bit confusing. MS supports radio buttons within a backstage menu but not in ribbon tabs.

I think that I found the reason why your ComboBox isn't working. It uses the attribute showItemlabel="false" which isn't valid. It should work after removing it (see attached file).

Best regards,

Patrik

[Former Member · Accepted solution]

Hi Patrik,

thanks a lot. Now it's working 🙂

Martin

[Former Member]

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

Any thoughts?

Thanks

Jim Brower

[TammyPowlas]

Jim - this is an old closed thread; please create a new thread but also please search - as an example, see this thread:

[Former Member]

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

[Former Member]

Hello Martin,

the example of the user guide works fine on my side (custom button embedded in Analysis Ribbon):

customUI xmlns="http://schemas.microsoft.com/office/2009/07/customui"

x="SBOP.AdvancedAnalysis.Addin.1"><ribbon><tabs>

tab idQ="x:com.sap.ip.bi.analysis.menu">

group id="myCustomGroup" label="Custom Group" ><button id="myButton" label="my Button" onAction="myAction" />

group>

tab>

tabs>

ribbon>

customUI>

Best regards,

Victor

[Former Member]

Hi Victor,

I took your coding and created a "customUI.xml" file from it.

Then I included it in my Excel via renaming to .zip but still no group or button available 😕

Even changing the Version fom "/office/2009/07" to "office/2006/01" shows no difference.

Is there maybe a registry setting which prevents any new groups or buttons?

Could you check the "customUI.xml" in it. It should look like your coding, plus the missing open-tags: <

Best regards,

Martin

[Former Member]

Seems my last xml got corrupted while copying&pasting. Here the example in clean:

<customUI xmlns="http://schemas.microsoft.com/office/2009/07/customui"

xmlns:x="SBOP.AdvancedAnalysis.Addin.1"><ribbon><tabs>

<tab idQ="x:com.sap.ip.bi.analysis.menu">

<group id="myCustomGroup" label="Custom Group" ><button id="myButton" label="my Button" onAction="myAction" />

</group>

</tab>

</tabs>

</ribbon>

</customUI>

Like Dirk I also use the custom UI Editor, if I take your xml and paste it there, it will bark and bring an error message.

Best regards,

Victor

[Former Member]

Hi Victor,

I tried the tool ... and you are right, it "barks" with my file.

BUT: It was exactly the copy or your example ???

Have you tried your example in the tool, too? I bet it behaves exactly the same!?

So, I still poke about it in a fog 😕

Are there no templates or best practices provided by SAP?

Regards, Martin

[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.

[Former Member]

Hi Martin,

Are you running Office 2010 or Office 2007?

[Former Member]

I'm on Office 2007 and using AO 1.4.5

... any ideas for me?

Message was edited by: Martin Kreitlein