I've not had a problem with this before (even last week) so not sure if there has been any Confluence update recently that may have introduced the bug but, when I paste a table from Excel into a Confluence page, Confluence tries to be "clever" and think that my numbers are a "numbered list", overwriting my numbers :-o!
E.g. if I had Excel numbers in separate cells of (with bullets here just being simple representation for this question, not what is in the Excel cells):
the Confluence cells come out like
with the "1." being the Confluence "numbered list" part. I.e. Confluence is totally overwriting the integral part of my numbers with the numbered list and obviously each cell starting a new numbered list.
This is now driving me potty 🤪.
Thank you for reporting this! I was able to replicate in Confluence and Jira new issue view as well. It turns out it's not only affected by pasting from Excel:
This is the first I've seen this, so right now we'll start gathering data on this. Please click This affects my team and you'll automatically be added to the list of watchers to receive updates in the future.
Let me know if you have any questions about that.
I discovered that if I paste the values into a code snippet, it will retain the values. You'll lose the grid, but you can still display it like this:
It's not great, but it will enable you to at least preserve the data in Confluence.
Ah, sorry, didn't see your possible workaround re code snippet. Yeah, that wouldn't work for me because the tables I was pasting into Confluence from Excel had background colour formatting too (e.g. Conditional Formatting 3-Colour Scales).
Although you can't change the background colour formatting natively in Confluence (that I have found anyway), I have found that, if I paste in from Excel, that background colour gets retained.
I'm sorry that you won't be able to use the workaround of the code snippet. Could you display the Excel file directly on the page until it's resolved?
By the way - I reported this to the development team, and I believe they are currently triaging this.
Take our 5-minute survey to win a $500 Visa gift card! Are you currently using Confluence Cloud? We want to hear from you! Fill out this quick survey about your Confluence Cloud experience so we ...
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