https://bugs.documentfoundation.org/show_bug.cgi?id=155795
--- Comment #2 from Eike Rathke <[email protected]> --- Comment what? All major spreadsheet implementations use IEEE 754 floating point double precision to store values, accuracy deficiency and rounding errors are inherent and well known, see https://help.libreoffice.org/latest/en-GB/text/scalc/01/calculation_accuracy.html?DbPAR=CALC and https://wiki.documentfoundation.org/Faq/Calc/Accuracy Asking to store fractions ("divisions") internally instead of binary floating point values doesn't help much as that would already be lost when storing the value in any of the commonly used file formats, unless also the storage file format is changed. Besides that, processing fractions in calculations would come with a performance penalty and would require an entire rewrite of the interpreter calculation engine. Something very unlikely to happen. Yes, real accountancy software like GnuCash does not use floating point values but fractions, both internally and stored to file, and real accountants also don't use spreadsheets to do serious accountancy. -- You are receiving this mail because: You are the assignee for the bug.
