https://bugs.documentfoundation.org/show_bug.cgi?id=89373
k...@cox.net changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|RESOLVED |REOPENED
Resolution|DUPLICATE |---
Ever confirmed|0 |1
--- Comment #4 from k...@cox.net ---
Andis' example is an excellent example of a real use of spreadsheets that most
programmers don't understand and can't imagine. The SUM() bug is probably
related to the same cause as bug 50299 (improper handling of significant digits
in floating point calculations); however, if it is caused by something
specifically in the implementation of the SUM() function, then its correction
in the MOD() (and DATE()) functions will not correct it in the SUM() function.
You are fortunate; you noticed that the answers were incorrect. Since I noticed
the related problem with the MOD() and DATE() functions, I have returned to
using Excel and am warning people that they could get unpleasant surprises if
they use these functions in open source spreadsheets. As I commented on 50299,
engineers, doctors and accountants cannot use spreadsheets that give random
incorrect answers when used as they would normally be expected to be used.
Does the problem still exist if the links in B3:BJ16 to values calculated in
another document are replaced with links to values calculated in another
worksheet in the example document? If so, you would be able to provide an
example that shows the problem.
I would not mark this as resolved, but as more information required (an example
that shows the problem).
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
