History: PluginFancyTable
Preview of version: 41
- «
- »
Plugin FancyTable
This plugin displays the data using the Tiki odd/even table style.
Usage
The data (and the head parameter) is given one row per line, with columns separated by ~|~ (or separated by | starting with 4.0).
To display a fancy table in a wiki page, use the syntax:
Copy to clipboard
{FANCYTABLE(head=h1c1|h1c2|h1c3>>h2c1|h2c2|h2c3 , headclass= , headaligns=left|right|center|justify , headvaligns=top|middle|bottom|baseline , colwidths= , colaligns=left|right|center|justify , colvaligns=top|middle|bottom|baseline , sortable= , sortlist= )}cells{FANCYTABLE}
Copy to clipboard
{FANCYTABLE(head=> ,headclass=> )}cells{FANCYTABLE}
| Parameter | Accepted values | Effect | Optional | Since |
|---|---|---|---|---|
| head | text separated by | (starting with 4.0) or ~ | ~ (all versions) for each cell separate by >> for each header row (with 4.2) |
Creates specially formatted header cells and rows | optional | |
| (body - between FANCYTABLE tags) | text separated by | (starting with 4.0) or ~ | ~ (all versions) for each cell | Creates cells in the body of the table. Start a new line to start a new row. | required | |
| headclass | Any valid CSS class | Applies class styling to the header rows | optional | 2.0 |
| sortable | y or n | allows to be able to sort the columns with javascript | optional | 4.0 |
| sortlist | [0,1],[1,0]... Pairs of numbers for: [columnIndex, sortDirection],... where columnIndex is a zero-based index for the columns left-to-right, and sortDirection is 0 for ascending and 1 for descending. Example that sorts ascending first by column 1 and then column 2: [0,0],[1,0] |
Table is initially pre-sorted according to this setting. | optional | 4.0 |
| (in any cell) | one or more forward slashes (/) or backslashes (\) at the beginning of the cell | Cell will span the number of columns indicated by the number of forward slashes, and will span the number of rows indicated by the number of backslashes. | optional | 4.0 |
| headaligns colaligns |
left right center justify |
Aligns text horizontally in header columns (headaligns) or table body columns (colaligns). Separate setting for each column by a | | optional | 4.1 |
| headvaligns colvaligns |
top middle bottom baseline |
Aligns text vertically in header columns (headvaligns) or table body columns (colvaligns). Separate setting for each column by a | | optional | 4.1 |
| colwidths | number of pixels followed by 'px', or percent followed by '%', for each column separated by a | | Sets the width of the columns | optional | 4.1 |
Note
Sorting a table with cells that span multiple columns or rows can give unexpected results.
Example
Example:
|
This code: Copy to clipboard
|
. |
Would produce:
|
|
This code: Copy to clipboard
|
. |
Would produce:
|
Sort
Available starting with TikiWiki version 4.0
The sortable parameter uses jquery, so the following must be enabled for it to work:
- Go to Admin home > Editing and Plugins > Plugins (tab) and click on jq to enable the wikiplugin jq.
- Go to Admin Home > Look and Feel > UI Effects and click on "JQuery Sortable Tables".
See a live example in the table above showing the fancytable parameters. See http://tablesorter.com for more information on the base jq plugin being used.