BB Code Enhancements - BB Code [table]

BB Code [table]
by StGaensler

Description
This Hack provides a BB code [table] to add a table to the post
The skin of the table automatically fits the style because the CSS classes of vBulletin are used.

A table is simply made of some lines (will be the rows). The cols are seperated by |. So this will be a table:

[table="head"]head col1|head col2|head col3
row1 col1|row1 col2|row1 col3
row2 col1|row2 col2|row2 col3[/table]

A screenshot of a "ready" table is attached

Usage

1. install attached product XML through product manager (overwrite existing)
2. install at least one language pack in AdminCP -> Languages & Phrases -> Download / Upload Languages -> Import Language XML File
   Important: Select the language you want to import the phrases into, not "(Create New Language)" - this won't work! If you use another version of vBulletin than I use enable "Ignore Language Version" to import the language pack.

Please note: (installing)
Installing this product will: (reverted during uninstall)

1. rename a existing BB code "table" to "table_saved"
2. add a new BB code [table]

If you want to have live sortable columns (JavaScript): Download attached sorttable.js.txt rename it to sorttable.js and place it into the /clientscript/ folder of your vBulletin. Then go to AdminCP -> vBulletin Options -> BB Code [table] Settings -> Enabled Features Of This BB Code and enable sortable
Note: Including the file on the webpages where it is necessary is done by my product. So if sortable is disabled, it won't be included automatically.
If you want to have a icon for the editor you may use this for free: Download this icon and place it in your /images/editor/ folder.

Please note: (usage)

• Of course you can use vB Code and smilies inside the table!
• The first line defines how much columns are in the table. If the other lines have more or less colums they are cut off or filled with   (space)
• You can find a detailed description of the options (please read it before requesting help)
• Empty rows are (should be ) removed.

New features

• define colspan of cells
• small panel in AdminCP
• define CSS class of table and tablerows
• live sorting of table through clicking the head of a column
• defining maximum width of a table

Maybe planned features

• detailed description of the vB Code in misc.php?do=bbcode depending on the features enabled in AdminCP (planned for next beta version)
• define formatting (bold, italic), align (left, right, center) and width of the cols

Suggested but not planned features

• none

Known problems

• Bugfix of version 0.1.1 doesn't work if vBulletin should write template names into the source code

Version history:
0.0.1 - 0.0.5 internal releases for testing purposes (Thanks to Zombie79 from powerforen.de for testing)
0.1 first official release
0.1.1 fixed small bug: if a line ends with eg vbcode quote no new row was generated (should already have been fixed but did not work)
0.1.2 workaround: removed call to function bcmod(), it could also be done another way
0.1.3.x beta version described here (and following) - added admin panel, colpan and css feature
0.1.4 stable version - no significant changes to the last beta (0.1.3.8)
0.1.5.x beta version described here (and following) - added sortable, maxwidth, versioncheck, upgrade message, compatibility to vB 3.6
0.1.6 stable version - two bugfixes to last beta, {br} for posting linebreaks in a tablecell
0.1.7.x stable version - compatibility to vB 3.7 (description) - added tab seperated tables

This hack can be used for free. If you want to make a small donation, just contact me. We will find a way
I don't want this product to be distributed from other sources. Please don't upload it to other vBulletin related boards etc.

[War.Frog]

Originally Posted by BRotondi

Still did not work in 2007 because the simple copy now adds some differen CRs -> you would need to paste it as text only (through Notepad or in simple Editor mode)

I solved this and reduzed the 50 lines to "auto" in the attached version. Does it work on 2002?

Regards, Bruno

Originally Posted by MagicThemeParks

Great work guys, keep at it! :up:

If you can get a true, glitch-free option for bringing the info straight over from Excel, then it would take this mod to the stratosphere!

Really nice fix Bruno! I've taken a different approach here entirely, and I may need to lean on someone's VBA expertise as well, but I'm REALLY happy with the potential of v2.0. I should have a working version later this aft.

[War.Frog]

Based on the code of Excel2BBTable, I added some significant modification and conversions to make it work with this hack.

Now, Excel formatting as seen on screen is automatically translated on a cell-by-cell basis. So font, font color, bold, italic, underline...pretty much all the basic styling this hack supports! I would like to add colspan support...and that'll be a work in progress.

To run, just create any data here and format it the way you like. Select the range you want as a table, click on the button (or toolbar) and generate the code for pasting to your post.

One minor issue...because of how this hack is written, it adds an extra column because of the pipe "|" at the end of the rows. To remove that column, you can just delete the end pipe in the first row before you submit your post.

[MagicThemeParks]

War.Frog, this should be released as an "add-on" modification to this mod or something. This is a HUGE help for folks wanting to work on really complicated or detailed tables! :up:

Thanks for the help on this!

[War.Frog]

Thanks MTP! You're welcome, and I was motivated myself because I just get overwhelmed when the table exceed three rows.

This approach definitely eases things because it's a virtual WYSIWYG translation to BB Code. In fact, the macro could be used on ANY Excel range in any table (not just this one), as long as you manually entered the "head", sort and other detail into the code after the fact.

I'm going to continue playing with it to see if I can get colspan to work among other things.

[BRotondi]

Big Thanks also from my side . Works on 2007 with a small "Bug":
- Header has CRs after each cell:

[table="head;width=100%"]

a

|

b

|

c

|

and a real bug:

If iSize <> 12 Then

according the code you wanted "If iSize <> 2 Then [inserte Code-Tag]"

Nice work!! Thanks again!
Bruno

[BRotondi]

And solved the empty column on the right:

        c = 0
        c0 = rngRow.Cells.Count
        For Each rngCell In rngRow.Cells
            c = c + 1
            sCell = rngCell.Text
(...)            
            'Add opening and closing cell tags
            If c < c0 Then
                sCell = sCell & "|"
            End If

Greetings, Bruno

[War.Frog]

Awesome Bruno. Hmm, very strange about the extra CRs after the header...this is what frustrates me so much about Excel versions!

Can you try posting your fix in both .xlsx and a down-saved .xls version to see if it translates properly? I can't do anything for > 2002.

Thanks!

[MagicThemeParks]

Bruno/War.Frog,

Great work for the two of you. This is going to help our community tremendously. :up:

Does that 'empty column on the right' fix work for all versions of Excel? If so, will one of you share the 'corrected' version?

[BRotondi]

I never use xlsx, perhaps in 10 years when 2002 died . Here always my latest xls-version in german (for my users): table.xls (Thread)

Greetings, Bruno

Edit:

• Interesting: The CR-Bug disappeared! Perhaps has something to do with my above workaround or with multiple saving the document .
• Yes, should work in all Excel-Versions. I think War.Frog will soon post his new english version

[War.Frog]

Originally Posted by BRotondi

I never use xlsx, perhaps in 10 years when 2002 died . Here always my latest xls-version in german (for my users): table.xls (Thread)

Greetings, Bruno

Edit:

• Interesting: The CR-Bug disappeared! Perhaps has something to do with my above workaround or with multiple saving the document .
• Yes, should work in all Excel-Versions. I think War.Frog will soon post his new english version

LOL Bruno...good for you not using xlsx! Sadly I'm stuck with 2002 because of corporate hesitation.

For whatever reason, this doesn't translate well back to 2002. I'm going to look at this to try and understand why - it's now adding MORE columns to the end and a column to the beginning. C'mon Microsoft! lol.

Thanks for your nice words too MagicThemeParks. Hopefully, we can get this ironed out 100% for all versions of Excel, or at least separate ones for each.