• • dd MMM YYYY - hh:mm (MMM is Jan, Feb, etc.)
  • dd-MMM-YY or dd-MMM-YYYY (can be / or space in place of -) (MMM is Jan, Feb, etc)

• • Set TABLEATTRIBUTES = tableborder="1" cellpadding="0" cellspacing="0" valign="top" headeralign="center" headercolor="#ffffff" headerbg="#6b7f93" headerbgsorted="#334455" headercolor="#ffffff" databg="#ffffff,#edf4f9" databgsorted="#f5f5f5,#dce7ee"

• • • #Set TABLEATTRIBUTES = tableborder="1" cellpadding="0" cellspacing="1" headerbg="#99cccc" databg="#ffffff,#ffffcc"

• Row spans

Row spans

Table cells with a single caret indicate follow-up rows of multi-row spans. For example,

| One One | One Two | One Three |
| ^ | Two Two | Two Three |
| Three One | ^ | Three Three |

• Make all tables in a topic sortable. If this is set to all, all tables that have a header row (including those that do not have %TABLE before them) will be made sortable. If set to none, only tables with %TABLE will be sortable. Topic rendering is faster if this is set to none.

• • Set SORT = all

• • Set TABLEATTRIBUTES = tableborder="0" cellpadding="1" cellspacing="1" headerbg="#dadada" headercolor="#000000" databg="#eaeaea, #ffffff"
  • Classic skin table attributes:
    • #Set TABLEATTRIBUTES = tableborder="1" cellpadding="0" cellspacing="1" headerbg="#99CCCC" databg="#FFFFCC, #FFFFFF"

• (Dakar) Visit configure in your TWiki installation, and enable the plugin in the {Plugins} section.

• • dd-MMM-YY or dd-MMM-YYYY (can be / or space in place of -)

Examples

Use of %TABLE{...}%

Table with 4 digit year dates and no use of %TABLE{...}%

• Changing background color and text color for header cells
• Changing background color and text color for data cells - colors can alternate
• Table attributes can be set and overridden in this order:
  • Default TABLEATTRIBUTES Plugin setting in this topic.
  • A TABLEATTRIBUTES preferences setting on site-level (TWikiPreferences) or web-level (any WebPreferences), e.g.
    • Set TABLEATTRIBUTES = tableborder="0" cellpadding="1" ...
  • Before a table using %TABLE{...}%

Sorting

Click on column heading text to sort by a column. Initial column will be sorted in descending order, click again to get ascending order. The type of data in the cell is determined automatically:

• date if format is:
  • dd MMM YYY - hh:mm
  • dd-MMM-YY or dd-MM-YYYY (can be / or space in place of -)
  • MMM is Jan, Feb, etc
• number is digits, with optional decimal point
• otherwise treated as text

• Default table attributes:
  • Set TABLEATTRIBUTES = tableborder="1" cellpadding="0" cellspacing="1" headerbg="#99CCCC" databg="#FFFFCC, #FFFFFF"

Table Attributes

• Table width, e.g. 100% for relative, 640 for absolute width. Default: (not set)
  • Set TABLEWIDTH =

• Background color of header cells ('*'s around text). Choose one of the StandardColors. Default: #99CCCC
  • Set HEADER_BG =

• Text color of header cells ('*'s around text). Default: not specified, e.g. determined by the browser
  • Set HEADER_COLOR =

• Background color of table rows, two alternate colors. Default: #FFFFCC, #FFFFFF

• Text color of table rows, alternate colors. Default: not specified, e.g. determined by the browser
  • Set DATA_COLOR =

Example

Plugin Installation Instructions

Plugin Info

• Vertical alignment of cells. Set to: top, middle, bottom or baseline; default: (empty)
  • Set VALIGN =

• Table header cell alignment. Set to: left, center, right or justify; default: (empty)
  • Set HEADERALIGN =

• Table data cell alignment. Set to: left, center, right or justify; default: (empty)
  • Set DATAALIGN =

• One line description, shown in the TextFormattingRules topic:

• Changing table properties like border width, cell spacing and cell padding

TablePlugin Global Settings

Plugin settings are stored as preferences variables. To reference a plugin setting write %<plugin>_<setting>%, i.e. %INTERWIKIPLUGIN_SHORTDESCRIPTION%

• One line description, is shown in the TextFormattingRules topic:
  • Set SHORTDESCRIPTION = Control attributes of tables and sorting of table columns

• Set DEBUG to 1 to get debug messages in data/debug.txt. Default: 0
  • Set DEBUG = 0

• • Set TABLEBORDER = 1

• • Set CELLPADDING = 0

• • Set CELLSPACING = 1

Per Table Settings

Plugin Installation Instructions

• Download the ZIP file from the Plugin web (see below)
• Unzip TablePlugin.zip in your twiki installation directory. Content:

  File:	Description:
  data/TWiki/TablePlugin.txt	Plugin topic
  data/TWiki/TablePlugin.txt,v	Plugin topic repository
  lib/TWiki/Plugins/TablePlugin.pm	Plugin Perl module
  pub/TWiki/TablePlugin/diamond.gif	Diamond symbol
  pub/TWiki/TablePlugin/down.gif	Down arrow
  pub/TWiki/TablePlugin/up.gif	Up arrow

• Test if the plugin is correctly installed:
  • Check above example if the table renders as expected
  • Try click on heading to sort. Other tables should also be sortable

Plugin Info

Related Topics: TWikiPreferences, TWikiPlugins

• Changing background color for header cells
• Changing background color for data cells - colors can alternate

• • Set DEBUG = off
• Table border width. Default: 1
  • Set TABLEBORDER = 3
• Table cell padding. Default: 0
  • Set CELLPADDING = 5
• Table cell spacing. Default: 1
  • Set CELLSPACING = 2
• Color for header cells ('*'s around text). Default: #99CCCC

• Background color for table rows, two alternate colors. Default: #FFFFCC,#FFFFFF

• Make sortable:

• Short description:
  • Set SHORTDESCRIPTION = Control attributes of tables and sorting of table columns

Table Plugin

Gives extra control off table display:

• Allows sorting
• Changing background colour for header cells
• Changing background colour for data cells - colours can alternate
• Behaviour can be specified for a specific table using %TABLE{...}% or with global preferences

Global Preferences

• Set DEBUG to on to get debug messages in data/debug.txt. Default: off
  • Set DEBUG = on
• Colour for header cells ('*'s around text). Default: #99CCCC
  • #Set HEADER_BG = red
• #Set DATA_BG = #C8CB8F,#DBDDB5
• Set DATA_BG = #FFFFCC,#FFFFFF
• #Set SORT = attachments
• Set SORT = all
• #Set SORT = none

• Set SHORTDESCRIPTION = Control sorting and colours for table display

Sorting

Click on column heading text to sort by a column. Initial column will be sorted in descending order, click again to get ascending order. The type of data in the cell is determined automatically:

• date if format is:
  • dd MMM YYY - hh:mm
  • dd-MMM-YY or dd-MM-YYYY (can be / or space in place of -)
  • MMM is Jan, Feb, etc
• number is digits, with optional decimal point
• otherwise treated as text

Per table settings

On line before the table use %TABLE{...}%:

All default to the global setting

Examples

Line before table: %TABLE{sort="on" headerbg="#99CCCC" databg="#C8CB8F,#DBDDB5"}%

-- JohnTalintyre? - 07 Oct 2001