Adds column sorting and other attributes to one or more tables found in the body of the macro. The tables can be produced by wiki markup or other means. Clicking on a column heading will cause that column to be sorted. Clicking again will reverse the order. Note that the excel, csv, or sql macros already have most of these capabilities.
heading - Number of rows to be considered heading rows (default is 1 row). Specify heading=false or heading=0 to not show any heading lines. Heading rows do not participate in sorting.
border - The border width in pixels. Defaults to normal table border width.
width - The table width in pixels. Default is 100%.
Other parameters - Other parameters, such as 'cellspacing' or 'cellpadding', are passed through to the html table markup for more advanced capabilities,
or to override the default class.
Live Examples
Sort by clicking heading column
1. Simple wiki table
Result
January
February
March
April
Max
37.5
32.7
28.0
25.3
Min
31.3
26.8
25.1
18.7
Source
{table-plus}
|| || January || February || March || April ||
| Max | 37.5 | 32.7 | 28.0 | 25.3 |
| Min | 31.3 | 26.8 | 25.1 | 18.7 |
{table-plus}
One question I have is about the sorting. I have a lot of complicated sorting logic in the Metadata Plugin for sorting different formats (currently strings, numbers and JIRA-style durations, and I plan on adding dates). I wonder if any of that can be shared by the dynamic sorting. Presumably that would mean rewriting it in Javascript. What do you think?
I think adding dates and jira durations (you mean 1s, 1d, etc.. right?) to the j...
I think adding dates and jira durations (you mean 1s, 1d, etc.. right?) to the javascript is possible and certainly desirable for all the macros that use it.
True . Rich text editor and macros don't get along very well. You can temporar...
True . Rich text editor and macros don't get along very well. You can temporarily remove the macro to edit the table with rich text editor and then re-enable it something like:
\{table-plus ...
|| Month || Max ||
| January | 25.5 |
\{table-plus}
Yep, that's a bummer. I've got a large table that needs to be editied by e...
Yep, that's a bummer. I've got a large table that needs to be editied by executive & sales types and I doubt they could deal with the workaround, much less wiki markup. It's a pity because the table-plus and cache macros would be perfect for this situation. Is there any hope that Atlassian will find a way to make rich text play nice with macros? Like an option to tell rich text that in this particular situation to allow rich text editing (I wouldn't want it for every macro, like SQL)?
I came up with a lame workaround for this, but it was kind of amazing that it wo...
I came up with a lame workaround for this, but it was kind of amazing that it works so I thought I'd share.
Anyway, I just included the table on another page and wrapped the cache and table-plus macros around the included page. I also put a link pointing to the edit page of the origional.
A little bit of cross-posting.
I've discovered that table-plus causes the Lozen...
A little bit of cross-posting.
I've discovered that table-plus causes the Lozenges provided by the Content Formatting Macros plug-in to behave strangely. Full details are on the comments thread on that page.
Nice plugin, makes tables much more comfortable, as sorting is one of my most of...
Nice plugin, makes tables much more comfortable, as sorting is one of my most often used operation on tables ... Is there a way to extend the columnTypes with more datatypes, e.g. a userspecific date format like dd.mm.yyyy ? Another useful feature would be if I could make the sorting permanent ...
There are improvements in these areas being implemented and tested right now. P...
There are improvements in these areas being implemented and tested right now. Please create some specific issues in the issue tracker (link on top of page) to cover your specifics.
Please provide a simple mechanism to change the background color on cell level.
...
Please provide a simple mechanism to change the background color on cell level.
My best workaround is a small user macro: "<div style='background-color:$param0' />"
Usage: | {bg:blue}15.23 |
Disadvantage: The wysiwyg has a problem with macros inside cells. Also it does not color the whole cell (only the area near the text). (The idea comes from the bgcolor macro, but its simply to long: {bgcolor:blue}15.23{bgcolor})
Nice syntax would be something like:
| :red 15.23 | (keep it as simple as possible! The whitespace in front of the : comes from the wysiwyg ..)
by using the ^ character in the last row, it does not seem that table-plus is aw...
by using the ^ character in the last row, it does not seem that table-plus is aware that i want to span multiple rows in the 'User' column. Does table-plus support multiple row/column spanning? if so, can you provide an example of the syntax?
Thanks, i was pretty sure i had the wrong syntax. But, a bulleted list inside a ...
Thanks, i was pretty sure i had the wrong syntax. But, a bulleted list inside a table cell was not my intention. (i probably should have made that more clear, sorry.) My intention with the carrot (^) was to indicate that I wanted "MIKE" to span the bottom two rows. Is there a way to do this?
My question is very simple, but I can't seem to find the documentation. If you a...
My question is very simple, but I can't seem to find the documentation. If you are using the syntax for headings in the left-most column, how can you change the alignment to left, as shown in your example table at the top of the page? Thanks, Carrie
I was thinking about confluence tables yesterday, and came up with a few ideas o...
I was thinking about confluence tables yesterday, and came up with a few ideas of how they might be better:
Cell formatting macros
A nice syntax would be a macro that can sit inside a cell, and control the attributes of the surrounding
TD or TR.
Maybe like
| | cell text {cellatt:style=border 1px|colspan=2} |
or
| {rowatt:bgcolor=#DDDDDD} | |
This would be a nice way to totally customise confluence tables without changing the basic syntax.
What would be really great is if Atlassian adopted this and built the rich text editor to set these attributes.
To actually implement this would need to do the next one - override the default table renderer.
Override default table renderer
Although renderers aren't pluggable, looks like you could replace the default table renderer in confluence by fiddling with the beans defined in wikiFilterSubsystemContext.xml
e.g. getting this bean:
and replacing the last element with the custom renderer.
This would allow us to add extra features to the standard table, without having to wrap the syntax in a macro.
Spreadsheet like script macros
I have an idea for using the script macro to allow spreadsheet like expressions in confluence.
I think groovy would be a great language for this, given its support for ranges, closures, and GPath.
I'm thinking that the macro would be take a groovy code snippet, evaluate it, and render it.
So in a simple case the script might be
{exp}5+5{exp}
The cool thing would be if the script had access to objects that modelled the table, so objects like
cell - represents current cell, has methods like value(), siblings, evaluate(), etc.
row - represents current row, methods to get ranges of cells etc, indexed so you can use row[3] or row[3..8]
column - as above
etc.
also the script would have predefined functions for all common spreadsheet operations, eg sum
so another expression might be
The possibilities are endless.
Another must would being able to define inline functions, to really add power to the expressions.
Maybe being able to have one master script on a page that defines all the inline functions used in the spreadsheet.
I guess one of the nasty to thing look out for would be circular references, it would be very easy to create endless recursion.
Then you just need an ajax editor for the spreadsheet!
All the csv, excel, SQL and other table-plugin are very nice, but i discovered o...
All the csv, excel, SQL and other table-plugin are very nice, but i discovered one error, while using this macro in combination this the chart plugin (migth be similar with other combinations as well)
- The first usage of the csv-macrois within a chart like
which causes an error if the page is displayed in the browser. (IE displays done with error in the footer line)
If i look at the line IE reports an error, function customizeMacroTable() is called, which does not exists on the page. (I have seen in the generated html code, that the function customizeMacroTable()
is not added to the page, whereas if i exchange the order or the macros, first the pure csv then the chart including the csv, the code is rendered to the page)
Thanks for the great macro!
I'm wondering if there is a way to change the b...
Thanks for the great macro!
I'm wondering if there is a way to change the background color of the header row. I tried setting the color I want with bgcolor, then overriding that on all the non-header cells using columnAttributes and enableHeadingAttributes=false...but bgcolor doesn't seem to affect the color of the header row.
Is there a way to change the grey background to a custom color?
Is there a way to to sort on more than one column, in order. I.e., first sort on...
Is there a way to to sort on more than one column, in order. I.e., first sort on column 1; within the ranges where all rows have the same column 1 value, sort on column 2; etc.
I tried sequential sortColumn statements, but it seems as though only the last one took effect.
OK, this is so strange I'm not quite sure what to do with it.
I have a {checkli...
OK, this is so strange I'm not quite sure what to do with it.
I have a {checklist} macro on a page with a {table-plus} macro.
The presence of the checklist is breaking the ability of the {table-plus} to provide column sorting.
Previously, I was able to click any column header in the table-plus table, and the table would be properly sorted by that column. After adding the {checklist} macro, the table-plus table only sorts on a single column (the 2nd one) no matter which column header I click. Clicking any column header effectively toggles the list between two sort orders.
When I remove the checklist, the table-plus works fine. When I put it back, it breaks again in the same way. I've tried putting the checklist in a panel, a separate section, even putting it on its own page and pulling it in via the {include} macro. No dice. As long as the checklist is rendering on the page, the table-plus is breaking.
Any clue what's going on? I'm going to post this for the checklist macro as well.
I've been looking around for information about centering tables developed using ...
I've been looking around for information about centering tables developed using this macro in Mozilla Firefox (version 2.0.0.14). They center in IE just fine. Is there a limitation that this macro can only be used with IE?
This macro is pretty nice and I used it from time to time without problem. But r...
This macro is pretty nice and I used it from time to time without problem. But right now, it messes up my heading-structure
The following code results in totally messed up site structure. The table is laid over the headings. The grey background of the headings can be seen "through" the table, the text of the heading itself starts beside the table. Can you imagine? Is there any way to upload a picture within the comments?
h2. heading 4
{table-plus:heading=false|enableHighlighting=true|align=left|columnAttributes=style=text-align:center,style="width:70%;text-align:center;"}
|| col 1 | col 2 |
|| col 1 | col 2 |
|| col 1 | col 2 |
{table-plus}
h2. heading 5
h2. heading 6
h2. heading 7
I used the very same code for another site where it worked perfectly, although it was embedded inside a section. So the situation in this other page is actually more complicated...
Can anyone help me?
Thanks Bob, it helped! "align=left" was the bad guy. But this seems to be a ...
Thanks Bob, it helped! "align=left" was the bad guy. But this seems to be a bug somehow, doesn't it? align=left should be the standard formatting so why does it mess up the structure when I explicitly define the table as left-aligned?
Could be and you are free to write up a bug report. However, generally the plug...
Could be and you are free to write up a bug report. However, generally the plugin just passes the requests through to the html document and does not do any validation.
1)can I know the parameter 'columnTypes=S,I,I' is meant for? In one example it i...
1)can I know the parameter 'columnTypes=S,I,I' is meant for? In one example it is used as column Types=S,I,I and in one more exmple it is used as columnTypes=S,F,F,F.
2) Is there any 'width' as a parameter in this macro?
Is there a 500 row limitation on this macro? We're using this code:
window.Sy...
Is there a 500 row limitation on this macro? We're using this code:
{table-plus:width=100%|highlightRow=false\|autoNumber=true}
{metadata-report:Page,BU Reviewed,BU Reviewed Date,Current Maturity Rating,QA Assessment,QA Assessment Date,Global Process Owner,Page Owner,Business Importance,Risk to the Business,Date Created, Date Modified|root=Home|pages=@descendants|labels=processrating}
{table-plus}
It's returning 500 data rows and 1 header row. However, it should be pulling in 511 according to this note it puts at the bottom. Hmm, I was going to put in a screenshot but Confluence won't let me. The last line of the table is labeled 501 and the line doesn't have data, it says "First 500 results of 511...".
Great, thanks! My end user confirms this resolved the issue:
I have corrected m...
Great, thanks! My end user confirms this resolved the issue:
I have corrected my problem by using "maxResults=nnnn".
The reports in question use the "table-plus" macro with an embedded "metadata-report" macros. I placed the "maxResults=" command in the "metadata-report" portion of the report.
After confluence 2.10.1 upgrade (from 2.5.6), we noticed that the 'table-plus' m...
After confluence 2.10.1 upgrade (from 2.5.6), we noticed that the 'table-plus' macro doesn't render inside 'tip' macro. Also tried upgrading table plugin to latest version 3.4.0 and no success. However 'table' macro works fine in this construct.
Our site uses this construct in many places as we liked the appearance. I am wondering if there is a way I can get this to work or do is this not going to be supported?
I don't know if this was reported previously in JIRA (don't have a lot of time t...
I don't know if this was reported previously in JIRA (don't have a lot of time to look now), but if I have a nicely setup table-plus macro which contains reporting macros from the Reporting plugin, everything works. When I put everything onto one line (same macro calls, same everything, just without whitespace), I get no output. Removing the table-plus macro from the one line statement fixes the problem and I can see the output once again (just without column sorting functionality of course). Afterwards if I take the rendered wiki markup (now in HTML) from my plugin module, wrap it inside the same noformat macro and pass that through the wiki to XHtml renderer (String com.atlassian.renderer.WikiStyleRenderer.convertWikiToXHtml(RenderContext context, String wiki)), everything works as normal. Nothing major, but just thought I'd let you know of this strange behaviour. Thanks for any replies in advance.
Edit:
Sorry I wasn't using table-plus properly. If you use it outside of the reporting macro, it works (table-plus is outside of report-block).
Is there some way to use background color on just a section of a table without b...
Is there some way to use background color on just a section of a table without breaking the table away from the other rows? The first example is how the table should look. the bgcolor in the cells are the cells that I would like to color. The second example is using the table-plus which colors my cells but it breaks them away from the other rows and makes the first column small.
Comments (72)
Apr 11, 2006
Guy Fraser says:
NiiiiiceNiiiiice
Apr 11, 2006
Jonathan Nolen says:
This is killer. Can we get some screenshots?This is killer. Can we get some screenshots?
Apr 11, 2006
Guy Fraser says:
Is it possible to change the row highlight colour?Is it possible to change the row highlight colour?
Apr 11, 2006
Bob Swift says:
Should have thought of that, write up an issue please!Should have thought of that, write up an issue please!
Apr 11, 2006
Andy Armstrong says:
This is awesome! I'm planning on updating the Metadata Plugin to optionally gene...This is awesome! I'm planning on updating the Metadata Plugin to optionally generate Table-plus macro syntax:
http://developer.atlassian.com/jira/browse/META-19
One question I have is about the sorting. I have a lot of complicated sorting logic in the Metadata Plugin for sorting different formats (currently strings, numbers and JIRA-style durations, and I plan on adding dates). I wonder if any of that can be shared by the dynamic sorting. Presumably that would mean rewriting it in Javascript. What do you think?
Apr 11, 2006
Bob Swift says:
I think adding dates and jira durations (you mean 1s, 1d, etc.. right?) to the j...I think adding dates and jira durations (you mean 1s, 1d, etc.. right?) to the javascript is possible and certainly desirable for all the macros that use it.
Apr 18, 2006
daren desjardins says:
I would love to have Date support in the sorting!I would love to have Date support in the sorting!
Apr 18, 2006
Bob Swift says:
I don't think there is an issue for that yet, could add one and describe any oth...I don't think there is an issue for that yet, could add one and describe any other information related to that. Thanks.
Apr 25, 2006
Russell Warren says:
General support for adjusting per-column attributes (like width) would be excell...General support for adjusting per-column attributes (like width) would be excellent. Something like
columnWidths=100,50,50,50
would be nice.
In general, direct passthroughs to html <col> attributes (similar to what you did with stuff like cellspacing, but with a list) would be very useful.
Jira'd it here: http://developer.atlassian.com/jira/browse/SCRP-75
Jan 17, 2008
Olivier Jauze says:
I tried this window.SyntaxHighlighter.config.clipboardSwf = '/s/1724/13/2/_/d...I tried this
and it worked well.
Feb 03, 2008
Jeremy Page says:
Olivier, Did you find that modifying the columnAttributes did not render ...Olivier,
Did you find that modifying the columnAttributes did not render properly using Preview, but only when Page was saved and viewed?
Thanks,
Jeremy.
Jun 24, 2008
Adam Graffunder says:
This isn't working for me. I tried the format you used, both types of quot...This isn't working for me. I tried the format you used, both types of quotes, using absolute values instead of percentages. No dice.
Jun 14, 2006
Jeff Hatfield says:
Is it true that if I use this macro the table can no longer be edited using Rich...Is it true that if I use this macro the table can no longer be edited using Rich Text mode features? Maybe I'm missing something?
Jun 14, 2006
Bob Swift says:
True . Rich text editor and macros don't get along very well. You can temporar...True
. Rich text editor and macros don't get along very well. You can temporarily remove the macro to edit the table with rich text editor and then re-enable it something like:
\{table-plus ... || Month || Max || | January | 25.5 | \{table-plus}Jun 17, 2006
Jeff Hatfield says:
Yep, that's a bummer. I've got a large table that needs to be editied by e...Yep, that's a bummer. I've got a large table that needs to be editied by executive & sales types and I doubt they could deal with the workaround, much less wiki markup. It's a pity because the table-plus and cache macros would be perfect for this situation. Is there any hope that Atlassian will find a way to make rich text play nice with macros? Like an option to tell rich text that in this particular situation to allow rich text editing (I wouldn't want it for every macro, like SQL)?
Jun 23, 2006
Jeff Hatfield says:
I came up with a lame workaround for this, but it was kind of amazing that it wo...I came up with a lame workaround for this, but it was kind of amazing that it works so I thought I'd share.
Anyway, I just included the table on another page and wrapped the cache and table-plus macros around the included page. I also put a link pointing to the edit page of the origional.
{cache} {table-plus} [Edit|https://ourdomain.com/confluence/pages/editpage.action?pageId=6136] {include:Big List} {table-plus} {cache}Oct 12, 2006
Neil Arrowsmith says:
A little bit of cross-posting. I've discovered that table-plus causes the Lozen...A little bit of cross-posting.
I've discovered that table-plus causes the Lozenges provided by the Content Formatting Macros plug-in to behave strangely. Full details are on the comments thread on that page.
Oct 12, 2006
Bob Swift says:
Neil, create an issue for the table macros and I will have a look at it.Neil, create an issue for the table macros and I will have a look at it.
Oct 15, 2006
Bob Swift says:
And I need some specific markup to test since simple testing doesn't show any pr...And I need some specific markup to test since simple testing doesn't show any problems.
Oct 19, 2006
SB says:
how to disable sorting?how to disable sorting?
Oct 12, 2007
Bob Swift says:
Set enableSorting=false to prevent sorting.Set enableSorting=false to prevent sorting.
Nov 08, 2006
Limor Maayan says:
How can I download this macro? Do you have instructions somewhere?How can I download this macro? Do you have instructions somewhere?
Nov 08, 2006
Bob Swift says:
See top of page.See top of page.
Nov 21, 2006
Tony Bianchino says:
Is there any way of turning off the table's border thickness? I'd like to get ri...Is there any way of turning off the table's border thickness? I'd like to get rid of the lines between my table rows and columns.
Oct 26
Yoni Barkan says:
I never saw a response to this - is there a way to turn off the borders altogeth...I never saw a response to this - is there a way to turn off the borders altogether? border=0 doesn't work.
Thanks!
Dec 12, 2006
Robert Senger says:
Nice plugin, makes tables much more comfortable, as sorting is one of my most of...Nice plugin, makes tables much more comfortable, as sorting is one of my most often used operation on tables ... Is there a way to extend the columnTypes with more datatypes, e.g. a userspecific date format like dd.mm.yyyy ? Another useful feature would be if I could make the sorting permanent ...
Dec 12, 2006
Bob Swift says:
There are improvements in these areas being implemented and tested right now. P...There are improvements in these areas being implemented and tested right now. Please create some specific issues in the issue tracker (link on top of page) to cover your specifics.
Mar 08, 2007
Bernhard Neuhauser says:
Please provide a simple mechanism to change the background color on cell level. ...Please provide a simple mechanism to change the background color on cell level.
My best workaround is a small user macro: "<div style='background-color:$param0' />"
Usage: | {bg:blue}15.23 |
Disadvantage: The wysiwyg has a problem with macros inside cells. Also it does not color the whole cell (only the area near the text). (The idea comes from the bgcolor macro, but its simply to long: {bgcolor:blue}15.23{bgcolor})
Nice syntax would be something like:
| :red 15.23 | (keep it as simple as possible! The whitespace in front of the : comes from the wysiwyg ..)
Mar 08, 2007
Bob Swift says:
Please create an issue to track this. I don't have any good ideas at the moment...Please create an issue to track this. I don't have any good ideas at the moment. I have also been using the bgcolor macro as you indicated.
Sep 12, 2007
Ken Young says:
Do you have any recommendations on hiding columns based on the group(s) a logged...Do you have any recommendations on hiding columns based on the group(s) a logged in user is a member of?
Oct 11, 2007
paul says:
by using the ^ character in the last row, it does not seem that table-plus is aw...by using the ^ character in the last row, it does not seem that table-plus is aware that i want to span multiple rows in the 'User' column. Does table-plus support multiple row/column spanning? if so, can you provide an example of the syntax?
Oct 12, 2007
Bob Swift says:
Table-plus does not change the content of your table. However, there are other ...Table-plus does not change the content of your table. However, there are other ways to do what you want. For instance, use the csv macro:
{csv:output=wiki} "my split heading", h2 d11, "bullets * more * more still" d21, d22 {csv}Oct 12, 2007
paul says:
Thanks, i was pretty sure i had the wrong syntax. But, a bulleted list inside a ...Thanks, i was pretty sure i had the wrong syntax. But, a bulleted list inside a table cell was not my intention. (i probably should have made that more clear, sorry.) My intention with the carrot (^) was to indicate that I wanted "MIKE" to span the bottom two rows. Is there a way to do this?
Oct 12, 2007
Bob Swift says:
That would require use of html and the HTML Plugin or use the Table macro.That would require use of html and the HTML Plugin or use the Table macro.
Oct 25, 2007
Carrie Moley says:
My question is very simple, but I can't seem to find the documentation. If you a...My question is very simple, but I can't seem to find the documentation. If you are using the syntax for headings in the left-most column, how can you change the alignment to left, as shown in your example table at the top of the page? Thanks, Carrie
Oct 25, 2007
Bob Swift says:
See if the new examples help. Example 3 shows left column center aligned for ins...See if the new examples help. Example 3 shows left column center aligned for instance.
Nov 12, 2007
Jon Nermut says:
I was thinking about confluence tables yesterday, and came up with a few ideas o...I was thinking about confluence tables yesterday, and came up with a few ideas of how they might be better:
Cell formatting macros
A nice syntax would be a macro that can sit inside a cell, and control the attributes of the surrounding
TD or TR.
Maybe like
| | cell text {cellatt:style=border 1px|colspan=2} | or | {rowatt:bgcolor=#DDDDDD} | |This would be a nice way to totally customise confluence tables without changing the basic syntax.
What would be really great is if Atlassian adopted this and built the rich text editor to set these attributes.
To actually implement this would need to do the next one - override the default table renderer.
Override default table renderer
Although renderers aren't pluggable, looks like you could replace the default table renderer in confluence by fiddling with the beans defined in wikiFilterSubsystemContext.xml
e.g. getting this bean:
<bean id="v2BlockComponents" class="java.util.ArrayList"> <constructor-arg> <list> <bean class="com.atlassian.renderer.v2.components.block.BlankLineBlockRenderer"/> <bean class="com.atlassian.confluence.renderer.ConfluenceHeadingBlockRenderer"/> <bean class="com.atlassian.renderer.v2.components.block.BlockquoteBlockRenderer"/> <bean class="com.atlassian.renderer.v2.components.block.HorizontalRuleBlockRenderer"/> <bean class="com.atlassian.renderer.v2.components.list.ListBlockRenderer"/> <bean class="com.atlassian.renderer.v2.components.table.TableBlockRenderer"/> </list> </constructor-arg> </bean>and replacing the last element with the custom renderer.
This would allow us to add extra features to the standard table, without having to wrap the syntax in a macro.
Spreadsheet like script macros
I have an idea for using the script macro to allow spreadsheet like expressions in confluence.
I think groovy would be a great language for this, given its support for ranges, closures, and GPath.
I'm thinking that the macro would be take a groovy code snippet, evaluate it, and render it.
So in a simple case the script might be
{exp}5+5{exp}The cool thing would be if the script had access to objects that modelled the table, so objects like
cell - represents current cell, has methods like value(), siblings, evaluate(), etc.
row - represents current row, methods to get ranges of cells etc, indexed so you can use row[3] or row[3..8]
column - as above
etc.
also the script would have predefined functions for all common spreadsheet operations, eg sum
so another expression might be
{exp} sum( column[3..8] ) {exp} or {exp} row.find( { it=="blah" } ).value() {exp}The possibilities are endless.
Another must would being able to define inline functions, to really add power to the expressions.
Maybe being able to have one master script on a page that defines all the inline functions used in the spreadsheet.
I guess one of the nasty to thing look out for would be circular references, it would be very easy to create endless recursion.
Then you just need an ajax editor for the spreadsheet!
Jan 28, 2008
Gerhard Gahle says:
All the csv, excel, SQL and other table-plugin are very nice, but i discovered o...All the csv, excel, SQL and other table-plugin are very nice, but i discovered one error, while using this macro in combination this the chart plugin (migth be similar with other combinations as well)
- The first usage of the csv-macrois within a chart like
{chart:title=sample} {csv:script="any.csv"|output=wiki} {chart}Then I try to display another csv as table:
{csv:url="http://anyurl"|output=wiki}which causes an error if the page is displayed in the browser. (IE displays done with error in the footer line)
If i look at the line IE reports an error, function customizeMacroTable() is called, which does not exists on the page. (I have seen in the generated html code, that the function customizeMacroTable()
is not added to the page, whereas if i exchange the order or the macros, first the pure csv then the chart including the csv, the code is rendered to the page)
Is there any other workaround?
Jan 28, 2008
Bob Swift says:
Please write up an issue with your working and non working examples. From your d...Please write up an issue with your working and non working examples. From your description, adding
{csv} {csv}first might help.
Mar 27, 2008
Jessica Britton says:
Thanks for the great macro! I'm wondering if there is a way to change the b...Thanks for the great macro!
I'm wondering if there is a way to change the background color of the header row. I tried setting the color I want with bgcolor, then overriding that on all the non-header cells using columnAttributes and enableHeadingAttributes=false...but bgcolor doesn't seem to affect the color of the header row.
Is there a way to change the grey background to a custom color?
Apr 20, 2008
Pranav Olkar says:
Is there any way to sort the emoticons ( w.r.t wikimarkup) ?Is there any way to sort the emoticons ( w.r.t wikimarkup) ?
Apr 21, 2008
Bob Swift says:
No, not yet. See TBL-39.No, not yet. See TBL-39.
May 06, 2008
Steven Currie says:
Is there a way to to sort on more than one column, in order. I.e., first sort on...Is there a way to to sort on more than one column, in order. I.e., first sort on column 1; within the ranges where all rows have the same column 1 value, sort on column 2; etc.
I tried sequential sortColumn statements, but it seems as though only the last one took effect.
May 06, 2008
Bob Swift says:
No. Please write up an issue with your suggestions as to how you would to be ab...No. Please write up an issue with your suggestions as to how you would to be able to do this type of sort verses the existing sort capability.
May 19, 2008
Jeff Tanner says:
Referring to "3. Change how table looks", in source it uses "title='Monthly temp...Referring to "3. Change how table looks", in source it uses "title='Monthly temperatures'". Yet it is not present in results.
Does "title" work?
Thanks
– Jeff in Seattle
May 19, 2008
Bob Swift says:
Yes, the title is passed through to the html table element as a title parameter....Yes, the title is passed through to the html table element as a title parameter. You can see this by mousing over a table element (not a header).
Jun 24, 2008
Jim Doria says:
OK, this is so strange I'm not quite sure what to do with it. I have a {checkli...OK, this is so strange I'm not quite sure what to do with it.
I have a {checklist} macro on a page with a {table-plus} macro.
The presence of the checklist is breaking the ability of the {table-plus} to provide column sorting.
Previously, I was able to click any column header in the table-plus table, and the table would be properly sorted by that column. After adding the {checklist} macro, the table-plus table only sorts on a single column (the 2nd one) no matter which column header I click. Clicking any column header effectively toggles the list between two sort orders.
When I remove the checklist, the table-plus works fine. When I put it back, it breaks again in the same way. I've tried putting the checklist in a panel, a separate section, even putting it on its own page and pulling it in via the {include} macro. No dice. As long as the checklist is rendering on the page, the table-plus is breaking.
Any clue what's going on? I'm going to post this for the checklist macro as well.
Jun 24, 2008
Shaun McNamara says:
I've been looking around for information about centering tables developed using ...I've been looking around for information about centering tables developed using this macro in Mozilla Firefox (version 2.0.0.14). They center in IE just fine. Is there a limitation that this macro can only be used with IE?
Jul 14, 2008
Bob Swift says:
No, but you need to make sure your style is set appropriately for FF.No, but you need to make sure your style is set appropriately for FF.
Jul 14, 2008
Peter Drechsel says:
This macro is pretty nice and I used it from time to time without problem. But r...This macro is pretty nice and I used it from time to time without problem. But right now, it messes up my heading-structure
The following code results in totally messed up site structure. The table is laid over the headings. The grey background of the headings can be seen "through" the table, the text of the heading itself starts beside the table. Can you imagine? Is there any way to upload a picture within the comments?
h2. heading 4 {table-plus:heading=false|enableHighlighting=true|align=left|columnAttributes=style=text-align:center,style="width:70%;text-align:center;"} || col 1 | col 2 | || col 1 | col 2 | || col 1 | col 2 | {table-plus} h2. heading 5 h2. heading 6 h2. heading 7I used the very same code for another site where it worked perfectly, although it was embedded inside a section. So the situation in this other page is actually more complicated...
Can anyone help me?
Jul 14, 2008
Bob Swift says:
Try removing align=left.Try removing align=left.
Jul 15, 2008
Peter Drechsel says:
Thanks Bob, it helped! "align=left" was the bad guy. But this seems to be a ...Thanks Bob, it helped! "align=left" was the bad guy. But this seems to be a bug somehow, doesn't it? align=left should be the standard formatting so why does it mess up the structure when I explicitly define the table as left-aligned?
Jul 15, 2008
Bob Swift says:
Could be and you are free to write up a bug report. However, generally the plug...Could be and you are free to write up a bug report. However, generally the plugin just passes the requests through to the html document and does not do any validation.
Jul 14, 2008
Dhana Lakshmi Marothu says:
1)can I know the parameter 'columnTypes=S,I,I' is meant for? In one example it i...1)can I know the parameter 'columnTypes=S,I,I' is meant for? In one example it is used as column Types=S,I,I and in one more exmple it is used as columnTypes=S,F,F,F.
2) Is there any 'width' as a parameter in this macro?
Jul 14, 2008
Bob Swift says:
See Common table capabilities for information on the columnTypes and other sim...Jul 28, 2008
Crystal Johnson says:
Hi, I am using the table plus macro and noticed the top line is not adding to t...Hi,
I am using the table plus macro and noticed the top line is not adding to the total. Is there something I'm doing wrong?
{composition-setup} property.key = value {composition-setup} {deck:id=list2|class=aqua} {card:label=Proposed} {menuicon:folder} {table-plus:autoTotal=true|autoNumber=true|sortIcon=true|columnTypes=S,D,S,S,S,I,|} {report-table} {content-reporter:space=@self|types=page|scope=2009 Business Cases>children,-Information Technology,-Creative,-eCommerce,-Retail,-Human Resources,-Finance,-Business Intelligence,-Distribution Center,-Contact Center,-Faye Olson,-Dave Mertz,-Dave Anderson,-Ken Oler,-Jamie Loehr,-Brian Wilson,-Stewart Hubbard,-Matt Williams,-Jesse Moreno} {text-sort:content:title} {content-reporter} {report-column:title=2009 Business Cases}{report-info:content:title|link=true}{report-column} {report-column:title=Created}{report-info:content:creation date|format=dd MMM}{report-column} {report-column:title=Creator}{report-info:content:creator|link=false}{report-column} {report-column:title=Modified}{report-info:content:modification date|format=dd MMM}{report-column} {report-column:title=Modifier}{report-info:content:modifier|link=false}{report-column} {report-column:title=Capital}{report-info:content:excerpt|link=false}{report-column} {report-empty} This report is empty {report-empty} {report-table} {table-plus} {card} {card:label=Approved} {menuicon:pin_blue} {table-plus:autoNumber=true|autoTotal=true|columnTypes=S,D,S,S,S,I} {report-table} {content-reporter:space=@self|types=page|label=+Approved|scope=2009 Business Cases>children,-Information Technology,-Creative,-eCommerce,-Retail,-Human Resources,-Finance,-Business Intelligence,-Distribution Center,-Contact Center,-Faye Olson,-Dave Mertz,-Dave Anderson,-Ken Oler,-Jamie Loehr,-Brian Wilson,-Stewart Hubbard,-Matt Williams,-Jesse Moreno} {text-sort:content:title} {content-reporter} {report-column:title=2009 Business Cases}{report-info:content:title|link=true}{report-column} {report-column:title=Created}{report-info:content:creation date|format=dd MMM}{report-column} {report-column:title=Creator}{report-info:content:creator|link=false}{report-column} {report-column:title=Modified}{report-info:content:modification date|format=dd MMM}{report-column} {report-column:title=Modifier}{report-info:content:modifier|link=false}{report-column} {report-column:title=Capital}{report-info:content:excerpt|link=false}{report-column} {report-empty} This report is empty {report-empty} {report-table} {table-plus} {card} {card:label=Not Approved} {menuicon:pin_green} {table-plus:autoNumber=true|autoTotal=true|columnTypes=S,D,S,S,S,I} {report-table} {content-reporter:space=@self|types=page|label=+No|scope=2009 Business Cases>children,-Information Technology,-Creative,-eCommerce,-Retail,-Human Resources,-Finance,-Business Intelligence,-Distribution Center,-Contact Center,-Faye Olson,-Dave Mertz,-Dave Anderson,-Ken Oler,-Jamie Loehr,-Brian Wilson,-Stewart Hubbard,-Matt Williams,-Jesse Moreno} {text-sort:content:title} {content-reporter} {report-column:title=2009 Business Cases}{report-info:content:title|link=true}{report-column} {report-column:title=Created}{report-info:content:creation date|format=dd MMM}{report-column} {report-column:title=Creator}{report-info:content:creator|link=false}{report-column} {report-column:title=Modified}{report-info:content:modification date|format=dd MMM}{report-column} {report-column:title=Modifier}{report-info:content:modifier|link=false}{report-column} {report-column:title=Capital}{report-info:content:excerpt|link=false}{report-column} {report-empty} This report is empty {report-empty} {report-table} {table-plus}Jul 28, 2008
Bob Swift says:
First row is normally a header row. Try heading=0.First row is normally a header row. Try heading=0.
Jul 28, 2008
Crystal Johnson says:
That worked, thanks a bunch.That worked, thanks a bunch.
Aug 11, 2008
Crystal Johnson says:
Hi, I am trying to create a table plus and I am using the following code. The p...Hi, I am trying to create a table plus and I am using the following code.
The problem is, when I use commas, the column doesn't total properly.
What can I do to fix this, I figure it has something to do with the column types, but I can't figure it out.
Thanks,
Crystal
{table-plus:autoTotal=true|columnTypes=S,S,C,I|autoNumber=true| columnAttributes=,,style="background:yellow; font-size:12pt;"} ||Capital Budget|| Detail || Capital|| Expense|| | hardware| Hardware-sgadfh| {metadata:Hardware}50,000{metadata}| 10,000 | {table-plus}Aug 13, 2008
Bob Swift says:
You will have get rid of the commas . The number parsing is very primitive. Yo...You will have get rid of the commas
. The number parsing is very primitive. You can create an enhancement request.
Aug 13, 2008
Crystal Johnson says:
I am also having a problem with Table-Plus sorting. It will not allow me to sort...I am also having a problem with Table-Plus sorting. It will not allow me to sort.
{composition-setup} property.key = value {composition-setup} {deck:id=list2|class=aqua} {card:label=Proposed} {table-plus:heading=0|autoTotal=true|autoNumber=true|columnTypes=S,D,S,S,S,C} {report-table} {content-reporter:space=@self|types=page|scope=2009 Business Cases>children,-Information Technology,-Creative,-eCommerce,-Retail,-Human Resources,-Finance,-Business Intelligence,-Distribution Center,-Contact Center,-Faye Olson,-Dave Mertz,-Dave Anderson,-Ken Oler,-Jamie Loehr,-Brian Wilson,-Stewart Hubbard,-Matt Williams,-Jesse Moreno} {text-sort:content:title} {content-reporter} {report-column:title=2009 Business Cases} {report-info:content:title|link=true} {report-column} {report-column:title=Created} {report-info:content:creation date|format=dd MMM} {report-column} {report-column:title=Creator} {report-info:content:creator|link=false} {report-column} {report-column:title=Modified} {report-info:content:modification date|format=dd MMM} {report-column} {report-column:title=Modifier} {report-info:content:modifier|link=false} {report-column} {report-column:title=Capital} {report-info:content:excerpt|link=false} {report-column} {report-empty} This report is empty {report-empty} {report-table} {table-plus}Aug 13, 2008
Bob Swift says:
I would be helpful if you can narrow this down to a table that I try to reproduc...I would be helpful if you can narrow this down to a table that I try to reproduce this with. Please create an issue with the information.
Sep 11, 2008
Michael Jositz says:
Is there an idea when this critical bug would be fixed? http://developer.atlass...Is there an idea when this critical bug would be fixed?
http://developer.atlassian.com/jira/browse/TBL-54
Thanks in advance!
Dec 11, 2008
hajo van Ravenswaay says:
Cool functionality, love it! However, I have not figured out yet how to ad...However, I have not figured out yet how to add it to existing tables. Is this possible?
If I just add table plus with thye xisting content in between, see example 1, it adds the existing content automatically in each row I add...
If I add the table plus below the existing table, I do not get one table, but a spearate table below the existing table :S
Example 1
{table-data:Table} || A || B || C || D || | 1 | 2 | txt | Z | | {date-data:A\|format=dd-MMM-yyyy}today{date-data} | {number-data:B|decimal=true}{number-data} | {text-data:C} | {list-data:D}{list-option}X{list-option} {list-option}Y{list-option} {list-option}Z{list-option} {list-option}Completed{list-option}{list-data} |Example2
|| A || B || C || D || | 1 | 2 | txt | Z | {table-data:Table} | {date-data:A\|format=dd-MMM-yyyy}today{date-data} | {number-data:B|decimal=true}{number-data} | {text-data:C} | {list-data:D}{list-option}X{list-option} {list-option}Y{list-option} {list-option}Z{list-option} {list-option}Completed{list-option}{list-data} |Dec 11, 2008
Bob Swift says:
The macro is table-plus not table-data and must surround the table like the exam...The macro is table-plus not table-data and must surround the table like the examples near the top of this page.
Jan 07, 2009
Peter R. says:
Is there a 500 row limitation on this macro? We're using this code: window.Sy...Is there a 500 row limitation on this macro? We're using this code:
{table-plus:width=100%|highlightRow=false\|autoNumber=true} {metadata-report:Page,BU Reviewed,BU Reviewed Date,Current Maturity Rating,QA Assessment,QA Assessment Date,Global Process Owner,Page Owner,Business Importance,Risk to the Business,Date Created, Date Modified|root=Home|pages=@descendants|labels=processrating} {table-plus}It's returning 500 data rows and 1 header row. However, it should be pulling in 511 according to this note it puts at the bottom. Hmm, I was going to put in a screenshot but Confluence won't let me. The last line of the table is labeled 501 and the line doesn't have data, it says "First 500 results of 511...".
Suggestions?
Thank you.
Peter
Jan 07, 2009
Bob Swift says:
Not that I know of . However, the metadata-report macro has: maxResults - Speci...Not that I know of
. However, the metadata-report macro has: maxResults - Specifies the maximum number of results in a report (default: 500)
Jan 09, 2009
Peter R. says:
Great, thanks! My end user confirms this resolved the issue: I have corrected m...Great, thanks! My end user confirms this resolved the issue:
Jan 22, 2009
Vikash Joshi says:
Is it possible to sort more than one column? E.g. Say I have columns Name, City...Is it possible to sort more than one column?
E.g. Say I have columns Name, City and Country and I want to sort by Country first followed by City.
Is this possible?
Mar 02, 2009
bhagat bandlamudi says:
After confluence 2.10.1 upgrade (from 2.5.6), we noticed that the 'table-plus' m...After confluence 2.10.1 upgrade (from 2.5.6), we noticed that the 'table-plus' macro doesn't render inside 'tip' macro. Also tried upgrading table plugin to latest version 3.4.0 and no success. However 'table' macro works fine in this construct.
Our site uses this construct in many places as we liked the appearance. I am wondering if there is a way I can get this to work or do is this not going to be supported?
May 29, 2009
raptors says:
I don't know if this was reported previously in JIRA (don't have a lot of time t...I don't know if this was reported previously in JIRA (don't have a lot of time to look now), but if I have a nicely setup table-plus macro which contains reporting macros from the Reporting plugin, everything works. When I put everything onto one line (same macro calls, same everything, just without whitespace), I get no output. Removing the table-plus macro from the one line statement fixes the problem and I can see the output once again (just without column sorting functionality of course). Afterwards if I take the rendered wiki markup (now in HTML) from my plugin module, wrap it inside the same noformat macro and pass that through the wiki to XHtml renderer (String com.atlassian.renderer.WikiStyleRenderer.convertWikiToXHtml(RenderContext context, String wiki)), everything works as normal. Nothing major, but just thought I'd let you know of this strange behaviour. Thanks for any replies in advance.
Edit:
Sorry I wasn't using table-plus properly. If you use it outside of the reporting macro, it works (table-plus is outside of report-block).
Jun 26, 2009
Robin Jacobs says:
Is there some way to use background color on just a section of a table without b...Is there some way to use background color on just a section of a table without breaking the table away from the other rows? The first example is how the table should look. the bgcolor in the cells are the cells that I would like to color. The second example is using the table-plus which colors my cells but it breaks them away from the other rows and makes the first column small.
________________________________________