Ask Your Question
1

Decimal precision - how to have 18 decimals? [closed]

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

tototototototototo gravatar image

updated 2020-08-13 20:14:46 +0200

Alex Kemp 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 reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-08-13 20:15:22.529655

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

Question Tools

1 follower

Stats

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

Seen: 743 times

Last updated: May 29 '18