Description: hello, i m french, sorry for my english... for those numbers, and just for those one, -474 -56,86 10,59 40,86 51,29 129,57 30,35 41,56 22,89 167,47 if you SELECT all of those, you will get 36.2799999999... no reason. the good one is just -36.28. with Version: 5.2.7.2 Build ID: 2b7f1e640c46ceb28adf43ee075a6e8b8439ed10 Threads CPU : 8; Version de l'OS :Windows 6.1; UI Render : par défaut; Locale : fr-FR (fr_FR); Calc: group Steps to Reproduce: 1.WRITE THE GIVED NUMBERS, one under the other one 2.select all togheter 3.see the difference between the sum and the selection. Actual Results: exactly the same, -36.2799999... Expected Results: -36.28 Reproducible: Always User Profile Reset: No Additional Info: you can email me if you do not understand what i try to explain...
Created attachment 149227 [details] this is a copy a of the screen, problem highlited in yellow this is a copy a of the screen, problem highlited in yellow
That is due to loss of precision when using the IEEE 754 floating point format. All computer software not using binary coded decimals or other means to correct precision round-offs suffers from it. See http://0.30000000000000004.com/ https://en.wikipedia.org/wiki/Numeric_precision_in_Microsoft_Excel 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/ If you format the cells involved to two decimals, for example 0.00 then that format will be used in the status bar as well and the result displayed accordingly rounded.
(In reply to Eike Rathke from comment #2) > That is due to loss of precision when using the IEEE 754 floating point format. IMHO we can set this issue to RESOLVED/NOTABUG
*** Bug 129220 has been marked as a duplicate of this bug. ***