Description: Calc adds a 14t decimal place on addition/subtraction of 2-decimal numbers Steps to Reproduce: See the spreadsheet attached Actual Results: The addition result in the example spreadsheet is -3,08000000000004 Expected Results: -3,08 Reproducible: Always User Profile Reset: No Additional Info: The bug is reproducible with both Version: 6.3.3.2 and 6.4.0.0.alpha1 CPU-Threads: 4; BS: Mac OS X 10.15.1; UI-Render: GL; VCL: osx; Gebietsschema: de-DE (de_DE.UTF-8); UI-Sprache: de-DE Calc: threaded
Created attachment 155613 [details] Calc sheet showing the bug
Created attachment 155614 [details] PDF printout showing the bug
Yes, can happen. See also http://0.30000000000000004.com/ https://docs.microsoft.com/en-us/office/troubleshoot/excel/floating-point-arithmetic-inaccurate-result https://www.microsoft.com/en-us/microsoft-365/blog/2008/04/10/understanding-floating-point-precision-aka-why-does-excel-give-me-seemingly-wrong-answers/ https://en.wikipedia.org/wiki/Numeric_precision_in_Microsoft_Excel https://en.wikipedia.org/wiki/Loss_of_significance