Help talk:Tables

Let's keep it simple at the top and add tricks in extra sections down the page. Cheers :-) --Rogerhc 07:07, 4 September 2006 (UTC)

Page layout
The Help:Tables page is laid out as follows:
 * Under each heading is a 2 column parent table with the example table nested into its right column and the example's wiki markup in pre tags in the left column.
 * The parent table is width="100%" and the two columns containing the nested tables are each width="50%". Pre tags do not line wrap so please keep the example wikitext lines short within the pre tags, so that the presentation does not get messed up.
 * None of the page's sectional headings, H1, H2, H3, etc. are within tables, except the one in the example of how to do that. This keeps the sections easier to edit.

(Updated above text) --Rogerhc (talk) 06:19, 15 December 2012 (UTC)

Headings in tables
Of course, you can use headings within tables. Your above note on "MediaWiki not supporting this" is wrong. -- :Bdk: 11:11, 4 September 2006 (UTC)
 * Thank you. I have now added a section on Tables with H1, H2, H3 etc. headings. :-) Rogerhc 04:45, 5 September 2006 (UTC)

When using attributes on headings, you must be aware that, although the header starts with an exclamation mark '!', the attributes parameter is still divided by a vertical bar '|'.

Example:

It took me a while to find out why my table was not formatting correctly, until I found the reas, as described here. All worth a change I made in the main HELP page, section 'Basics>Table Headers'. JanEnEm 07:39, 18 July 2011 (UTC)

Tables in Excel (/Calc) converted to Wiki Markup
Is there any software available to convert an "Microsoft Excel" or "Open-Office Calc" table into a MediaWiki markup text document?



Would this be something people would consider usefull, as if it doesn't already exist, and there is a demand, I could a quick, basic one, as I use quite a few tables in my wiki.--Barryred


 * Yes! This would be absolutely helpful! --Nino Gonzales 04:10, 26 January 2007 (UTC)


 * See m:User talk:DBP.--Patrick 08:57, 26 January 2007 (UTC)

I've not tried this as I'm not a Python man but it might help. http://just-tech.blogspot.com/2007/01/python-html-tables-to-mediawiki.html --Dopple 09:27, 18 October 2007 (UTC)

On internet, several converters exists, one is excel2wiki.net

If there was a way for an extension to dynamically create and update an embedded excel (htm) file every time a wiki page loads or every time the excel base file was updated, that would be the coolest thing ever.

couple of conversion methods
With a newer OpenOffice (I have 3.2 on ubuntu 10.04), one can:


 * Open a new spreadsheet, design your table
 * Select your table cells, copy
 * Open a new text document
 * 'Paste Special' the copied  table cells as "HTML (HyperText Markup Language)" ["Formatted text (RTF)" does not seem to preserve formatting like color] in

At this point, one can directly export this table in Writer via File/Export - and choosing 'MediaWiki (txt)' as 'File type' (note that Calc does not have a 'Mediawiki export'; however, Writer does.)
 * Note, however, that this export seems to be buggy, in respect to not recognizing  cells (although, it seems to work with   cells correctly).

