I've got a Google spreadsheet that I'm trying to use to generate links to a lot of files.
This question 's answer shows that you can use the syntax
[Text to display|https://url-to-link.com]
and Confluence will render it as Text to display
However, when I copy my links with that format into a table in Confluence, they get rendered as [Text to display|https://url-to-link.com ]. If I manually type them out, they work as expected.
Is there any way that I can copy and paste a lot of links into a table and have Confluence render them the way I want?
The links I'm using are very long, so I don't want to display the full URLs in the table. There's also a lot of them, so it would be tedious to type all of these out manually.
If copying and pasting each link individually, you can
To create all the links at once, you can create the syntax in a spreadsheet, then paste the preformatted links directly into a confluence table. Unlike typing a left bracket ([), pasting multiple items into the page does not trigger the link creation functionality, you get plain text that does not 'turn into' a link until you save the page. Just make sure the url in the spreadsheet is plain text and not a link.
Thanks for looking into it, but I think I'm going to just brute force it. The fastest and most accurate way I've found is to paste all of the URLs into the table, click one, click Edit, Triple-click the Link Text box to select all, then paste in my desired text. I want all my links to have the same text, which makes this easier. If I wanted different text for each one, I'd have to copy from my spreadsheet on each one before pasting.
Thanks everyone for answering last week’s question. The winner of the random drawing from those who commented is: @LarryBrock I’ll contact you separately with your prize details. This wee...
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events