nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Edit the column width for the Jira issues macro

Jamie Abbott_p2pn6q

I'm using the Jira issues macro in Confluence to pull requirements from Jira into a single table. I'm interested in finding a way to adjust the column width, sometimes the column with a lot of text is compressed and when exported to PDF isn't reader friendly. I'd like to be able to define the column width so every export is consistent.

Is this possible?

Accepted answers

Katerina Kovriga _Stiltsoft_

Hi @Jamie Abbott ,

It is possible with the help of the Table Filter and Charts for Confluence app and its Table Transformer macro that allows advanced table cells formatting.

Wrap your Jira Issues macro into the Table Transformer macro body and use custom SQL queries, for example:

SELECT *,
FORMATWIKI("{cell:width=100px}" + 'Summary'+ "{cell}") AS 'Summary'
FROM T*

Wed 2-1.png Wed 2-2.png

SELECT *,
FORMATWIKI("{cell:width=300px}" + 'Summary'+ "{cell}") AS 'Summary'
FROM T*

Wed 2-3.png Wed 2-4.png Hope this helps.

All comments

Katerina Kovriga _Stiltsoft_

Hi @Jamie Abbott ,

It is possible with the help of the Table Filter and Charts for Confluence app and its Table Transformer macro that allows advanced table cells formatting.

Wrap your Jira Issues macro into the Table Transformer macro body and use custom SQL queries, for example:

SELECT *,
FORMATWIKI("{cell:width=100px}" + 'Summary'+ "{cell}") AS 'Summary'
FROM T*

Wed 2-1.png Wed 2-2.png

SELECT *,
FORMATWIKI("{cell:width=300px}" + 'Summary'+ "{cell}") AS 'Summary'
FROM T*

Wed 2-3.png Wed 2-4.png Hope this helps.

Jamie Abbott_p2pn6q

Thanks, is there a way of doing this without a pluggin?

Katerina Kovriga _Stiltsoft_

Seems there is no any workaround with the standard Confluence tools.

Jamie Abbott_p2pn6q

Okay thanks - do you know what dictates the column widths? I have two tables with similar information, and the column widths differ in each.

Katrina Atkinson

Is there a way to include this SQL for the column width but remove the column lines? I like how jira tables look in the all grey with no lines but need with width as well.

Stiltsoft support

Hi @Katrina Atkinson ,

Unfortunately, this is not possible with the help of the Table Transformer macro. The macro treats source tables as mini SQL databases, so it "draws cells" around data units.

As a workaround, you may change the border color (please navigate to the "Adding border color" if the anchor is broken).

Katrina Atkinson

With lots of troubleshooting I got it!

I added the Edit ‘Table Transformer’ Macro, kept the SQL:

SELECT *,
FORMATWIKI("{cell:width=500px AS 'Issues',

FROM T*

Then I added this to a Div with class = .hide

included the CSS for the Div to be:

.hide {

display: none;

visibility: hidden;

display: block;

opacity: 0;

border-style: none;

height: 1px;

}

Then I added the same jira table with no divs or table macros below. The top one remained hidden, but the column width copied over. Keeping the uniform look of a jira table with the columns edited.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

confluence

cloud

confluence-cloud

filter

ms-excel

table