In any cell in LibreOffice enter the following formula =1475.99-1440.32 and observe the output. Expected: 35.67 Actual: 35.6700000000001 It appears LibreOffice is subject to the float errors found in primitive data types in most programming languages. As a Java developer I am aware of this float issue and how in Java BigDecimal is used for accurate decimal calculations. However in a spreadsheet I would expect accurate decimal calculation by default and this is the case with tools like excel or google sheets. Even worse is that if I change the cell format to currency I still observe this float error. It is worse as currency typically should be using accurate decimal calculations, I cannot think of a case when currency should use binary float types. The version of LibreOffice calc I have tested is 7.5.3.2.
https://wiki.documentfoundation.org/Faq/Calc/Accuracy
(In reply to Michael Whapples from comment #0) > and this is the case with tools like excel or google sheets. This statement is wrong. Just add enough decimals to the cell format to see the real value there.