Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Excel macro - no formating

CTO December 7, 2020

In the excel macro I have added a file which is displayed fine. One problem I can't solve is formatting. In the original file, my text is centered and in Confluence the format is squared to the left. How can I improve it?

 

Thanks for answers.

1 answer

1 vote
Katerina Kovriga {Stiltsoft}
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
December 8, 2020

Hi @PaulinaPilch ,

If you have the Table Filter and Charts for Confluence app installed for your instance, we can suggest the following workaround:

  • convert your spreadsheet to a native-looking Confluence table with help of the Table from CSV macro (the macro recognizes both attachments and URLs);
  • wrap your CSV macro into the Table Transformer macro and format text alignment (use conditional formatting, different text styles, etc.) with the help of wiki markdown.
CTO December 8, 2020

Thank you so much for answer. 

Unfortunatelly, I do not have this plugin but I will try for free for the begining. 

I understand, that without this plugin, I do not text format, do I?

Katerina Kovriga {Stiltsoft}
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
December 8, 2020

It seems to me that the standard Excel macro doesn't allow any formatting.

If your table is not very big, it will be easy just to copy/paste it into Confluence and format it there.

Maybe somebody else will come up with a better idea.

Like Ryan McDermott likes this
CTO December 8, 2020

I don't think that's the case, because when I use vertical text formatting in Excel, the text in confluence changes its position (top and bottom), as well as table borders and shading. The only thing that doesn't work is center or right alignment of the text.

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events