Ask Your Question
1

Decimal precision - how to have 18 decimals?

asked 2018-05-29 19:27:28 +0200

tototototototototo gravatar image

Hello, I am inputting numbers that have 18 decimals. For example : 0.041345058938493747

Default settings seem to round up this number and save it as: 0.0413450589384938

I have tried to use the Format... dialog to increase precision, but it still rounds it up to 16 decimals: 0.041345058938493800

So...? How do I increase precision? Thanks in advance!!!

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
2

answered 2018-05-29 20:11:47 +0200

cloph gravatar image

You can't. LibreOffice uses IEEE 754 representation of the numbers, and that just doesn't offer that level of precision.

see also https://ask.libreoffice.org/en/questi...

and general description of the way precision works in IEEE 754 here: https://en.wikipedia.org/wiki/Numeric...

If you want to store the values in a spreadsheet, you have to do so as text (enter them by prefixing them with a single quotation mark, that will force the input to text)

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2018-05-29 19:27:28 +0200

Seen: 267 times

Last updated: May 29 '18