A better way for me, was to install wikEd (via Wikipedia:Tools/Editing tools); I installed it as a Greasemonkey script in Firefox.
 * Then, you can copy the html table from, and paste it in a wikEd editor - formatting should be visibly preserved...
 * However, to actually convert it into Mediawiki markup, remember that: "If you want to keep a certain formatting, a link, or a table, you can convert the formatted pasted text into wiki code by pushing the wikify button [w]" (from wikEd_help#Converting_to_wiki_code)
 * This method - through wikEd - seems to not have a problem neither with, nor   cells - nor font color..

A possibly simpler route
A possibly simpler route using Libre Office Calc (and maybe Open Office since they're related): This got about 95% of the formatting correct, which is not bad for this kind of conversion.
 * File, Save As... HTML (Don't export as HTML, as this does something diferent.)
 * Open the new file in notepad etc.. and copy/paste to http://bmanolov.free.fr/html2wiki-tables.php#wiki
 * Click convert. Copy/Paste result to MediaWIki editor.
 * Trim off everything before the first "{|" and after the last "|}" and preview.

NOTE: When I tried "Save as HTML" in MS Excel, it saved it as generated javascript, so I didn't pursue that too far. --Lensman99

Cellpadding doesn't work
Old discussion deleted since this issue was fixed

...but thanks to Splarka for figuring out where the problem was in the CSS and Bdk for fixing it. -- Harry Wood 12:10, 4 January 2008 (UTC)


 * AFAICS this problem still exists. Maybe I am missing something, but:


 * Gives (note the cellpadding="50" above):


 * {| class="wikitable" style="color:green; background-color:#ffffcc;" cellpadding="50"


 * Orange
 * Apple
 * Bread
 * Pie
 * Butter
 * Ice cream
 * }
 * Ice cream
 * }


 * Maybe I am missing something.


 * --Mikepeat (talk) 16:30, 1 June 2014 (UTC)


 * overrides it. That's because cellpadding is not a CSS property, and it's deprecated, while the  class defines the padding on each cell, which is more specific than cellpadding on the table. You should either remove the wikitable class from the table, or specify the padding on each cell  --Ciencia Al Poder (talk) 09:16, 2 June 2014 (UTC)

CSS style background-image not working inside cell style
Inside a cell the style parameter seems not to accept the parenthesis in. See sample code:

Here is the table:

I tried using a template (like the  | ) and tried using &amp;#40; and &amp;#41;. Do I see/do something wrong? How could I solve this? Didn't find anything in the docs or discussions yet...

- 80.254.136.33 - 11:19, 14 February 2008


 * Yeah most CSS within the style attribute should work ok, but I think any mention of 'url' is forbidden. So you can't use background images.
 * I could be wrong about that, but style attribute checking happens in includes/Sanitizer.php in the checkCSS function, and the comments there mention that urls are forbidden.
 * Probably the reason is to prevent certain kinds of minor security issues, people trying malicious CSS tricks. There is a setting Manual:$wgAllowExternalImages which malicious users might try to devise a workaround for, using style urls like this.
 * -- Harry Wood 14:28, 14 February 2008 (UTC)
 * There is a CSS way to fake this, by adding the cell content to a DIV and position it relative to the entire height or width of the image back. I cannot workout the cell-height entirely though.
 * -- Kokkan 01:59 September 19 2010 (CET)


 * You can even add a class to ...?title=Mediawiki:common.css and include the class to the tabel cell

add to common.css, where the path can be path to an uploaded file inside the wiki itself: .MYBACKGROUNDCLASSNAME{ background-image: url(http://MYPATHTO/MYBACKGROUND.png); } You can use more css to format the behavior of the pic. f.e. repeat: norepeat; ...

insert to table cell: class="MYBACKGROUNDCLASSNAME"
 * I don't use this wiki, however, I wish to say this to whoever designed this beautiful, ingenious piece of code: thank you, thank you, thank you. 59.167.155.3 09:20, 5 June 2012 (UTC)

FWIW, I think the previous formatting was easier to read
This is better: http://www.mediawiki.org/w/index.php?title=Help:Tables&oldid=234654

The  foo   content inside of a bordered table is redundant...why use a box in a box?

Why not use  foo  (via   foo  ) instead?

Applicationswhisperer 18:45, 17 February 2009 (UTC)
 * I just tried to make it a little more consistent with other help pages, such as Help:Images and Help:Formatting. --Aotake 22:00, 17 February 2009 (UTC)

Rowspan
Mention rowspan. People will be wondering if it is implemented or not. Best to not leave them guessing. Jidanni 04:15, 26 April 2009 (UTC)

Table Footer?
I noticed that ! denotes a table header, but there doesn't seem to be a tag/indicator for a table footer

There isn't one. 'Bang' (!) corresponds to HTML's  (table header) tag. Pipe (|) corresponds to HTML's  (table data) tag. HTML does not have a 'table footer' tag. - Turing 07:26, 3 September 2009 (UTC) HTML does have a [https://www.w3.org/TR/1998/REC-html40-19980424/struct/tables.html#edef-TFOOT 'table footer' element, since html 4 (1998). The tag is ]. :q! Colin Q Bang (talk) 17:42, 6 October 2017 (UTC)

HTML 5
See also W:MediaWiki_talk:Common.css. Jidanni 18:42, 19 August 2009 (UTC)

Borderless table
Hello everyone, I was wondering if anyone could tell me (or show me) how to make a borderless table, not one with a white border but with no border at all, thanks. Supaman89 (talk) 23:12, 6 October 2009 (UTC)

Answer:

Here is the table:

or

Here is the table:

Try this:

--Ayvengo21 09:28, 12 May 2010 (UTC)

Table Height
Hey, is there a way to specify a height cell- or table-wise? Bud0011 21:12, 25 September 2010 (UTC).

It can be specified cell-wise: Hamilton Abreu 23:53, 25 September 2010 (UTC)
 * Sweet, thank you. On a side note, do you know much about hooks? Bud0011 14:20, 26 September 2010 (UTC).
 * Nope, try Project:Support desk. Hamilton Abreu 16:10, 26 September 2010 (UTC)
 * Ok. Thank you. Bud0011 16:33, 26 September 2010 (UTC).

No text next to table
I have a table on a page: Trouble is the next header gets placed on the right side of the table and now I have to add a lot of br's. How do make up the table so no text is allowed on either side of it?

TIA!
 * Please elaborate on your problem. Examples of what i think you mean are in the collapsed table bellow
 * If you want no text in the next cell to the right, then placing no next cell to the right would help with that (Example #1).
 * If you are looking to clear both the sides of the table,  could help clear the text, like Example 2 bellow.
 * Example #3 uses margins to push the outside text away from the

{| class = "collapsible collapsed" width=100% style = "border-radius: 10px; -moz-border-radius: 10px; -webkit-border-radius: 10px; -khtml-border-radius: 10px; -icab-border-radius: 10px; -o-border-radius: 10px; border: 5px groove #000066;" ! width=25% | Example ! width=75% | Text

TEXT APPEAR OUTSIDE OF TABLE

TEXT APPEAR OUTSIDE OF TABLE


 * }
 * Hope this helps. Bud0011 15:56, 17 January 2011 (UTC).
 * Hope this helps. Bud0011 15:56, 17 January 2011 (UTC).

Tables messed up in theme change
When I changed the customizable page color (for the background), it messed up the wikitables, making the borders a different color and making the backgrounds match. While the matching/transparent background is fine, is there a way to make the borders stay the default black? <span style="border:4px solid; color:#9999CC; padding-top: 1px; background-color: white; -moz-border-radius:12px 12px 12px 12px; -webkit-border-radius:12px 12px 12px 12px; font-weight: bold;"> Neocarleen •  Talk  01:36, 17 February 2011 (UTC)

umm, did you try changing the border color? 58.11.147.228

Multiple Tables - Padding

 * I have a Template that builds a table using the Wiki syntax but when it is shown, instead of each table being on top of each other, there seems to be a natural "padding" or "margin" between the tables. Roughly 15 to 25px buffer between the tables.  Anyone know how i can get rid of this? Example: http://batheo.wikia.com/wiki/Quests/Attack#Rewards
 * Thanx in advance, Goldbishop 20:30, 2 March 2011 (UTC)

Table Restarts number Sequence
Hello people, say does anyone know how to use a table in a number sequence and not have the table restart it? I'll show you what I mean if I didn't make that clear:
 * 1) test
 * 2) test
 * 3) test
 * 4) See how the numbers start over at One here.
 * 5) How do I fix this???

