XL2BB - Excel Range to BBCode 2.1

[smozgur]

My XL2BB tab shows up in the ribbon at the end. I can copy ranges. However I cannot customize it in the ribbon to move it around. It is unblocked. Any ideas?

The XL2BB Excel add-in is a standard add-in instead of a Visual Studio COM add-in to make it available in Mac and also avoid extra runtime libraries that the client machine might need to download and install to run it. Therefore, its custom ribbon tab is document-level customization, so I don't know if it is even possible to control it in the ribbon customization dialog. That's the reason we located it after all other tabs.

However, one possible workaround to place the XL2BB ribbon tab after or before a certain tab, for example, Home tab, then you can open the xl2bb.xlam file as an archive (by using an application like 7-Zip to make it easy - remember to quit Excel), and edit the \customUI\customUI14.xml file to add the insertAfterMso attribute as shown below:

<tab id="tabXL2BB" label="Xl2bb" keytip="X" insertAfterMso="TabHome">

This will create the XL2BB ribbon tab after the Home tab.

This is the only way (actually, workaround) that I can think of.

Note: I am moving your post to the XL2BB discussion. Maybe other members following this thread might know other ways, or this workaround might help others as well.

 

[schardt679]

The XL2BB Excel add-in is a standard add-in instead of a Visual Studio COM add-in to make it available in Mac and also avoid extra runtime libraries that the client machine might need to download and install to run it. Therefore, its custom ribbon tab is document-level customization, so I don't know if it is even possible to control it in the ribbon customization dialog. That's the reason we located it after all other tabs.

However, one possible workaround to place the XL2BB ribbon tab after or before a certain tab, for example, Home tab, then you can open the xl2bb.xlam file as an archive (by using an application like 7-Zip to make it easy - remember to quit Excel), and edit the \customUI\customUI14.xml file to add the insertAfterMso attribute as shown below:

<tab id="tabXL2BB" label="Xl2bb" keytip="X" insertAfterMso="TabHome">

This will create the XL2BB ribbon tab after the Home tab.

This is the only way (actually, workaround) that I can think of.

Note: I am moving your post to the XL2BB discussion. Maybe other members following that thread might know other ways, or this workaround might help others as well.

Thanks for the reply. It's not a huge deal to me. I wasn't sure if it was it was a result of how it was made or if it was a bug. That's why I posted my previous comment.

If it helps others, that's great.

 

[narendra]

The square bracket '[' is causing some problem with the message body and with xl2bb.
'' <-- Also, here I typed '[ I ]' here without the space in between the square brackets but all you will see now is ''

Occasionally, if the first cell in my selection contains a square bracket '[' then xl2bb does not show the data properly.
For example, this works ?

Book1.xlsx
	A	B
1	(I) Loan 'Installment' dates :
2	Loan Date :	29-Feb-16
3	Loan Tenure :	9
4	Installment Frequency :	Qtrly
5		3
Sheet1

Cell Formulas
Range	Formula
B5	B5	=IF(B4="Monthly",1,IF(B4="Qtrly",3,IF(B4="Half-Yrly",6,IF(B4="Yearly",12,"-"))))

Cells with Data Validation
Cell	Allow	Criteria
B3	Whole number	>0
B4	List	Monthly,Qtrly,Half-Yrly,Yearly

but this does not ?,I added a space and a special character before '[', but it still failed

Book1.xlsx
	A	B
1	Loan 'Installment' dates :
Sheet1

[XD=cls:bb][/XD] [XR][XH]2[/XH][XD=fw:b|ch:15|cls:br]Loan Date : [/XD][XD=bc:FFFFCC|cls:bl bt br bb|tx:42429]29-Feb-16[/XD][/XR][XR][XH]3[/XH][XD=fw:b|ch:17.25|cls:br]Loan Tenure : [/XD][XD=fw:b|bc:FFFFCC|c:0000FF|fz:12.5pt|cls:bl bt bb]9[/XD][/XR][XR][XH]4[/XH][XD=fw:b|ch:15|cls:br]Installment Frequency : [/XD][XD=h:c|fw:b|bc:FFFFCC|c:0000FF|cls:bl bt br bb]Qtrly[/XD][/XR][XR][XH]5[/XH][XD=ch:15][/XD][XD=h:c|cls:fx bt]3[/XD][/XR]

Cell Formulas
Range	Formula
B5	B5	=IF(B4="Monthly",1,IF(B4="Qtrly",3,IF(B4="Half-Yrly",6,IF(B4="Yearly",12,"-"))))

Cells with Data Validation
Cell	Allow	Criteria
B3	Whole number	>0
B4	List	Monthly,Qtrly,Half-Yrly,Yearly

two more results:
I changed the text to 'A [ I ] Loan Installment Dates:' without the space between the sq. brackets, but it still failed

Book1.xlsx
	A
1	A Loan 'Installment' dates :
Sheet1

[XR][XH]2[/XH][XD=fw:b|ch:15|cls:br]Loan Date : [/XD][/XR][XR][XH]3[/XH][XD=fw:b|ch:17.25|cls:br]Loan Tenure : [/XD][/XR]

however the following text worked 'I [Loan] Installment Dates:'

Book1.xlsx
	A
1	I [Loan] 'Installment' dates :
2	Loan Date :
3	Loan Tenure :
Sheet1

 

[narendra]

fyi, in the above post, in the second xl2bb example, I simply changed the curved brackets to square brackets.

 

[smozgur]

Existing BB Code tags, such as [B],[I],[U],[S] that don't require any parameters, conflict with the XL2BB mini-sheet code, and render how they are defined. So, there is not an easy workaround at the addon level to avoid this behavior other than avoiding these values in the source cells in the first place OR using apace before, after, or both sides of the tag letter like [ I], [I ] or [ I ].

 

[cmowla]

Hi, I am new to this site and to this tool. I just wanted to mention that for Windows 10 (for the following version of Office), I had trouble following the installation instructions. I eventually found out that if I put xl2bb.xlam here: C:\Program Files\Microsoft Office\root\Office16\Library, then I was able to follow the rest of the instructions.

"

• Launch Excel, click the File tab, click Options, and then click the Add-Ins category.
• In the Manage box, click Excel Add-ins, and then click Go. The Add-Ins dialog box appears.
• Click the Browse button to locate the add-in, and then click OK."

(Just giving a viewpoint from a newcomer.)

 

[JacksonTriggs]

Hi smozgur,

Perhaps I'm missing it but do you have installation instructions for Mac please?

Thanks!
Darryl

 

[JacksonTriggs]

Hi smozgur,

Perhaps I'm missing it but do you have installation instructions for Mac please?

Thanks!
Darryl

I figured it out.
Excel Tools > Add-ins > Browse (find the unzipped copy of the file)
Then find XL2BB can be seen above the ribbon.
All good!

 

[Dan_W]

Hi. Just thought I should put this on your radar - see the comment re: the adding not working on Win11(??). Post in thread 'VBA Test Fails, but Excel formulas are correct' VBA Test Fails, but Excel formulas are correct

 

[smozgur]

Hi. Just thought I should put this on your radar - see the comment re: the adding not working on Win11(??). Post in thread 'VBA Test Fails, but Excel formulas are correct' VBA Test Fails, but Excel formulas are correct

Thanks Dan. Also thanks for asking for more info in the thread. I'll watch for the reply from the member.