https://bugs.documentfoundation.org/show_bug.cgi?id=80017
Matthew Francis <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|REOPENED |RESOLVED Resolution|--- |DUPLICATE --- Comment #7 from Matthew Francis <[email protected]> --- Other tools exist to perform calculation with infinite precision, with all the trade-offs that entails. However, that's a different niche to that filled by a spreadsheet. If you enable Tools - Options - LibreOffice Calc - Precision as shown then the displayed results in cells will be able to be compared precisely regardless of minute differences in the floating point result. That still won't allow formulae which internally generate imprecise floating point results such as =IF(C21-F21<>I21,"ERROR "&(C21-F21-I21),"OK") to succeed, but if you store the result of C21-F21 in a cell and then compare with I21, that will then compare exactly. ("Precision as shown" should be used with caution given its behaviour of discarding all precision beneath that which is displayed) Changing the whole mathematical basis for how Calc works essentially isn't going to happen, so closing this bug again. *** This bug has been marked as a duplicate of bug 67026 *** -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
