TWiki Home Lash La Rue . TWiki . TablePlugin (r1.1 vs. r1.22) Lash La Rue webs:
Main | TWiki? | Know? | Test?
TWiki . { Home? | Welcome | Register | Changes | Index | Search | Go }
 <<O>>  Difference Topic TablePlugin (r1.22 - 02 Aug 2004 - PeterThoeny?)
Line: 1 116 to 1 116
Changed:
<
<
Plugin Version: 21 Mar 2004
>
>
Plugin Version: 01 Aug 2004
Line: 118 to 118
Changed:
<
<
21 Mar 2004: PTh: Internal change: Fixed reference to inofficial variable
>
>
01 Aug 2004: AC: Added CSS support for first column and ascending/descending table headers
21 Mar 2004: PTh: Internal change: Fixed reference to unofficial variable
Line: 142 to 143
Changed:
<
<		 -- TWiki:Main/PeterThoeny - 21 Mar 2004
>
>		 -- TWiki:Main/PeterThoeny - 01 Aug 2004

 <<O>>  Difference Topic TablePlugin (r1.21 - 21 Mar 2004 - PeterThoeny?)
Line: 1 116 to 1 116
Changed:
<
<
Plugin Version: 01 Jan 2004
>
>
Plugin Version: 21 Mar 2004
Line: 117 to 118
Added:
>
>
21 Mar 2004: PTh: Internal change: Fixed reference to inofficial variable
Line: 141 to 142
Changed:
<
<		 -- TWiki:Main/PeterThoeny - 01 Jan 2004
>
>		 -- TWiki:Main/PeterThoeny - 21 Mar 2004

 <<O>>  Difference Topic TablePlugin (r1.20 - 02 Jan 2004 - PeterThoeny?)
Line: 1 116 to 1 116
Changed:
<
<
Plugin Version: 01 Dec 2003
>
>
Plugin Version: 01 Jan 2004
Line: 117 to 118
Added:
>
>
01 Jan 2004: PTh: Alternating data row colors restart again after each header row
Line: 140 to 141
Changed:
<
<		 -- TWiki:Main/PeterThoeny - 01 Dec 2003
>
>		 -- TWiki:Main/PeterThoeny - 01 Jan 2004

 <<O>>  Difference Topic TablePlugin (r1.19 - 25 May 2003 - PeterThoeny?)
Line: 1 21 to 1 21
Changed:
<
<
    • dd-MMM-YY or dd-MM-YYYY (can be / or space in place of -)
>
>
    • dd-MMM-YY or dd-MMM-YYYY (can be / or space in place of -)
Line: 73 to 73
Changed:
<
<

Example

>
>

Examples

Use of %TABLE{...}%

Line: 86 to 89
Added:
>
>

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

When
1-Jan-2004
1-Jan-2003
2-Jan-2005
Line: 106 to 115
Changed:
<
<
Plugin Author: JohnTalintyre, PeterThoeny
Plugin Version: 24 May 2003
>
>
Plugin Author: TWiki:Main/JohnTalintyre, TWiki:Main/PeterThoeny
Plugin Version: 01 Dec 2003
Line: 109 to 118
Changed:
<
<
24 May 2003: PTh: New |^| rule for multi row span (TWiki:Main/WalterMundt); added tableframe and tablerules (TWiki:Main/JohannesMartin); ignore columnwidths for multi column span; validate headerrows and footerrows (TWiki:Main/DarrylGreen)
>
>
01 Dec 2003: PTh: Fixed error when footerrows was specified on an empty table, contributed by TWiki:Main/PaulineCheung
24 May 2003: PTh: New |^| rule for multi row span (TWiki:Main/WalterMundt); added tableframe and tablerules (TWiki:Main/JohannesMartin); ignore columnwidths for multi column span; validate headerrows and footerrows (TWiki:Main/DarrylGreen); fixed link color problem and up/down icon color problem for dark header background
Line: 129 to 139
Changed:
<
<		 -- JohnTalintyre - 07 Oct 2001
-- PeterThoeny - 24 May 2003
META FILEATTACHMENT up.gif attr="" comment="Up arrow" date="1005707580" path="C:\Data\Temp\up.gif" size="876" user="PeterThoeny" version="1.1"
META FILEATTACHMENT down.gif attr="" comment="Down arrow" date="1005707591" path="C:\Data\Temp\down.gif" size="869" user="PeterThoeny" version="1.1"
META FILEATTACHMENT diamond.gif attr="" comment="Diamond symbol" date="1005707607" path="C:\Data\Temp\diamond.gif" size="881" user="PeterThoeny" version="1.1"
>
>		 -- TWiki:Main/JohnTalintyre - 07 Oct 2001
-- TWiki:Main/PeterThoeny - 01 Dec 2003
META FILEATTACHMENT up.gif attr="" comment="Up arrow" date="1053858559" path="C:\Data\2003\ThMail\up.gif" size="867" user="PeterThoeny" version="1.3"
META FILEATTACHMENT down.gif attr="" comment="Down arrow" date="1053858544" path="C:\Data\2003\ThMail\down.gif" size="867" user="PeterThoeny" version="1.3"
META FILEATTACHMENT diamond.gif attr="" comment="Diamond symbol" date="1053858211" path="C:\Data\2003\ThMail\diamond.gif" size="881" user="PeterThoeny" version="1.8"

 <<O>>  Difference Topic TablePlugin (r1.18 - 25 May 2003 - PeterThoeny?)
