Hi Bob, et al,
I am a novice. I installed the Table-Plus macro but I am getting an "Unknown macro" error message. Could it be because I unknowningly installed it in the " /WEB-INF/lib". If yes, how could I fix it? Thank you very much in advance for your assistance!!

Hi Bob,

Thank you for the quick response! I did install it from the repository client. I don't know why things went wrong. Thanks again.

Hi Bob,

We've installed this plugin (v3.1), but it doesn't seem to be working. When I paste in the example from above it just renders like before. None of the "Common table based capabilities and parameters" seem to work. Same thing for the sql macro.

Something else also is strange. When I run the marco-list macro, the table-plus macro shows up twice, the only difference being that one has a "Common table capabilities" section while the other doesn't. Seems that the old version is still active?

Steve

Hi Bob - are there any plans to add support for column widths?

If I try to go through the repository client I get a message about a key org.swift.confluence.table not being installed. We're using (Version: 2.4.3 Build:#705 Mar 21, 2007). If I try to upload the jar that doesn't work either. I see it's only been tested up through 2.3.3. Any suggestions for getting this to work?

Thanks.

How can I span cells for a row? is it possible?

There seems to be a bug in the "autoNumberSort" option ... if I use "autoNumber=true|autoNumberSort=true" and click on the header of the auto number column, the numbers are treated as strings and sorted in the order 1 10 11 ... 19 2 20 21 22 3 4 5 6 7 8 9

Has anyone had any luck with advanced date sorting and Firefox? I got it working fine with IE 6 but it only works for some date formats in FF.
For:

{table-plus:columnTypes=S,S,I,S,F,S,S,Dyyyy-MM-dd HH:mm:ss,DNNN-yy|autoTotal=true}

sorting works in IE but is completely wrong in FF.

The following works in both.

{table-plus:columnTypes=.,I,D"dd/MMM/yyyy:HH:mm:ss",D"dd/MMM/yyyy:HH:mm:ss"|autoTotal=true|columnAttributes=,style="background:#c0c0c0;",,|sortColumn=4|sortDescending=true}

Quoting the date formats makes no difference.

I can't seem to combine datasources into one table.  I'm trying to combine two sql queries and a excel data source.  The header row for the individual outputs are the same.  Should this work if I have these three individual data sources bounded by ?

Is it possible that this macro doesn't play well with search? I have the same information sitting in both a standard table and a table-plus table and the table-plus data doesn't show up in search results.

If someone else can confirm this is the case I'll create an issue.

I have installed this plugin and the CSV part works great.  The table-plus just renders an ordinary table.  No sorting at all.  I uninstalled and reinstalled the plugin.  I checked the WEB-INF/lib directory and there is no jar file listed.

I looked through the JIRA issues and I don't an issue related to this problem.  I looked through the comments and saw that was the same as mine but the reinstall didn't solve my issue.

 Here are the examples I tried:

NOTE: added \ to escape macro expansion
{table-plus:columnTypes=S,I|autoNumber=true|sortIcon=true}
{csv:script=^test.csv}
{table-plus}
{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}
 None of the examples worked, just ordinary tables.  I am sure it is something simple but I don't how to resolve this.  Is my format incorrect?

 Tia,

Joe

Is there a way to pivot the table data to create cross-tabs? I think this would help me with a csv file that doesn't want to chart.

I use this macro all the time! Is it possible for the macro to interpret wiki markup in the csv? that is, if I have a line in my csv that looks like:

