• 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