Line: 1 51 to 1 51
Changed:
<
<
sort Set table sorting on or off sort="on"
initsort Column to sort initially (1 to number of columns) initsort="2"
initdirection Initial sorting direction for initsort, set to up or down initdirection="up"
>
>
sort Set table sorting "on" or "off" sort="on"
initsort Column to sort initially ("1" to number of columns) initsort="2"
initdirection Initial sorting direction for initsort, set to "up" or "down" initdirection="up"
Line: 58 to 59
Added:
>
>
tableframe Table frame, set to "void" (no sides), "above" (the top side only), "below" (the bottom side only), "hsides" (the top and bottom sides only), "lhs" (the left-hand side only), "rhs" (the right-hand side only), "vsides" (the right and left sides only), "box" (all four sides), "border" (all four sides); default "void" tableframe="hsides"
tablerules Table rules, set to "none" (no rules), "groups" (rules will appear between row groups and column groups only), "rows" (rules will appear between rows only), "cols" (rules will appear between columns only), "all" (rules will appear between all rows and columns); default "none" tablerules="rows"
Line: 61 to 63
Changed:
<
<
valign Vertical alignment of cells, set to top, middle, bottom or baseline valign="top"
headeralign Header cell alignment, set to left, center, right or justify. Overrides individual cell settings headeralign="left"
dataalign Data cell alignment, set to left, center, right or justify. Overrides individual cell settings dataalign="center"
>
>
valign Vertical alignment of cells, set to "top", "middle", "bottom" or "baseline" valign="top"
headeralign Header cell alignment, one value for all columns, or a comma separated list for different alignment of individual columns. Set to "left", "center", "right" or "justify". Overrides individual cell settings headeralign="left, right"
dataalign Data cell alignment, one value for all columns, or a comma separated list for different alignment of individual columns. Set to "left", "center", "right" or "justify". Overrides individual cell settings dataalign="center"
Line: 66 to 68
Changed:
<
<
headerrows Number of header rows to exclude from sort; default 1 headerrows="1"
footerrows Number of footer rows to exclude from sort; default 0 footerrows="1"
>
>
headerrows Number of header rows to exclude from sort; default "1" headerrows="1"
footerrows Number of footer rows to exclude from sort; default "0" footerrows="1"
Line: 105 to 107
Changed:
<
<
Plugin Version: 17 Dec 2002
>
>
Plugin Version: 24 May 2003
Line: 106 to 109
Added:
>
>
24 May 2003: PTh: New |^| rule for multi row span (TWiki:Main/WalterMundt); added tableframe and tablerules (TWiki:Main/JohannesMartin); ignore columnwidths for multi column span; validate headerrows and footerrows (TWiki:Main/DarrylGreen)
Line: 108 to 111
Changed:
<
<
15 Dec 2002: PTh: Added headerrows and footerrows params (TWiki:Main/WoutMertens); added tablewidth and columnwidths params (TWiki:Main/ThorstenSommermann)
>
>
15 Dec 2002: PTh: Added headerrows and footerrows params (TWiki:Main/DarrylGreen, TWiki:Main/WoutMertens); added tablewidth and columnwidths params (TWiki:Main/ThorstenSommermann)
Line: 127 to 130
Changed:
<
<		 -- PeterThoeny - 17 Dec 2002
>
>		 -- PeterThoeny - 24 May 2003

 <<O>>  Difference Topic TablePlugin (r1.17 - 03 May 2003 - PeterThoeny?)
