How do I paste data into a table using Confluence 5.7?
To insert large tables with the second option you need to first hit Ctrl + Shift + D and then paste in the table in wiki markup form.
Wrap the table in any macros required if you know the macro name and parms. This can be a serious PITA to do after a table has been created in the Confluence 5 GUI.
Click Insert and the resulting table will be converted to the new wiki format into the page.
According to this link, I'd assume it's a bug with the version of Confluence, at least as far as the sorting goes.
Looking through the Confluence JIRA, there appear to have been several issues with copy/pasting from Excel over the development. At least there's a workaround:
Workaround:
Go to the editor again
Cut out the (unsortable) table
Paste it again
Mark the first row as Header
Save the page
-> Now the table is sortable
If that does not work, please install the The confluence source editor, then edit the page to:
Remove the row " "
Replace all "td" tag to "th" tag for the first row of the table. For example, the column name "Number" will need to change from "Number" to "Number".
I went a circuitous route to accomplish this:
- Made a text file with my information and tab-separated the fields
- Pasted this data in to Google Sheets
- Copied the cells from Google Sheets
- Pasted them in to the a pre-made table in Confluence
It was still faster than writing each field manually.