Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Celebration

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root

Avatar

1 badge earned

Collect

Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!

Challenges
Coins

Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.

Recognition
Ribbon

Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!

Leaderboard

Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,456,057
Community Members
 
Community Events
176
Community Groups

Pasting table from Excel turns numbers into "numbered list"

Edited

Hi all,

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):

  • 5.5
  • 4.4
  • 3.3

the Confluence cells come out like

  • 1.5
  • 1.4
  • 1.3

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 🤪.

UPDATES:

  • If I have a table with 55.0 , 44.0 , 33.0 (i.e. multiplied by 10 and formatted to include 1 decimal place), the "numbered list" problem does not happen. So it looks like Confluence is trying to be clever if it spots a single integer followed by a dot.
  • Similarly, if I have 5, 4, 3 (i.e. the single-digit integer without the decimal ".0"), the problem also doesn't occur.

1 answer

1 accepted

1 vote
Answer accepted
Shannon S Atlassian Team Dec 04, 2019

Hello Robin,

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:

  • CONFCLOUD-68744 Pasting single digit decimal numbers in new editor results in numbered list replacing the first digit
  • JRACLOUD-73495 Pasting single digit decimal numbers in new issue results in numbered list replacing the first digit

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.

Thank you!

Regards,

Shannon

Shannon S Atlassian Team Dec 04, 2019

Robin,

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:

CleanShot 2019-12-04 at 14.15.27.png

It's not great, but it will enable you to at least preserve the data in Confluence.

Regards,

Shannon

Like Doug Martin likes this

Many thanks, Shannon....for proving that I am not going potty, and verifying that it is a bug :-).

I have clicked on the This affects my team links so I get notified when it is fixed.

Like Shannon S likes this

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.

Shannon S Atlassian Team Dec 05, 2019

Hi Robin,

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.

Regards,

Shannon

Suggest an answer

Log in or Sign up to answer
TAGS

Atlassian Community Events