Line: 1 53 to 1 53
Changed:
<
<
initdirection Initial sorting direction for initsort, set to up or down initsort="down"
>
>
initdirection Initial sorting direction for initsort, set to up or down initdirection="up"

 <<O>>  Difference Topic TablePlugin (r1.16 - 17 Dec 2002 - PeterThoeny?)
Line: 1 7 to 1 7
Changed:
<
<
  • 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
>
>
  • 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{...}%
Line: 10 to 15
Added:
>
>

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
Line: 23 to 36
Deleted:
<
<
  • Table border width. Default: 1
    • Set TABLEBORDER = 1

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

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

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

  • 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 =

  • 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
    • Set DATA_BG = #FFFFCC, #FFFFFF

  • Text color of table rows, alternate colors. Default: not specified, e.g. determined by the browser
    • Set DATA_COLOR =
Line: 61 to 42
Changed:
<
<

Sorting

>
>
  • Default table attributes:
    • Set TABLEATTRIBUTES = tableborder="1" cellpadding="0" cellspacing="1" headerbg="#99CCCC" databg="#FFFFCC, #FFFFFF"
Line: 63 to 44
Deleted:
<
<		 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
Line: 72 to 46
Changed:
<
<

Per Table Settings

>
>

Table Attributes

Line: 74 to 48
Changed:
<
<		 On line before the table use %TABLE{...}%:
>
>		 Attributes are defined as a TABLEATTRIBUTES Plugin setting in this topic, a TABLEATTRIBUTES preferences setting, or on line before the table using %TABLE{...}%:
Line: 95 to 69
Changed:
<
<		 All default to the global setting
>
>		 The %TABLE{...}% settings override TABLEATTRIBUTES preferences settings, which override the TABLEATTRIBUTES Plugin settings.
Line: 131 to 105
Changed:
<
<
Plugin Version: 15 Dec 2002
>
>
Plugin Version: 17 Dec 2002
Line: 132 to 107
Added:
>
>
17 Dec 2002: PTh: Removed individual table Plugin settings; added TABLEATTRIBUTES Plugins setting and TABLEATTRIBUTES preferences setting
Line: 152 to 127
Changed:
<
<		 -- PeterThoeny - 15 Dec 2002
>
>		 -- PeterThoeny - 17 Dec 2002

 <<O>>  Difference Topic TablePlugin (r1.15 - 15 Dec 2002 - PeterThoeny?)
Line: 1 31 to 1 32
Added:
>
>
  • Table width, e.g. 100% for relative, 640 for absolute width. Default: (not set)
    • Set TABLEWIDTH =
Line: 86 to 90
Added:
>
>
tablewidth Table width: Percentage of window width, or absolute pixel value. Default is unspecified tablewidth="100%"
columnwidths Column widths: Comma delimited list of column widths, percentage or absolute pixel value. Default is unspecified columnwidths="80%, 20%"
headerrows Number of header rows to exclude from sort; default 1 headerrows="1"
footerrows Number of footer rows to exclude from sort; default 0 footerrows="1"
Line: 92 to 99
Changed:
<
<		 Line before table: %TABLE{ sort="on" tableborder="0" cellpadding="1" cellspacing="3" headerbg="#000099" headercolor="#FFFFCC" databg="#C8CB8F, #DBDDB5" }%
>
>		 Line before table: %TABLE{ sort="on" tableborder="0" cellpadding="1" cellspacing="3" headerbg="#000099" headercolor="#FFFFCC" databg="#C8CB8F, #DBDDB5" headerrows="2" footerrows="1" }%
Line: 94 to 101
Changed:
<
<
>
>
Table with two Header Rows and Footer Row
Line: 100 to 109
Added:
>
>
Num Status Action Who When Progress
Line: 122 to 131
Changed:
<
<
Plugin Version: 09 Dec 2002
>
>
Plugin Version: 15 Dec 2002
Line: 123 to 133
Added:
>
>
15 Dec 2002: PTh: Added headerrows and footerrows params (TWiki:Main/WoutMertens); added tablewidth and columnwidths params (TWiki:Main/ThorstenSommermann)
Line: 142 to 152
Changed:
<
<		 -- PeterThoeny - 09 Dec 2002
>
>		 -- PeterThoeny - 15 Dec 2002

 <<O>>  Difference Topic TablePlugin (r1.14 - 10 Dec 2002 - PeterThoeny?)
