(anonymous guest) (logged out)

Copyright (C) by the contributors. Some rights reserved, license BY-SA.

Sponsored by the Wiki Symposium and the Nuveon GmbH.

 
View Attach Info

Add new attachment

Only authorized users are allowed to upload new attachments.

This page (revision-47) was last changed on 15-Oct-2007 17:39 by YvesPiguet  

This page was created on 23-Nov-2006 15:45 by ChuckSmith

Only authorized users are allowed to rename pages.

Only authorized users are allowed to delete pages.

Difference between version and

At line 3 added 53 lines
!!! Summary as of 1 Dec 2006
!! Purely single pipes to separate cells
*Instiki
*PBWiki
*TWiki
*TiddlyWiki
*XWiki
!! Single pipes for content, Other for headers
*Confluence (uses || to separate headers)
*DokuWiki (uses ^ to separate headers)
*JSPWiki (uses || to separate headers)
*MicKI ( use |# to separate headers)
!! Purely double pipes to separate cells
*FlexWiki
*MoinMoin
*Oddmuse
*PmWiki
*TracWiki
*UseMod
!!! Rows versus Columns
I think there are two ways, column and row orientation. Most wikis are row oriented. For some tasks rows are better, for some tasks columns are better. I'm astonished that not more wikis implement column based tables (perhaps because HTML, LaTeX are row oriented).
{{{
>> Header1
> column1, row1
> column1, row2
> column1, row3
>> Header2
> column2, row1
> column2, row2
> column2, row3
}}}
This is easy to cut and paste, doesn't interfere with long lines, line breaks or markup. It's easy to add rows and easy to add columns. Hard thing is to find the right row when there are lots of rows and few columns (row orientation might be better then). Harder to implement than row orientation, because HTML is row
oriented. Multi row is easy
{{{
>,> rowspan 2
}}}
but column span is more difficult. Could be done with an empty line
-StephanSchmidt
At line 88 added 4 lines
At line 93 added 62 lines
There are two ways for describing Tables.
!use "|" as delimiter
Example:
{{{
| row1-column1 | row1-columun2 |
| row2-column1 | row2-columun2 |
}}}
There are some commands to control table of elements.
"LEFT: CENTER: RIGHT: BGCOLOR(color): COLOR(color): SIZE(num): "
Example:
{{{
|LEFT:row1-column1 |RIGHT:row1-columun2 |
}}}
* You can control the formats of line with character "c" at the end. The commands to control elements are the same as avobe.
* You can make the line as header line (thead) with character "h" at the end.
* You can make the line as footer line (tfoot) with character "f" at the end.
* You can make the elements as a header (th) with character "~" in front of an element.
* Single element ">" means column-span, unite it to the right cell.
* Single element "~" means row-span, unite it to the upper cell.
!use CSV format
Example:
{{{
,row1-column1,row1-columun2,
,row2-column1,row2-columun2,
}}}
You can also write elements with double-quotation(").
{{{
,"row1-column1","row1-columun2",
,"row2-column1","row2-columun2",
}}}
* Single element "==" means column-span, unite it to the right cell.
* You can move the side of the elements with a space insert at the side.
Left side:
{{{
,left ,
}}}
Centering:
{{{
, center ,
}}}
Right side:
{{{
, right,
}}}
At line 165 added 6 lines
!Simplest table:
{{{
|| border=1
|| cell 1 || cell 2 || cell 3 ||
|| cell 1 || cell 2 || cell 3 |
}}}
At line 172 added 4 lines
[More advanced tables|http://www.pmwiki.org/wiki/PmWiki/Tables]
[Table directives, that helps to format tables in PmWiki|http://www.pmwiki.org/wiki/PmWiki/TableDirectives]
At line 49 changed 3 lines
^Hading 1 ^ Heading 2
|Cell 1.1 | 1.2
|Cell 2.1 | 2.2
^Hading 1 ^ Heading 2 ^
|Cell 1.1 | 1.2 |
|Cell 2.1 | 2.2 |
At line 187 added 9 lines
{{{
|!heading1|!heading2|
|>| colspan |
| rowspan |left|
|~| right|
|colored| center |
|caption|c
}}}
At line 61 changed one line
|__Heading 1__|__Heading 2__
|| Heading 1 || Heading 2
At line 203 added one line
At line 206 added 17 lines
*Table with border
{{{
#|
||cell11|cell12|cell13||
||cell21|cell22||
|#
}}}
*Table without border, 100% width
{{{
#||
||cell11|cell12|cell13||
||cell21|cell22||
||#
}}}
At line 224 added 9 lines
{{{
{table}
Category | Sales (K€)
Category 1 | 100
Category 2 | 50
Category 3 | 50
Total | =sum(B2:B4)
{table}
}}}
At line 234 added 53 lines
{{{
||'''Column A'''||'''Column B'''||'''Column C'''||
||Entry for row 1, Column A||Entry for row 1, Column B||Entry for row 1, Column C||
||Entry for row 2, Column A||Entry for row 2, Column B||Entry for row 2, Column C||
||||Spanning entry|| Entry for row 3, Column C ||
||||||More spanning||
}}}
More details: [UseMod Table Formatting|http://www.usemod.com/cgi-bin/wiki.pl?TextFormattingRules/WikiTables]
!![Oddmuse]
!Simple tables:
{{{
||'''A'''||'''B'''||'''C'''||
||1 ||2 ||3 ||
}}}
Whitespace controls alignment (left, center, right).
Empty cells are fused.
!Complex tables:
{{{
<table pos/r, country/l, oda/r>
pos=Rank
country=Country
oda=%GNP
pos=1
country=Norway
oda=0.92
pos=2
country=Denmark
oda=0.84
pos=3
country=Netherlands
oda=0.81
pos/c=...
pos=9
country=Switzerland
oda=0.38
pos/c=...
pos=22
country=United States
oda/mark/r=0.14
----
}}}
Result:
http://www.oddmuse.org/cgi-bin/oddmuse/download/Long_Table_Markup_Extension_Screenshot
Columns are labelled, cells are created by assigning to labels. Cells can contain multiple paragraphs, lists, etc. CSS classes can be added per table, per column, or per cell. Missing cells are fused with neighbours.
At line 289 added 6 lines
{{{
||Containers||(n)||
||MIL||(y)||
||Managed Code||(b)||
||After work||(d)||
}}}
At line 296 added 4 lines
{{{
|a|table|row|
|b|table|row|
}}}
At line 302 added 4 lines
{{{
||Cell 1||Cell 2||Cell 3||
||Cell 4||Cell 5||Cell 6||
}}}
At line 307 added 16 lines
!![ProWiki]
The simple example uses the "|" as default separator string which can be redefined. ProWiki uses CDML syntax for tables.
{{{
[[table]
January | February | March | April
Max | 37.5 | 32.7 | 28.0 | 25.3
Min | 31.3 | 26.8 | 25.1 | 18.7
]
}}}
More complex examples can be created by adding parameters that work for the table or specifying properties of cells individually.
[ProWiki 17 table parameters|http://www.prowiki.org/prowiki/wiki.cgi?CdmlTable]
At line 326 added 10 lines
{{{
|| || January || February || March || April ||
| Max | 37.5 | 32.7 | 28.0 | 25.3 |
| Min | 31.3 | 26.8 | 25.1 | 18.7 |
The double pipes are only required if you'd like nice grey backgrounds as table headers
}}}
At line 337 added 9 lines
* Table rows can be made by beginning and ending a line with <raw>|</raw> (vertical bar). The content of the row is placed between the bars. If more than one cell is desired for any particular row, an additional <raw>|</raw> is used as the separator.
* Adjacent table rows will be automagically combined into a single table.
{{{
|Look Mom!|A table!!|
|a|b|
|c|d|
}}}
At line 83 changed one line
!!Other Wiki Engines
!!!Other Wiki Engines
!![MicKI]
[MicKI help|http://michai.dyndns.org/cgi-bin/micki?help] (including [table syntax and examples|http://michai.dyndns.org/cgi-bin/micki?help#21])
{{{
|# Heading 1 |# Heading 2 |
| Cell 1.1 | Cell 1.2 |
| Cell 2.1 | Cell 2.2 |
}}}
Note that '|#' notation is not exclusively reserved for headers; use it on any cell to make it stand out from the rest. Color schemes are defined through configuration file.
!![SdiDesk]
Simple table with double-commas as item separators. Optional column headings if you separate from body with a line containing four underscores.
{{{
apples,, oranges,, mangos
____
34,, 434,, 65
63,, 653,, 34
2,, 43,, 43
}}}
At line 373 added 43 lines
!!!Other Markup
!!Textile
{{{
|a|table|row|
|a|table|row|
}}}
!!Org-mode (Emacs)
{{{
| Name | Phone | Age |
|-------+-------+-----|
| Peter | 1234 | 17 |
| Anna | 4321 | 25 |
}}}
[Org-mode|http://staff.science.uva.nl/~dominik/Tools/org/]'s table editor is available as a "minor mode" that can be used in just about any text document.
!!Emacs-wiki and Muse mode
{{{
Double bars || Separate header fields
Single bars | Separate body fields
Here are more | body fields
Triple bars ||| Separate footer fields
}}}
[Emacs wiki|http://www.emacswiki.org/cgi-bin/wiki/EmacsWikiMode] has been superceded by [Muse|http://www.emacswiki.org/cgi-bin/wiki/EmacsMuse].
!!Comma-Separated Values (CSV)
Defined at [RFC:4189].
Very popular and widespread markup. Practically every spreadsheet has an option of importing/exporting it. MoinMoin wiki supports in default configuration (Note: Name implies commas as the field separators. In practice any predefined character can be used including pipe "|" -- but the semicolon is most common and widespread). See also [Wikipedia:Comma-separated_values].
Example:
{{{
Heading 1, Heading 2
Cell 1.1, "Cell 1.2 containing a , comma"
Cell 2.1, "Cell 2.2 containing a "" double quote"
"Cell 3.1 containing a
line break", "Cell 3.2 containing a trailing space "
}}}
Version Date Modified Size Author Changes ... Change note
47 15-Oct-2007 17:39 9.543 kB YvesPiguet to previous restore (vandalism)
46 15-Oct-2007 11:56 9.559 kB 129.123.104.8 to previous | to last
45 26-Sep-2007 09:43 9.543 kB ChuckSmith to previous | to last restore
44 26-Sep-2007 01:24 9.589 kB 60.190.243.173 to previous | to last
43 26-Sep-2007 01:23 9.57 kB 63.241.9.240 to previous | to last
42 26-Sep-2007 01:22 9.558 kB 203.69.39.251 to previous | to last
41 03-Jan-2007 14:33 9.543 kB RadomirDopieralski to previous | to last CSV
« This page (revision-47) was last changed on 15-Okt-2007 17:39 by YvesPiguet