Ask Your Question

Loss of precision when exporting to CSV

asked 2017-07-12 20:04:00 +0200

Joris gravatar image

When converting a table in Libreoffice calc to a CSV file, my numbers loose some precision. E.g. when I click on a specific cell, it shows:


When I store this file as a CSV file, it shows the following number:


Is there a way to fix this?

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2017-07-12 22:01:56 +0200

Lupp gravatar image

Suppose the 'Numbers' format was set to #0.0000000000 and the actual value given with highest available precision was 15 significant digits (as usual for numbers in Calc).

The cell showed -79.9952437087 (10 decimal places as specified in the format string).
When edited the number was shown as -79.9952437087173 (high precision display of the content).

You wrote to csv with the option 'Save cell content as shown' enabled.


edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2017-07-12 20:04:00 +0200

Seen: 364 times

Last updated: Jul 12 '17