Line: 1 41 to 1 41
Changed:
<
<
  • Color for header cells ('*'s around text). Default: #99CCCC
    • #Set HEADER_BG = red
>
>
  • Background color of header cells ('*'s around text). Choose one of the StandardColors. Default: #99CCCC
    • Set HEADER_BG =
Line: 44 to 44
Changed:
<
<
  • Background color for table rows, two alternate colors. Default: #FFFFCC,#FFFFFF
>
>
  • 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
Line: 46 to 50
Added:
>
>
  • Text color of table rows, alternate colors. Default: not specified, e.g. determined by the browser
    • Set DATA_COLOR =
Line: 71 to 77
Changed:
<
<
headerbg Header cell background colour headerbg="#99CCCC"
>
>
headerbg Header cell background colour. Choose one of the StandardColors headerbg="#99CCCC"
headercolor Header cell text colour headercolor="#0000CC"
Line: 72 to 80
Added:
>
>
datacolor Data cell text colour, a comma separated list datacolor="#0000CC, #000000"
Line: 82 to 90
Changed:
<
<

Examples

>
>

Example

Line: 84 to 92
Changed:
<
<		 Line before table: %TABLE{sort="on" tableborder="0" cellpadding="1" cellspacing="3" headerbg="#99CCCC" databg="#C8CB8F,#DBDDB5"}%
>
>		 Line before table: %TABLE{ sort="on" tableborder="0" cellpadding="1" cellspacing="3" headerbg="#000099" headercolor="#FFFFCC" databg="#C8CB8F, #DBDDB5" }%
Line: 86 to 94
Changed:
<
<
>
>
Line: 114 to 122
Changed:
<
<
Plugin Version: 13 Mar 2002
>
>
Plugin Version: 09 Dec 2002
Line: 115 to 124
Added:
>
>
09 Dec 2002: PTh: Added headercolor and datacolor parameters
Line: 130 to 139
Changed:
<
<		 Related Topics: TWikiPreferences, TWikiPlugins
>
>		 Related Topics: TWikiPreferences, TWikiPlugins, StandardColors
Line: 133 to 142
Changed:
<
<		 -- PeterThoeny - 05 Jun 2002
>
>		 -- PeterThoeny - 09 Dec 2002

 <<O>>  Difference Topic TablePlugin (r1.13 - 05 Jun 2002 - PeterThoeny?)
Line: 1 72 to 1 72
Changed:
<
<
databg Data cell background colour, a comma separated list databg="#C8CB8F,#DBDDB5"
>
>
databg Data cell background colour, a comma separated list. Specify "none" for no colour, that is to use the colour/background of the page the table is on. databg="#C8CB8F,#DBDDB5"
Line: 95 to 96
Added:
>
>		 Note: You do not need to install anything on the browser to use this plugin. Below installation instructions are for the administrator who needs to install this plugin on the TWiki server.
Line: 113 to 115
Changed:
<
<
Change History: 13 Mar 2002 PTh: Added TWiki:Main/ShawnBradford 's initsort and initdirection
12 Mar 2002 PTh: Added valign, headeralign and dataalign; fixed bug of swapped cellpadding/cellspacing; fixed warning of uninitialized value
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
>
>
Change History: <!-- specify latest version first --> 
05 Jun 2002: PTh: Added "none" value to databg parameter (suggested by TWiki:Main/TaitCyrus); fixed sorting by stripping HTML tags, removing links and making sort ignore case (suggested by TWiki:Main/ShawnBradford)
13 Mar 2002: PTh: Added TWiki:Main/ShawnBradford 's initsort and initdirection
12 Mar 2002: PTh: Added valign, headeralign and dataalign; fixed bug of swapped cellpadding/cellspacing; fixed warning of uninitialized value
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: JT: Initial version
Line: 123 to 133
Changed:
<
<		 -- PeterThoeny - 13 Mar 2002
>
>		 -- PeterThoeny - 05 Jun 2002

 <<O>>  Difference Topic TablePlugin (r1.12 - 13 Mar 2002 - PeterThoeny?)