March 8th 10:13am CST 2011

Table needs NewLine, which stops sequences. One solution is to manually start again the list with fixed number, using the  and   codes:


 * 1) test
 * 2) test
 * 3) test

<li>See, the numbers don't start over at One here. </li> <li>This is a possible fix</li> <li>But you have to manually fix the starting number to 4</li> </ol>

Align not working?
I've noticed that the align used in tables does not work anymore, even on older mediawiki versions? Any explanations?

See https://bugzilla.wikimedia.org/show_bug.cgi?id=36495 Cursich (talk) 22:38, 22 February 2013 (UTC)

Different text-align for different columns
How do I set up the wikitables so that the first column is align:left and the last column is align:right?

Advanced Layout
Can anyone advise on the best way to create the following layout, I'm creating a table with an Icon, then 8 pieces of data to the right of that, then another icon and 8 pieces of data adjacent.

This is my code;

! colspan="2" align="left" | <font face="Arial Black" size="5" style="text-transform: uppercase;"> Heading A ! colspan="2" align="left" | <font face="Arial Black" size="5" style="text-transform: uppercase;"> Heading B ! align="left" | Item A Detail 1: ! align="left" | Item B Detail 1: ! align="left" | Item A Detail 2: ! align="left" | Item B Detail 2: ! align="left" | Item A Detail 3: ! align="left" | Item B Detail 3: ! align="left" | Item A Detail 4: ! align="left" | Item B Detail 4: ! ! align="left" | Item B Detail 5: ! ! align="left" | Item B Detail 6: ! !
 * rowspan="8" valign="top" width="120" | [[File:Information.png|]]
 * rowspan="8" valign="top" align="center" width="150" | [[File:Example.jpg|]]
 * Item A Info 1
 * Item B Info 1
 * Item A Info 2
 * Item B Info 2
 * Item A Info 3
 * Item B Info 3
 * Item A Info 4
 * Item B Info 4
 * Item B Info 5
 * Item B Info 6

