How to copy and paste entire table in Confluence 4.1

Editor improvements Copy and paste table improvements You can now copy and paste multiple table rows and entire tables. There are also new keyboard shortcuts. You can now use Alt+Up Arrow or Alt+Down Arrow to add a row above or below the current row.

This is listed as a new feature of 4.1 however I am unable to locate the functionality of this. Has it been implemented?

9 answers

Thanks @njinji. The quickest for me was similar:

  • 1 : Create single cell table
  • 2 : Unformat header (remove header row)
  • 3 : Select all rows in source table
  • 4 : Copy rows (CTRL SHIFT C)
  • 5 : Place cursor in destination table
  • 6 : Paste rows (CTRL SHIFT V)
  • 7 : Delete last empty row in destination table

Perfectly done! This worked exactly as stated.

Like 3 people like this

Another similar technique would be to:

  1. Select text from above & below the table you wish to copy
  2. Paste into the destination.
  3. Delete excess text above/below the pasted table in destination.

To me this was simpler, especially since unfortunately the technique mentioned by @Arithzari didn't work for me.

Like 5 people like this

Thank you very much @Patrick Nelson. Your solution worked great!

Like 1 person likes this

Thank You. This works well.  Saves time.

@Patrick Nelson - A bunch of thanks. Day saved.

My Company uses Macs. The command key isn't doing this correctly. 

Command key works fine for me, using macOS High Sierra.

Thanks for the hint on removal of header row, that's worth gold!

 

Wow, it was so simple! Thanks @Patrick Nelson!!!

Like 1 person likes this

Another Thank You to Patrick Nelson.  This technique worked beautifully!

Thanks @Patrick Nelson! Your solution was simple and it works!

Like 1 person likes this

Hey @Patrick Nelson, my one has tables only. So I added testing words before and after the table and give it a go. This is magic. Thanks.

Like 1 person likes this

I can't believe this is still an issue in 2019... c'mon Atlassian.. Let's get out of the 90's!!!!!!   #FeatureRequest

It's 6 years later, and no reasonable feedback or change has been made.

Today marks the threshold : I'm starting the process of breaking away from Atlassian and moving to a better tool.

How I feel coming back a few years later, realizing how many people I had helped 😄

hackerman.gif

Like 1 person likes this

Your software is crap. Previously: I can create tables with || for the headers and | for the table elements. Now: well, nothing you've touched with your awful editor works right and I'm searching help for HOW TO PASTE A BLOODY TABLE. I'm also begging the cto to stop sending you people money.

Mmm, well, much as I also dislike some things about the new editor, there's no need to be quite so aggressive. If you ask for help nicely, you might get some constructive help. Yelling and being rude gets you ignored or even shut out.

If you really don't get on with the new editor, then you're already doing the right thing in asking your company to switch to another system. I know you're not alone - a lot of my clients have said "we're not moving to v4" and are either waiting to see if there's an adequate fix forthcoming or initiated migrations away from Confluence because of this.

Like 1 person likes this

+1 for Nic's comment.

I agree with @Nic Brough [Adaptavist]However, in the light of a failed process, aggression helps highlight the problem : Atlassian simply does not (or cannot) process constructive feedback. Aggression is simply the next escalation. Atlassian would do well to take note how much 'aggression' on their support forums is based on escalated frustration at the absence of logical and expected functionality.

The hints are not being taken.
The right thing to do is to stop using Atlassian. Talk with you wallet, and talk back in a language that Atalssian will listen to : using superior competition.

Multiple other useful and simple suggestions by myself (other accounts) and other constructive feedback have not been acted on.

Today marks the threshold : I'm starting the process of breaking away from Atlassian and moving to a better tool.

I don't think these improvements affect UI changes in the editor from 4.0 to 4.1. Basically, to copy multiple rows, just highlight table rows, select "Copy Table Row" toolbar button, move the cursor to where you want to paste, and then select "Paste Table Row" button. Alt+Up Arrow or Alt+Down are just keyboard shortcuts. For more information on working with tables, please see: http://confluence.atlassian.com/display/DOC/Working+with+Tables

Guys, 1. create a new table with the same number of columns (just a header and 1 row is fine) 2. highlight all the rows you want from the old table and click the copy table rows icon 3. click into a cell in the new table and press the paste table rows icon so you see instead of copying the entire table you are pasting all the rows -- same thing!

If you are using Table Filter and Charts add-on, you can use a Copy Table button to copy any table to the clipboard in a single click.

Here is a related bug report:

https://jira.atlassian.com/browse/CONFCLOUD-58589?jql=text%20~%20%22copy%20text%20and%20table%22

Suggested work around is to copy from the finished/published version, open the editor and paste it which did not work for me.

 

What worked for me was to

* Go to edit mode, mark a mixed section with text and table and copy it

* Go the target section and paste

* Manually delete the remaining empty table (very annoying).

This only works once: After paste I am not able to select the next section to copy.

=>Save the current state. Go again to the edit mode. Now you can do the next copy paste operation.

 

 

Copy your table from Excel into Word, then from Word into Confluence. 
This may not apply to each person's environment, but it's a lot simpler than going through plugins and multi-step processes.

I tried to copy a table from a Confluence page to an email I was writing (not just link, but copy).
I tried to do it in Linux, and my email client is Thunderbird.
Whenever I selected the table (and the text around it), it did not select the table headers, and the formatting of the pasted table did not look good (I think it did not have border lines).
I tried it both with Firefox and Chrome.
The solution was to go to edit mode in Confluence and there the table did copy correctly (also with the header line), and when pasted to Thunderbird, it looked OK.
Hope this helps.
BTW I use Confluence 6.2.4, but a search for my problem brought me to this page.

Goto http://excel2jira.bluurgh.com/

Paste your excel table and you will get the characters to paste in jira.

 

It worked for me. 

Suggest an answer

Log in or Sign up to answer
Community showcase
Published Tuesday in Confluence

Confluence Admin Certification now $150 for Community Members

More and more people are building their careers with Atlassian, and we want you to be at the front of this wave! Important Dates Start the Certification Prep Course by 2 April 2019 Take your e...

198 views 2 10
Read article

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you