Line: 1 68 to 1 69
Added:
>
>
initsort Column to sort initially (1 to number of columns) initsort="2"
initdirection Initial sorting direction for initsort, set to up or down initsort="down"
Line: 70 to 72
Changed:
<
<
databg Data cell background colour, a comma seperated list databg="#C8CB8F,#DBDDB5"
>
>
databg Data cell background colour, a comma separated list databg="#C8CB8F,#DBDDB5"
Line: 110 to 112
Changed:
<
<
Plugin Version: 12 Mar 2002
Change History: 12 Mar 2002 PTh: Added valign, headeralign and dataalign; fixed bug of swapped cellpadding/cellspacing; fixed warning of uninitialized value
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
>
>
Plugin Version: 13 Mar 2002
Change History: 13 Mar 2002 PTh: Added TWiki:Main/ShawnBradford 's initsort and initdirection
12 Mar 2002 PTh: Added valign, headeralign and dataalign; fixed bug of swapped cellpadding/cellspacing; fixed warning of uninitialized value
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
Line: 121 to 123
Changed:
<
<		 -- PeterThoeny - 12 Mar 2002
>
>		 -- PeterThoeny - 13 Mar 2002

 <<O>>  Difference Topic TablePlugin (r1.11 - 13 Mar 2002 - PeterThoeny?)
Line: 1 92 to 1 92
Changed:
<
<

Plugin Installation Instructions

>
>

Plugin Installation Instructions

Line: 107 to 107
Changed:
<
<

Plugin Info

>
>

Plugin Info

Line: 109 to 109
Changed:
<
<
Plugin Author: JohnTalintyre
Plugin Version: 07 Mar 2002
Change History: 07 Mar 2002 PTh: Added valign, headeralign and dataalign; fixed swapped cellpadding/cellspacing bug
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
>
>
Plugin Author: JohnTalintyre, PeterThoeny
Plugin Version: 12 Mar 2002
Change History: 12 Mar 2002 PTh: Added valign, headeralign and dataalign; fixed bug of swapped cellpadding/cellspacing; fixed warning of uninitialized value
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
Line: 121 to 121
Changed:
<
<		 -- PeterThoeny - 07 Mar 2002
>
>		 -- PeterThoeny - 12 Mar 2002

 <<O>>  Difference Topic TablePlugin (r1.10 - 07 Mar 2002 - PeterThoeny?)
Line: 1 31 to 1 32
Added:
>
>
  • 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 =
Line: 64 to 74
Added:
>
>
valign Vertical alignment of cells, set to top, middle, bottom or baseline valign="top"
headeralign Header cell alignment, set to left, center, right or justify. Overrides individual cell settings headeralign="left"
dataalign Data cell alignment, set to left, center, right or justify. Overrides individual cell settings dataalign="center"
Line: 70 to 82
Changed:
<
<		 Line before table: %TABLE{sort="on" tableborder="0" cellpadding="3" cellspacing="1" headerbg="#99CCCC" databg="#C8CB8F,#DBDDB5"}%
>
>		 Line before table: %TABLE{sort="on" tableborder="0" cellpadding="1" cellspacing="3" headerbg="#99CCCC" databg="#C8CB8F,#DBDDB5"}%
Line: 72 to 84
Changed:
<
<
>
>
Line: 98 to 110
Changed:
<
<
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
>
>
Plugin Version: 07 Mar 2002
Change History: 07 Mar 2002 PTh: Added valign, headeralign and dataalign; fixed swapped cellpadding/cellspacing bug
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
Line: 109 to 121
Changed:
<
<		 -- PeterThoeny - 05 Jan 2002
>
>		 -- PeterThoeny - 07 Mar 2002

 <<O>>  Difference Topic TablePlugin (r1.9 - 05 Jan 2002 - PeterThoeny?)