*string*,_statement_,[link|http://www.google.com]

I'd like it to appear as:

Hi, I am having some trouble sorting by the date field.

If I sort by any field other than the date, and then try to sort on the date, it just re-sorts on the previous field. Here is a sample table that exhibits this behaviour;

|| Date || Customer || TME || Notes ||
| Apr 2008 | x cust | brian | big customer |
| Jan 2008 | d cust | harry | small Customer |
| Feb 2008 | a cust | george | middle customer |
| dec 2008 | s cust| mike| soso cust |

Confluence 2.7.2; Firefox 2.0.0.14 

Any suggestions? 

Hey, pretty new to this whole thing, was wondering if there was any way to combine a table-data and a table-plus ie the option to dynamically add rows with table-data and the sorting ability of table-plus.

The date sort on the column "Date" works perfectly if it is sorted first. However, if you sort another text column, it appears to continue sorting by the text-based column, despite the sort arrow showing on the date column.Is there any way to sort only one column at a time keeping the other columns intact.

Hi!

Please is it possible to combine within a table-plus the features columnAttributes=style and columnAttributes=width?

{table-plus:columnAttributes=style="background:yellow; font-size:12pt; text-align: center;",
style="background:red; font-size:12pt; text-align: center;",
style="background:lightblue; font-size:12pt; text-align: left;"}

||Header 1||Header 2||Header 3||
|Cell 1a|Cell 1b|Cell 1c|
|Cell 2a|Cell 2b|Cell 2c|
{table-plus}


{table-plus:columnAttributes=width=20%,width=10%,width=50%}

||Header 1||Header 2||Header 3||
|Cell 1a|Cell 1b|Cell 1c|
|Cell 2a|Cell 2b|Cell 2c|
{table-plus}

Thanks

Werner

Bob, first thanks so much for a set of plugins that I use all the time. Really improves my use of Confluence.

Second I am looking for something that as far as I can tell does not exist (read feature enhancement).

I would really like to be able to have a way to do math between the auto summed columns on a page.

This would allow me to make summary pages for all sort of projects.

Added TBL-68to capture / describe the request.

According to issue Issue TBL-66. I've tryed to get a workaround by displaying a common table (show the body without the macro calls). But I still don't know, if there will come up some new "probems" ...

Changes in TablePlusMacro.java:

...
58   	/* (non-Javadoc)
59     * @see com.atlassian.renderer.v2.macro.Macro#getBodyRenderMode()
60     */
61    public RenderMode getBodyRenderMode() {
62        return RenderMode.ALL;
63    }
64
65
66    /* (non-Javadoc)
67     * @see com.atlassian.renderer.v2.macro.Macro#hasBody()
68     */
69    public boolean hasBody() {
70        return true;
71    }
72
73    /* (non-Javadoc)
74     * @see com.atlassian.renderer.v2.macro.Macro#isInline()
75     */
76    public boolean isInline() {
77        return false;
78    }
79    
80    /* (non-Javadoc)
81     * @see com.atlassian.renderer.v2.macro.BaseMacro#suppressMacroRenderingDuringWysiwyg()
82     */
83    public boolean suppressMacroRenderingDuringWysiwyg() {
84        return false;
85    }
...
118            // render the macro body first
119    	    String rendered = info.getMacroBody(); //subRenderer.render(info.getMacroBody(), info.getPageContext());
120    	    
121    	    if (info.getPageContext().isRenderingForWysiwyg()) {   // don't interfere with wysiwyg editor
122    	    	log.debug("rendering for Wysiwyg");
123    	    	return rendered;
124    	    }
...

Cheers

Can you please deploy to maven the missing dependency of this plugin:

org.swift.confluence:scriptutil:jar:1.4.1

Tks,
Gustavo

Hy,
I'm new user of Confluence. I just discover the chart macro. It's great !

In the documentation, it say that chart macro could retrieve its data from a table with an id. I tried, but it's doesn't work.

There is my code in wiki format (in the same page) :

{table-plus:id=5}
|| 2.3 || 2.4 ||
|| Line1 | 977 | 1000 |
|| Line2 | 0 | 53 |
{table-plus}

{chart:title=MyTitle|tables=5}

On Confluence forum, I found this thread with the same question (http://forums.atlassian.com/thread.jspa?threadID=20934). It's write that there are "Helpful answers available: 2. Correct answers available: 1". But I can't find any link to this 3 answers...

I hope you could help me, I think the solution is easy.
best regards.

PS : I use confluence 2.10.2

Hi Bob, I have tested the table plugin and i think is a great plugin, but I have had some problems with date format:
Example to use:
Firefox navigator

1. As i can see in the instructions, I have to use table-plus:columnType=I,S,Ddd/MM/yyyy (I am using European format. Spanish format)
If I use "columntypes", i can do no column ordering. In the example, Id= 1 to 6, and if I order by date column, i get 1 to 6 or 6 to 1.
I have to use "columntype" in order to get something. In this case, i get 2,1,6,5,4,3. This means that I get order by day not by date (day/month)
I take out the date.js file of the \includes\js directory, and the result is the same. It seems that confluence doesnt use the date.js.
How is it possible? Where you say to install date.js, this means only to copy the file to \include\js directory or I have to do anything else?
¿What about columntype and columntypes?
The final result is that I can only order date format columns if the colummns are in format MM/dd/yyyy. But this is a problem for me because I have a lot of tables in format dd/MM/yyyy. And also here in Spain MM/dd/yyyy is not a valid date format.

Please, can you or anybody help me?
Best Regards

Hi Bob, what about a new version of Table Plugin?

Best Regards

Hi Bob, in the release notes of the new confluence version 3.0.2 says:
"Editing and Visual Improvements. A bug in the Rich Text Editor lead to the generation of line break and other character formatting problems after saving a page. This bug has been fixed."
I have test this new version because I thought it could resolve the problem with Table Plugin, but not. I think this fix probably resolve character formatting problems without tables.
When I use table plugin with wiki markup editor and I save a page, Confluence always introduce blanks before and after columns data.

I hope these lines can be helpful for you.

Best Regards

I am trying to find a way to control the size of the calendar so I put it in a table.  Is there a way to control the size of the table with a calendar in it? 

Hi Bob, How about merging of 2 columns? Can we do this? Thanks!

I'm trying to display a table that is initially sorted by a date column:

{table-plus:columnTypes=Ddd.MM.yyyy,S,S|sortColumn=1|sortDescending=true|sortIcon=true}
|| Wann? || Wo?    || Was? ||
|20.12.2009| Hier    | Irgendwas tolles  |
|13.11.2009| Dort    | Noch was besseres |
|01.01.2010| Überall | Neujahr |
{table-plus}

But the initial sort is not working. The rows are displayed in the same order in which they appear in the source.
When I click on the header they are sorted correctly.

Did I do something wrong or should I report this as a bug?

Should we be able to edit a table-plus macro using the native table editing tools (ex: "Add Row", "Delete Row", etc) when editing a page in Rich Text mode?  I have a page that contains a regular table and a 'table-plus' macro, and when I edit the page in Rich Text mode, the regular table is drawn as an actual table and I can use the table editing tools, but the table-plus macro is displayed in wiki markup.  I thought the table-plus macro was still drawn as a actual table in Rich Text mode when editing a page in Confluence 3.0, but I just upgraded to Confluence 3.1 and I no longer see this.  Did something change in the newest release?