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 page is laid out as follows:
 * Under each heading is a 2 column parent table with the example table nested into its left column and the example's wiki markup in pre tags in the right column.
 * The parent table is width="100%" and the two columns containing the nested tables are each width="50%". Pre tags containing long lines in the right column override its width="50%" attribute in most browsers which is good flexible browser behavior.
 * 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 avoids the to some confusing problem that when one previews an edit section within a parent table the parent table previews as broken; broken because the part of it above the edit section previewed is outside of and thus not parsed in the section previewed.

This will work well in most browsers I think.

Let us know if the layout breaks anything in your browser and which browser and version that is.

--Rogerhc 17:44, 4 September 2006 (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)

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

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..

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)

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"

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 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).