Description: in LibreOffice Calc the operation "=581.9-582.58" say "-0.680000000000064" and not "-0.68" Steps to Reproduce: 1.in a cell, enter : "=581.9-582.58" 2. 3. Actual Results: -0.680000000000064 Expected Results: -0.68 Reproducible: Always User Profile Reset: No Additional Info:
Created attachment 152992 [details] screenshot
Created attachment 152993 [details] calc exemple of bug
That's how floating point arithmetic works, for details see: https://en.wikipedia.org/wiki/Floating-point_arithmetic#Accuracy_problems However, when you set the number format to Number / General, you should see a nicely rounded number in the cell.
no ... 1. open a *NEW* Calc document with default style model of document 2. take a random cell 3. past in "=581.9-582.58" 4. enlarge the column over 4cm 5. see ...
Because that's the number. You can also specify the number of decimals manually.
Seriously, please ! Explaining a problem is good. But that’s only half of the way ... only half. A simple arithmetic operation returns a false result. Masking this with formatting is not satisfactory because I want to use the value for my further development, the value, not its display. And I’m probably not the only one in this situation... For my project, I’m gonna do a dirty stuff ... I will add a forced ROUND, but please stop pretending that the problem is solved !
There's no issue here, please read the linked wikipedia article on floating point operations. Thank you.