Ability to define column width in a Page Properties Report table

[Juan Carlos Toro]

I have seen several posts going a few years back requesting this feature to be added, and still there is no solution.  Is there an update on this feature?

[Katerina Rudkovskaya _Stiltsoft_ · Accepted solution]

Hi @Juan Carlos Toro,

If your company uses our Table Filter and Charts for Confluence app, you may use its Table Transformer macro to set width of the Page Properties Report macro columns.
Please, check this part of our documentation (navigate to the “Changing column width” section).

[Juan Carlos Toro]

I tried Table Transformer.  But this only seems to work on a table created directly by the user in the Confluence page.  It does not seem to apply to tables automatically generated by a Page Property Report macro.

[Katerina Rudkovskaya _Stiltsoft_]

Hi @Juan Carlos Toro,

For me everything works just fine:



SELECT *,
FORMATWIKI("{cell:width=400px}" + T1.'Company name' + "{cell}") AS 'Company name'
FROM T*



As you can see, the second column bacame really wide after the transformation. So, please check your SQL query once more: maybe there are any typos or smth.

[Juan Carlos Toro]

Hi @Katerina Rudkovskaya _Stiltsoft_ ... Thanks a lot for your assistance.  I did follow your latest instructions, and was able to modify the column width.  

What would the SQL query be if I wanted to define the width of 2 (or more) columns?

Thanks in advance.

JC

[Stiltsoft support]

Hi @Juan Carlos Toro ,

Just apply the FORMATWIKI function for each required column of the table.

You may find more examples of the advanced table cells' formatting here.

[Juan Carlos Toro]

Thanks a lot @Katerina Rudkovskaya _Stiltsoft_ and @Stiltsoft support 

I was able to modified the width of multiple columns.

However, something else I found out while doing this, which is a major drawback to using this Table Transformer macro in combination with a Page Property Report macro: If there is any formatting in the fields in the Page Property Table, the Table Transformers converts the content to plain text. 

E.g.:

If the field was formatted text with bold, bullet, bold text, etc... the formatting is gone.

If the field content was using macros like DATE, Status, etc.... all formatting is gone, and transformed to plain text.

So, it is a trade off that may be not worth it, and I am back to square one, as the whole point of is to be able to format the table to be presented to senior stakeholders.

Thanks again!

[Stiltsoft support]

Hi @Juan Carlos Toro ,

To preserve initial cell formatting (for example, links, text style, etc.), use commas instead of pluses inside your FORMATWIKI functions.

We do have such example in our documentation (use the link from this or our previous answer and navigate to the "Preserving initial cell formatting" section).

[Juan Carlos Toro]

@Stiltsoft support ... Thanks a lot for this info.  Worked like a charm!

JC

[Kian Stack Mumo Systems]

This appears to still be an outstanding issue! You can add your vote to this ticket with Atlassian.