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,359,879
Community Members
 
Community Events
168
Community Groups

Pasting a numbers from Excel wit the form 0.999 into a table results in cells with the values 1. 999

Edited

I have an excel spreadsheet with numbers of the form 0.75464, i.e. Zero Point a string of numbers.

I paste this into a Confluence Cloud Table and the cells with these numbers in are transformed into table cells <td>, containing ordered lists <ol> with the fractional part (or mantissa) only of the number appearing as a list item. This is therefore rendering the number with a proceeding 'Item number' which makes it appear as if it is 1.XXXX, e.g. 1. 75464.

This did not happen on local Confluence Server. I have tried formatting the numbers differently in excel but to no avail. I am using MacOS 10. I have tried with the latest Safari and Chrome.

Screenshot 2020-01-03 at 09.47.40.pngScreenshot 2020-01-03 at 09.48.59.png

1 answer

0 votes
Shannon S Atlassian Team Jan 06, 2020

Hello John,

Thank you for all the testing you did on this issue!

You've run into a bug that we discovered in Confluence Cloud, which I reported below:

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

It appears to be related to the formatting, so pasting the contents into a code block or pasting from a raw text document appear to work without auto-formatting to a numbered list.

Please watch that bug so you can be updated when there are any changes or fixes released.

Thank you again.

Regards,

Shannon

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Jira

Online AMA this week: Your project management questions answered by Jira Design Lead James Rotanson

We know that great teams require amazing project management chops. It's no surprise that great teams who use Jira have strong project managers, effective workflows, and secrets that bring planning ...

172 views 1 6
Read article

Atlassian Community Events