Announcement

Collapse
No announcement yet.

New Table Option

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • New Table Option

    After a suggestion from LostStudent and a link provided by Pelagius, I have added a custom BB code for tables. You will notice a new table icon in the advanced editor. There are instructions on using the table option here:

    http://www.vbulletin.org/forum/showthread.php?t=107985
    http://www.vbulletin.org/forum/showp...70&postcount=2

    This is how you would structure a simple table:

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

    This code results in the following table:

    I have written a VB macro for an Excel spreadsheet that allows you to set up your table in Excel and then click a button to copy the table to the clipboard for pasting into into a message. You can download the spreadsheet here:

    http://www.cougaruteforum.com/cuf-extras/excel2bb.xlsm

    It is in Excel 2007 format. In order to use the spreadsheet, you will need to enable VB macros in Excel. To enable macros:

    1) Click on the Office button and select Excel Options.
    2) Click on Trust Center in the options on the left.
    3) Click on the Trust Center Settings button.
    4) Click on the Macro Settings option.
    5) Select one of the following two options:
    ---Disable all macros with notification <-- With this option you can choose to enable macros whenever you open the spreadsheet
    ---Enable all macros <--- Simplest method. The spreadsheet will work whenever you open it.
    6) Click OK twice and open the spreadsheet.
    Last edited by Jeff Lebowski; 02-26-2010, 07:12 PM. Reason: Added link to Excel spreadsheet.
    "There is no creature more arrogant than a self-righteous libertarian on the web, am I right? Those folks are just intolerable."
    "It's no secret that the great American pastime is no longer baseball. Now it's sanctimony." -- Guy Periwinkle, The Nix.
    "Juilliardk N I ibuprofen Hyu I U unhurt u" - creekster

  • #2
    Fitter. Happier. More Productive.

    sigpic

    Comment


    • #3
      Works great, Jeff!

      Comment


      • #4
        I edited it to be more complete
        PLesa excuse the tpyos.

        Comment


        • #5
          In the fourth grade when I was learning multiplication I thought it would be cool to have a round table with a clock painted on it, then you could call it a times table.

          Comment


          • #6
            Originally posted by creekster View Post
            I edited it to be more complete

            Last edited by TripletDaddy; 02-26-2010, 05:40 PM.
            Fitter. Happier. More Productive.

            sigpic

            Comment


            • #7
              Originally posted by Jeff Lebowski View Post
              This is how you would structure a simple table:

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

              except that you would remove the space between the first "[" and "table" (I can't figure out how to show the text without getting it to parse to a table).
              Thanks!

              Use [noparse] (stuff) [/noparse]
              Code:
              [noparse][table="head"]head col1|head col2|head col3
              row1 col1|row1 col2|row1 col3
              row2 col1|row2 col2|row2 col3[/table][/noparse]
              results in:

              [table="head"]head col1|head col2|head col3
              row1 col1|row1 col2|row1 col3
              row2 col1|row2 col2|row2 col3[/table]
              Last edited by Lost Student; 02-26-2010, 09:38 AM.
              "Seriously, is there a bigger high on the whole face of the earth than eating a salad?"--SeattleUte
              "The only Ute to cause even half the nationwide hysteria of Jimmermania was Ted Bundy."--TripletDaddy
              This is a tough, NYC broad, a doctor who deals with bleeding organs, dying people and testicles on a regular basis without crying."--oxcoug
              "I'm not impressed (and I'm even into choreography . . .)"--Donuthole
              "I too was fortunate to leave with my same balls."--byu71

              Comment


              • #8
                Originally posted by Lost_Student View Post
                Thanks!

                Use [noparse] (stuff) [/noparse]
                Code:
                [noparse][table="head"]head col1|head col2|head col3
                row1 col1|row1 col2|row1 col3
                row2 col1|row2 col2|row2 col3[/table][/noparse]
                results in:

                [table="head"]head col1|head col2|head col3
                row1 col1|row1 col2|row1 col3
                row2 col1|row2 col2|row2 col3[/table]
                Thanks. I fixed it.
                "There is no creature more arrogant than a self-righteous libertarian on the web, am I right? Those folks are just intolerable."
                "It's no secret that the great American pastime is no longer baseball. Now it's sanctimony." -- Guy Periwinkle, The Nix.
                "Juilliardk N I ibuprofen Hyu I U unhurt u" - creekster

                Comment


                • #9
                  Now what I need to do is write script for Excel that will let you select a table in a spreadsheet and copy it to the clipboard in the format shown above. That would be pretty easy, actually.
                  "There is no creature more arrogant than a self-righteous libertarian on the web, am I right? Those folks are just intolerable."
                  "It's no secret that the great American pastime is no longer baseball. Now it's sanctimony." -- Guy Periwinkle, The Nix.
                  "Juilliardk N I ibuprofen Hyu I U unhurt u" - creekster

                  Comment


                  • #10
                    Originally posted by YOhio View Post
                    In the fourth grade when I was learning multiplication I thought it would be cool to have a round table with a clock painted on it, then you could call it a times table.
                    "Wuap's "problem" is that he is smart & principled & committed to a moral course of action. His actions are supposed to reflect his ethical code.
                    The rest of us rarely bother to think about our actions." --Solon

                    Comment


                    • #11
                      Originally posted by creekster View Post
                      I edited it to be more complete
                      ha! my son wants to know why I'm laughing so hard.

                      Comment


                      • #12
                        Originally posted by wuapinmon View Post
                        That's a horrible idea!
                        "Nobody listens to Turtle."
                        -Turtle
                        sigpic

                        Comment


                        • #13
                          Originally posted by Babs View Post
                          ha! my son wants to know why I'm laughing so hard.
                          That is funny. Who knew demons needed to do anything to stay in shape?

                          Comment


                          • #14
                            Originally posted by UtahDan View Post
                            That is funny. Who knew demons needed to do anything to stay in shape?
                            It's a war buddy. a WAR!
                            PLesa excuse the tpyos.

                            Comment


                            • #15
                              Originally posted by UtahDan View Post
                              That is funny. Who knew demons needed to do anything to stay in shape?
                              What I thought was really impressive is that they apparently have personal trainers. Perhaps Srewtape is moonlighting.

                              Comment

                              Working...
                              X