https://bugs.documentfoundation.org/show_bug.cgi?id=160306
--- Comment #5 from Mike Kaganski <mikekagan...@hotmail.com> --- (In reply to Michael from comment #0) > We have a contractor who submits bills in xlsx format, and 4 times in 2023 > this bug caused us to pay a penny different than they expected (it was > caught by auditors at the first of this year). (In reply to ady from comment #2) > IDK when Calc will be usable again. Four major versions with incorrect > results is more than enough. (In reply to ady from comment #4) > FWIW and JIC someone is tempted to suggest using ROUND()... 1. The change is caused by https://gerrit.libreoffice.org/c/core/+/129948; and it made the display more *correct* WRT the actual value of 2697.0649999999996, which is rightfully rounded to 2697.07. The reason why the calculation produces that value is explained in FAQ [1]. 2. In the specific case that Michael describes, where the rounding is not intended just for display, but is the actual result of the calculation, the *correct* thing to do *is* use of ROUND function. 3. But generally, the difference between the ROUND and display rounding is not nice. I need to think how to fix this problem. 4. ady: please avoid emotional, unrelated phrases that don't add anything useful to the issue, but make indirectly make others feel bad. I don't feel comfortable working on this issue now, after your "contribution". [1] https://wiki.documentfoundation.org/Faq/Calc/Accuracy -- You are receiving this mail because: You are the assignee for the bug.
