search

nadbm / react-datasheet

Excel-like data grid (table) component for React
https://nadbm.github.io/react-datasheet/
MIT License
5.4k stars 455 forks source link

When I copy and paste from MS excel I am not getting exact value #281

Open Avhishek05 opened 3 years ago

Avhishek05 commented 3 years ago

image My excel sheet shows 64 but Actual value is 64.123 when I copy and paste it I get only 64, decimal values are getting removed same happens when I paste on notepad/google sheet too. image

bovan commented 3 years ago

you need to customize the parsePaste property, have a look at #111

Avhishek05 commented 3 years ago

this doesn't help me with my issue

ivarne commented 3 years ago

This is a browser issue. At least in my testing, I only got csv and html (and maybe png) format to the browser when copying from excel, so hidden decimal places are actually lost and never seen by the browser.