https://bugs.documentfoundation.org/show_bug.cgi?id=159556
--- Comment #3 from ady <[email protected]> --- With default settings, this is not a bug. The result provided is *less* than 678.965, so the displayed result should not be 678.97. There are additional accuracy concerns regarding spreadsheets in general, but they are not relevant for the specific value in question. Performing the calculations with a normal calculator would not result in such value either. Perhaps you are using some kind of truncation (whether in Calc or in a normal Calculator), or using some kind of "Precision as shown" option, which makes you think that the result is incorrect. In such case, the result might vary, depending on the amount of decimals being considered in each step. IOW, with default settings in Calc, the values are not really "108.41" (108.40613115) nor "570.56" (570.558585). If you want them to be considered with 2 decimals (only) before each calculation, I would suggest using the TRUNC() function on each calculated cell, or one of the related functions available. With the information as provided, I don't see the problem. Maybe the real file needs to be attached. Please be aware that it will be publicly available, so you might not want to do that. In any case, this question seems more adequate at this moment for <https://ask.libreoffice.org> or for the user mailing list rather than for a proven bug report. I am not a developer, so maybe someone else might have a different opinion. -- You are receiving this mail because: You are the assignee for the bug.
