https://bugs.documentfoundation.org/show_bug.cgi?id=161015
--- Comment #3 from b. <[email protected]> --- Created attachment 194405 --> https://bugs.documentfoundation.org/attachment.cgi?id=194405&action=edit some examples of rounding fails, hi, thanks for caring, to stay clear: I do not propose to mimic gnumeric, they have fails I'm investigating, I do not propose to mimic Excel, they have their own fails, I'd like mathematical meaningful results independent of idiotic input, to set users free from manual having to check. Each and any input should have a meaningful '0', 'ERR', or calculated value. sheet: see attached, it's surely not perfect but should provide an entry. # 73410 ... old problem? not completely covered? expect, not yet tested, similar problems with other rounding functions, also with those 'to multiples' like floor and ceiling. Mathematical it's not really difficult, I'd propose to implement some triaging steps returning '0' or ERR where applicable before the calculations. -- You are receiving this mail because: You are the assignee for the bug.