Line: 1 15 to 1 15
Changed:
<
<		 a plugin setting write %<plugin>_<setting>%, i.e. %INTERWIKIPLUGIN_SHORTDESCRIPTION%
>
>		 a plugin setting write %<plugin>_<setting>%, for example, %INTERWIKIPLUGIN_SHORTDESCRIPTION%
Line: 17 to 17
Changed:
<
<
>
>
Line: 98 to 98
Changed:
<
<
Plugin Version: 06 Dec 2001
Change History: 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
>
>
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
Line: 109 to 109
Changed:
<
<		 -- PeterThoeny - 06 Dec 2001
>
>		 -- PeterThoeny - 05 Jan 2002

 <<O>>  Difference Topic TablePlugin (r1.8 - 09 Dec 2001 - PeterThoeny?)
Line: 1 4 to 1 4
Changed:
<
<		 Gives extra control off table display:
>
>		 Gives extra control of table display:

 <<O>>  Difference Topic TablePlugin (r1.7 - 07 Dec 2001 - PeterThoeny?)
Line: 1 98 to 1 98
Changed:
<
<
Plugin Version: 03 Dec 2001
Change History: 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
>
>
Plugin Version: 06 Dec 2001
Change History: 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
Line: 109 to 109
Changed:
<
<		 -- PeterThoeny - 03 Dec 2001
>
>		 -- PeterThoeny - 06 Dec 2001

 <<O>>  Difference Topic TablePlugin (r1.6 - 04 Dec 2001 - PeterThoeny?)
Line: 1 59 to 1 59
Changed:
<
<
sort Set on or off sort="on"
>
>
sort Set table sorting on or off sort="on"
Line: 98 to 98
Changed:
<
<
Plugin Version: 29 Nov 2001
Change History: 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:  
Other Dependencies:  
>
>
Plugin Version: 03 Dec 2001
Change History: 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
Line: 109 to 109
Changed:
<
<		 -- PeterThoeny - 16 Nov 2001
>
>		 -- PeterThoeny - 03 Dec 2001

 <<O>>  Difference Topic TablePlugin (r1.5 - 29 Nov 2001 - PeterThoeny?)
Line: 1 98 to 1 98
Changed:
<
<
Plugin Version: 07 Oct 2001
Change History: 16 Nov 2001: PTh added table border, cell spacing, cell padding, gif files
07 Oct 2001: Initial version
>
>
Plugin Version: 29 Nov 2001
Change History: 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

 <<O>>  Difference Topic TablePlugin (r1.4 - 16 Nov 2001 - PeterThoeny?)
Line: 1 5 to 1 6
Added:
>
>
  • Changing table properties like border width, cell spacing and cell padding
Line: 10 to 11
Changed:
<
<

Global Preferences

  • Set DEBUG to on to get debug messages in data/debug.txt. Default: off
    • Set DEBUG = off
>
>

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
Line: 14 to 24
Changed:
<
<
    • Set TABLEBORDER = 3
>
>
    • Set TABLEBORDER = 1
Line: 16 to 27
Changed:
<
<
    • Set CELLPADDING = 5
>
>
    • Set CELLPADDING = 0
Line: 18 to 30
Changed:
<
<
    • Set CELLSPACING = 2
>
>
    • Set CELLSPACING = 1
Line: 27 to 41
Deleted:
<
<
  • Short description:
    • Set SHORTDESCRIPTION = Control attributes of tables and sorting of table columns
Line: 41 to 54
Changed:
<
<

Per table settings

>
>

Per Table Settings

Line: 57 to 70
Changed:
<
<		 Line before table: %TABLE{sort="on" tableborder="0" cellpadding="2" cellspacing="1" headerbg="#99CCCC" databg="#C8CB8F,#DBDDB5"}%
>
>		 Line before table: %TABLE{sort="on" tableborder="0" cellpadding="3" cellspacing="1" headerbg="#99CCCC" databg="#C8CB8F,#DBDDB5"}%
Line: 59 to 72
Changed:
<
<
>
>
Line: 66 to 80
Added:
>
>

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: 07 Oct 2001
Change History: 16 Nov 2001: PTh added table border, cell spacing, cell padding, gif files
07 Oct 2001: Initial version
CPAN Dependencies:  
Other Dependencies:  
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

