https://bugs.documentfoundation.org/show_bug.cgi?id=148070
Mike Kaganski <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Resolution|--- |NOTABUG Status|UNCONFIRMED |RESOLVED --- Comment #4 from Mike Kaganski <[email protected]> --- (In reply to Neil Nation from comment #3) So you see that the calculations are correct, and the displaying two digits fooled you into believing that your data is "round", which it is not. The non-displaying remainder accumulated to give you what you see. 1. Always attach a sample spreadsheet to bugs, not some screenshots, which are absolutely useless for others to reproduce and diagnose the problem. 2. When working with floating-point numbers, be prepared to inaccuracies [1] (but this is not your case here). 3. Know that limiting displayed precision does not change your data, so when you only show two decimals, the rest of the data still plays role. There is a special configuration to change this: Options/Calc/Calculate/General Calculations: [ ] Precision as shown; but I advise you to *not* use that, since it may result in unexpected inaccuracies elsewhere, and you better use ROUND explicitly where you know that your data needs to be rounded to some specific precision. Resolving NOTABUG. [1] https://wiki.documentfoundation.org/Faq/Calc/Accuracy -- You are receiving this mail because: You are the assignee for the bug.