Result:

This is repeated down the page to allow for several levels of icons and their respective data, Nested templates sounds like a cleaner way to present this, however I've heard nested templates are a bad way to go from an SEO perspective, however the alternative means data in the wiki syntax is non sequential, So I'm jumping from Item A to Item B, which can't be good practise and mess up SEO?

Is there a better way to do this kind of layout, that is cleaner and will not affect SEO?

Repeating headers
In a large table, it might be user-friendly to repeat the header every 20 or ? rows. Might it be possible to add an option to the header that tells mediawiki to repeat the header automatically?

Simple one-pixel table border
I don't understand what this section is about. It may be better moved to a Help:Advanced Tables page. I will leave it in the Help:Tables page for now. But someone may want to remove it. Really, how does it help folks? Who is going to want all that cruft in their wiki markup? --Rogerhc (talk) 06:08, 15 December 2012 (UTC)

Fixed your grammar mistake. 58.11.147.228 00:06, 8 May 2013 (UTC)

Text is overriding row height even if the font is small
I tried pixels and percentages and it only works if the entire row is empty, even if I set the font size with the html font tag to somethign really small, it doesn't work. How can I edit the actual classes for my wiki?--88.104.102.18 12:42, 2 April 2013 (UTC)
 * It seems I can only make the row height bigger, not smaller, small font sizes still do not work, I have tiny text surrounded by pointless space.

Table centering?
How to center tables in the middle of a page? 58.11.147.228 00:04, 8 May 2013 (UTC) Place your tables between the center tag


 * Don't do that! Use . I've updated the page explaining it. --Ciencia Al Poder (talk) 11:07, 14 December 2013 (UTC)

too complex for the average editor
"The default table formatting uses the "border-collapse: separate" model, which adds table cell spacing (which also separates the table outer border from its content cells). Even with a zero cellspacing, the borders of consecutive cells (and of the overall table container) will add up, so to get a one-pixel separation between cells, you need to selectively remove one or more of the four borders of cells.

Such tables may be formatted more simply, using the "border-collapse: collapse" CSS property; in this table formatting model, the cellspacing attribute (or the CSS "border-spacing:" property) and the table's "padding:" CSS property is ignored and only the larger border of adjacent inner cells (or the table border for outer cells) will be used.

An example of the above for one-pixel table border, using each model (without need for external extensions):"

really? too complex for the average editor to understand or care about. Igottheconch (talk) 15:38, 11 October 2013 (UTC)

In wikitable change the font colore to better readable
There can i change the font color in the last table (Sample 3), the colore can't change to a other on

Sorry for my bad english ;) --Shadowslight (talk) 12:27, 21 October 2013 (UTC)

Problem with Vertical align on nested tables
So I have a big table with lots of rows and columns inside a small 2 columns table, the table is nested on the 1st colummn and I want to have simple text, vertical aligned on the second column, but I can't figure it out because even after creating the table and assigning the valign attribute the text does not centers vertically. Any help with this? --Kanecow (talk) 12:31, 30 January 2014 (UTC)

Automatically Summing Table Column
If you allow Raw HTML and JavaScript in your mediawiki installation, then you can use this script below to sum up your columns as you would in a spreadsheet. --Brett.Dutton (talk) 00:57, 25 June 2014 (UTC)

