https://issues.apache.org/ooo/show_bug.cgi?id=125978
Regina Henschel <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|REOPENED |RESOLVED CC| |[email protected] Resolution|--- |DUPLICATE --- Comment #8 from Regina Henschel <[email protected]> --- That is a known limitation of the internal representation of numbers in data type double. Find similar problems in https://wiki.openoffice.org/wiki/User:Regina/MyDrafts Tips: You can round the result to a lower precision. Do not make case distinction with =0 but with abs(..)<1E-10 e.g. When calculating with currency, calculate with integer values of the smallest unit, e.g do not use Euro but Cent; only display results in Euro. If you need an accuracy of more than 14 digits, a spreadsheet is the wrong tool. *** This issue has been marked as a duplicate of issue 69749 *** -- You are receiving this mail because: You are the assignee for the issue. You are watching all issue changes.
