Table Plugin

Gives extra control of table display:

• Allows sorting
• Changing table properties like border width, cell spacing and cell padding
• Changing background color for header cells
• Changing background color for data cells - colors can alternate
• Behaviour can be specified for a specific table using %TABLE{...}% or with global preferences

TablePlugin Global Settings

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

• One line description, 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

• Table border width. Default: 1
  • Set TABLEBORDER = 1

• Table cell padding. Default: 0
  • Set CELLPADDING = 0

• Table cell spacing. Default: 1
  • Set CELLSPACING = 1

• Color for header cells ('*'s around text). Default: #99CCCC
  • #Set HEADER_BG = red

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

• Make sortable:
  • #Set SORT = attachments
  • Set SORT = all
  • #Set SORT = none

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" tableborder="0" cellpadding="3" cellspacing="1" headerbg="#99CCCC" databg="#C8CB8F,#DBDDB5"}%

Num	Status	Action	Who	When	Progress
1	C	Chose new colours	John	1-Dec-02
2	X	Release	John	1-Apr-02
3		Get feedback	Anne	1-Feb-02
12	C	Spec error handling	Jack	1-Dec-02
5		Abc	John

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

Plugin Author:	JohnTalintyre
Plugin Version:	05 Jan 2002
Change History:	05 Jan 2002 PTh: Fixed sorting bug of cells with leading white space 06 Dec 2001 PTh: Fixed date sorting bug 03 Dec 2001 PTh: Fixed sort="off" bug and more 29 Nov 2001: PTh fixed Perl warnings 16 Nov 2001: PTh added table border, cell spacing, cell padding, gif files 07 Oct 2001: Initial version
CPAN Dependencies:	none
Other Dependencies:	none
Perl Version:	5.0
Plugin Home:	http://TWiki.org/cgi-bin/view/Plugins/TablePlugin
Feedback:	http://TWiki.org/cgi-bin/view/Plugins/TablePluginDev

Related Topics: TWikiPreferences, TWikiPlugins

-- JohnTalintyre - 07 Oct 2001
-- PeterThoeny - 05 Jan 2002