Line: 68 to 109
Changed:
<
<		 -- PeterThoeny - 15 Nov 2001
>
>		 -- PeterThoeny - 16 Nov 2001

 <<O>>  Difference Topic TablePlugin (r1.3 - 16 Nov 2001 - PeterThoeny?)
Line: 1 6 to 1 6
Changed:
<
<
  • Changing background colour for header cells
  • Changing background colour for data cells - colours can alternate
>
>
  • Changing background color for header cells
  • Changing background color for data cells - colors can alternate
Line: 12 to 12
Changed:
<
<
    • Set DEBUG = on
  • Colour for header cells ('*'s around text). Default: #99CCCC
>
>
    • 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
Line: 15 to 21
Changed:
<
<
  • #Set DATA_BG = #C8CB8F,#DBDDB5
>
>
  • Background color for table rows, two alternate colors. Default: #FFFFCC,#FFFFFF
Line: 16 to 23
Added:
>
>
  • Make sortable:
Line: 20 to 27
Changed:
<
<

  • Set SHORTDESCRIPTION = Control sorting and colours for table display
>
>
  • Short description:
    • Set SHORTDESCRIPTION = Control attributes of tables and sorting of table columns
Line: 36 to 43
Changed:
<
<		 On line before the table use %TABLE{...}%:
>
>		 On line before the table use %TABLE{...}%:
Line: 38 to 45
Changed:
<
<
Argument Comment
sort on or off
headerbg header cell background colour
databg data cell background colour, a comma seperated list
>
>
Argument Comment Example
sort Set on or off sort="on"
headerbg Header cell background colour headerbg="#99CCCC"
databg Data cell background colour, a comma seperated list databg="#C8CB8F,#DBDDB5"
tableborder Table border width (pixels) tableborder="2"
cellpadding Cell padding (pixels) cellpadding="0"
cellspacing Cell spacing (pixels) cellspacing="3"
Line: 47 to 57
Changed:
<
<		 Line before table: %TABLE{sort="on" headerbg="#99CCCC" databg="#C8CB8F,#DBDDB5"}%
>
>		 Line before table: %TABLE{sort="on" tableborder="0" cellpadding="2" cellspacing="1" headerbg="#99CCCC" databg="#C8CB8F,#DBDDB5"}%
Line: 49 to 59
Changed:
<
<
>
>
Line: 58 to 68
Added:
>
>		 -- PeterThoeny - 15 Nov 2001

 <<O>>  Difference Topic TablePlugin (r1.2 - 14 Nov 2001 - PeterThoeny?)
Line: 1 58 to 1 58
Changed:
<
<		 -- JohnTalintyre? - 07 Oct 2001
>
>		 -- JohnTalintyre - 07 Oct 2001
META FILEATTACHMENT up.gif attr="" comment="Up arrow" date="1005707580" path="C:\Data\Temp\up.gif" size="876" user="PeterThoeny" version="1.1"
META FILEATTACHMENT down.gif attr="" comment="Down arrow" date="1005707591" path="C:\Data\Temp\down.gif" size="869" user="PeterThoeny" version="1.1"
META FILEATTACHMENT diamond.gif attr="" comment="Diamond symbol" date="1005707607" path="C:\Data\Temp\diamond.gif" size="881" user="PeterThoeny" version="1.1"

 <<O>>  Difference Topic TablePlugin (r1.1 - 11 Nov 2001 - PeterThoeny?)
Line: 1 to 1
Added:
>
>

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{...}%:

Argument Comment
sort on or off
headerbg header cell background colour
databg data cell background colour, a comma seperated list

All default to the global setting

Examples

Line before table: %TABLE{sort="on" 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    

-- JohnTalintyre? - 07 Oct 2001


Topic TablePlugin . { View | Diffs | r1.22 | > | r1.21 | > | r1.20 | More }
Revision r1.1 - 11 Nov 2001 - 09:08 - PeterThoeny?
Revision r1.22 - 02 Aug 2004 - 05:05 - PeterThoeny? 		Copyright © 2001 by the contributing authors. All material on this collaboration tool is the property of the contributing authors.
Ideas, requests, problems regarding Lash La Rue? Send feedback.