asked on

How to force a hard return in XML for office ribbon

Hi All
The code below adds a button to the ribbon in Excel 2007. The problem Im having is that the tooltip is all added in one line. Is there a way to make it go to the next line so it looks something like this?
Prepare an MS Word document with
suppliers profiles and automatically
e-mail it to them. The document will
contain the name of the company,
and where available the name of the
contact person. The template must
be available in C:\Data\SupplierProfile.docx.
Thanks in advance
Elmo

<customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui">
<ribbon startFromScratch="false">
<tabs>
 
<tab id = "customTab" label="Tara Nawa" insertAfterMso="TabView">
 
<group id="eMail" label="e-Mail">
<button id="btnPerSupProf" screentip="Prepare an MS Word document with suppliers profiles and automatically e-mail it to them. The document will contain the name of the company, and where available the name of the contact person. The template must be available in C:.docx." label="Personalized-Supplier Profile" onAction="CallControl"  imageMso="Magnifier" />
</group>
 
</tab>
</tabs>
</ribbon>
</customUI>

Open in new window

Craig Yellick

It is up to the application that uses the attribute value to decide whether or not to "respect" any CR+LF characters present. The tooltip might break on lines or it might show those box characters that represent symbols that cannot be displayed in the current font.

In any event, XML supports the encoding of special characters by preceding with an ampersand and terminating with a semicolon. For example to put a quote character inside the quoted attribute value, use:

"

The CR chacter is ASCII 13 so the encoding is:



If that does not do the trick you may need to include the LF (ascii 10) character as well.


   screentip="Prepare an MS Word document with suppliers &#13;profiles ..."

Open in new window

Elmo Erasmus

ASKER

Hi Craig
I tried
screentip="Prepare an MS Word document with suppliers profiles ..."
screentip="Prepare an MS Word document with suppliers 
profiles ..."
screentip="Prepare an MS Word document with suppliers  
profiles ..."
and neither of them work. I get the box charcater where i put 10.
Elmo

ASKER CERTIFIED SOLUTION

Craig Yellick

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Elmo Erasmus

ASKER

Thanks Craig the supertip did the trick