Performing copy and paste from Excel results in wrong display of data

Tags: #<Tag:0x00007f1368139e08>

https://jsfiddle.net/cs4rhkxn/7/

This is what you see when you open and run my jsfiddle:

image

For easier explanation, try to create an Excel Sheet containing two cells with values (B3 = 1000, B4=1,000):
image

When I copy the B3 cell (value: 1000), then paste it to the C1 cell in JSFiddle:

image

Copy and Paste operation ends successfully.

However, when I try to copy the B4 cell (value: 1,000) in Excel, then paste it to the C1 cell in JSFiddle,

image

image

The value is getting to one (1).

Why is this happening?

I try to study the below Q&A, but still couldn’t understand how to fix this issue.

Hey @kazuya.okamoto

this topic is pretty similiar to what I have already shared today. In this case you have a non-decimal value 1 and a decimal value 1.5 that is being formatted to 1.500