https://bugs.freedesktop.org/show_bug.cgi?id=50299
--- Comment #8 from Qubit <[email protected]> 2012-05-24 08:03:35 PDT --- --- IMO this is something the users need to be aware of. The limitation applies to all software that runs on current hardware, not just spreadsheet. --- Where should this go in user documentation? A general note on spurious results attributable to use of binary-encoded decimal numbers? Maybe some examples? --- Some mathematical and statistical software overcome this by not using FPU and doing it all at software level [making it] 1000 times slower. --- Is it worthwhile to consider a switch to toggle Calc into "high precision" or "correct results" mode? Are there many use-cases in which it would be beneficial to trade high speed for mathematical accuracy? Here's a related article from Microsoft's knowledge base entitled "How to correct rounding errors in floating-point arithmetic" -- advising MS Excel users, etc... http://support.microsoft.com/kb/214118 -- Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email ------- 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