Add this to LocalSettings.php

$wgRawHtml = true;

<script type="text/javascript"> function sumColumn( id, col ) { var total = 0; var mytable = document.getElementById( id ); for ( var v=1; v < mytable.rows.length - 1; v++ ) { total += parseInt( mytable.rows[v].cells[col].innerHTML ); }       document.getElementById( id + '_sum' ).innerHTML = total; }   sumColumn('resource', 1 );

Making long table a "two-column" layout on the page
It there a way to make a very long table (with multiple columns within the table itself) into two side-by-side sections on page in a "two-cloumn" format (similar to breaking up a long list of footnotes into a multi-column section of footnotes)...? Lestatdelc (talk) 02:18, 9 February 2016 (UTC)

XHTML, HTML 5 and attributes
This page talks a lot about XHTML, but the (default) output of MediaWiki is actually HTML 5. Should all references be changed to "HTML"? In particular the section "XHTML attributes" links to the HTML 4.01 spec, which is obviously neither the XHTML spec nor the spec for HTML 5. I can only assume this is a mistake. Considering the first release of MediaWiki was in 2002, two years after the XHTML 1.0 spec, did it ever output HTML 4.01?

Second, this page currently suggests using,  ,   and   table attributes. But these have all been deprecated since HTML 4.01 and are all obsolete in HTML 5 (except that  or   may be used to indicate a table that is not used for layout); using them results in invalid HTML 5, though browsers are generally patient enough to respect them. The spec provides that these should be replaced with CSS. Unfortunately you can't do this for a table created with wiki markup because you can't add CSS inline (unless the CSS extension is enabled, which it isn't on Wikimedia) and there is no markup for. Hairy Dude (talk) 19:29, 4 March 2016 (UTC)
 * I took the liberty of replacing the outdated reference to the HTML 4.01 spec with the current one. Hairy Dude (talk) 19:36, 4 March 2016 (UTC)

Showing/hiding certain rows based on parameters
I would like to build a table that hides rows with certain parameters unless a box is ticked.

[x] Show params 2 and 3

In this example, I would like items 2, 4, and 5 to be hidden by default because they have Params 2 and 3.

[_] Show params 2 and 3

Is this possible? If so, how would I go about doing this?


 * MediaWiki doesn't provide a way to do that. It can only be done with JavaScript. You should ask on any JavaScript support forum how to do that. Once you got a working JavaScript code, you can load it in MediaWiki following Manual:Interface/JavaScript --Ciencia Al Poder (talk) 15:49, 31 December 2016 (UTC)

Wikimarkup -> html conversion
Hi, does anyone have a function to convert Wikitables to normal html tables in a Lua module ? Wikitables sometimes have a weird behavior indide template, and that's a problem. See Commons:Module talk:Artwork. --Zolo (talk) 11:52, 12 March 2017 (UTC)

Reverted edit

 * Just a temporary note: Current Problem, with using tables. If you use the clipboard, while splitting large tables horizontally and edit undo and then repeat, edit undo, and then do it vertically. It sometimes stops functioning the Save feature of Open Office and then eventually the program fails.


 * What Exactly Happened. 60 plus row, Colum 3. In the clipboard was pasting of titles for the left. Spilt the cells in the middle, horizontal, Undo, then split vertical, System crashed repeatedly. Thought it was the internet, so started working offline, it happened 9 times in the last hour of working with the program, with the intent to create the problem again. So I would say its a repeatable error.

I have no idea where this is supposed to go, but it shouldn't go were it original was placed (Special:Diff/2505694/2528418) &mdash; Mainframe98 talk 08:42, 1 August 2017 (UTC)

transcluding into a cell
Plain text works alright ie. Enclosing page name in curley braces

This Does not transclude

Help please Mikhat (talk) 02:14, 29 October 2017 (UTC)

Try to transclude the contents of the cell and not the cell itself. --Ciencia Al Poder (talk) 16:19, 29 October 2017 (UTC)

Global "Show/Hide All" button
I have a wiki page on which there will be 25 tables, each with 200 rows. For easier navigation, only the current table is expanded. All of the other tables are collapsed. Eventually all of the tables will start up collapsed. However, users may want to search for content that may appear in any of the tables. To search for content in all of the tables via the browser search function, it will be necessary to first expand all of the tables. Hence, I am looking for some way to create a button that would "Show/Hide All". (To manually expand all 25 tables would be extremely tedious.)

Somewhere I found a suggestion to add some code to the MediaWiki:Common.js page: $(function {   $('#collapse-global').html('<a class="mediawiki-button" onclick="for (var i=0; i<50; i++) { "wikitable sortable collapsible collapsed"([i]); }">Show/Hide All</a>'); });

Afterwards, a button may be loaded on the relevant page with: Loading...

The button appears on the page, but it does nothing. So I assume that the js code is incorrect. Is there anyone who can provide the correct code or guide me on how to achieve the desired result? --Abhidevananda (talk) 12:37, 2 November 2017 (UTC)


 * Use this code:

$(function {	var $collapseglobal = $('#collapse-global');	if ( $collapseglobal.length > 0 ) {		$collapseglobal.html('');		$('<a class="mediawiki-button">Show/Hide All</a>').on('click', function { $('a.mw-collapsible-text').trigger('click.mw-collapsible'); }).appendTo($collapseglobal);	} });
 * Note it will toggle the current state of each collapsible individually, not make all of them visible/hidden, which seems to be more complicated --Ciencia Al Poder (talk) 10:41, 3 November 2017 (UTC)


 * Thanks for the suggestion, Ciencia Al Poder. I have tried adding that code to the bottom of my MediaWiki:Common.js file and tested the button. As with the previous code, this one too seems to do nothing at all except load the button on to my test page. But clicking the button has no impact on the status of the tables. You may see my MW:Common.js file with your code in it here and test it here. Also, what I really need is to be able to expand all of the tables with a single click. Would your code do that? --Abhidevananda (talk) 13:28, 3 November 2017 (UTC)


 * My code works only for Manual:Collapsible elements made with "mw-collapsible" class, not other custom collapsible things. Your wiki seems to be using a different collapsible code. Also, some script of your wiki seem to cause an error, at least one appears in the error console, which may cause some scripts to not function properly. My code will expand all tables if all tables are collapsed. --Ciencia Al Poder (talk) 16:14, 3 November 2017 (UTC)


 * Thanks. I am pretty sure that we don't use any custom collapsible code, but I also see various errors on the page. This is probably the consequence of a recent MediaWiki upgrade of several major versions. I will look into it and see if resolving those errors solves the problem. --Abhidevananda (talk) 17:16, 3 November 2017 (UTC)


 * I have resolved the various minor errors that could be resolved (by one with the limited skills that I have). In the error console for Internet Explorer and Microsoft Edge, there are 0 errors showing. In Firefox (x64), there remain two errors, both of which apparently relate to Java (which is not supported by the 64-bit Firefox). That said, the Show/Hide All button does not work in any of the browsers. So it does not appear that the remaining errors that show up in Firefox have anything to do with the functionality of the button. And that brings us back to the question of "different collapsible code"... and I really have no idea why or how my wiki would be using that. Any suggestions about where to look or what to change? --Abhidevananda (talk) 04:58, 4 November 2017 (UTC)


 * Your table is using class="collapsible" which is a custom functionality provided by your MediaWiki:Common.js (search for it on the page), whereas you should use class="mw-collapsible" for my code to work, since this is the "integrated" collapsible code provided by MediaWiki, which I linked before. --Ciencia Al Poder (talk) 11:51, 4 November 2017 (UTC)


 * Ciencia, first let me say that I totally, really, greatly appreciate your help and advice. But I am completely out of my depth here. I have followed your link to Manual:Collapsible elements and copied the source code under Collapsible tables into my MediaWiki:Common.js file (replacing and reverting version 2.0.3 with version 2.0.2). But this had no noticeable effect. I also tried a number of other minor changes, but none of them achieved anything... except occasionally to break the collapsible function altogether. So, after all my testing, I am right back where I started. If you might be interested to take on a consulting administrative role on my humble wiki, I'd be most happy to have you on board. Regrettably, my former technical genius and admin, a great man, seems to have retired. --Abhidevananda (talk) 14:31, 4 November 2017 (UTC)