https://bugs.documentfoundation.org/show_bug.cgi?id=152039
Bug ID: 152039
Summary: 12 decimal places adds a 1
Product: LibreOffice
Version: 7.4.2.3 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: minor
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Hello
Can anything be done, when specifying 13 decimal places to get it to not show a
1? Without me using clunky =ROUND etc throughout my spreadsheet.
=8495.95 - 8208
287.9500000000010
I saw there are lots of tickets about how numbers are represented in floating
point so when converted back to decimal due to rounding errors it's not
perfect.
I understand all of this, I don't need an explanation of floating point... I
always recall "double" precision floating point has 15 decimal places. of
course "float" 32 bit only has 7 digits of precision. Is Calc not using double
precision?
--
You are receiving this mail because:
You are the assignee for the bug.
