https://bugs.freedesktop.org/show_bug.cgi?id=35215
Mike Kaganski <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |RESOLVED Resolution|--- |INVALID --- Comment #5 from Mike Kaganski <[email protected]> --- I'm sorry to say this, but this issue is INVALID. 1. It contains three different problems in one. Each one should have its own dedicated report. 2. The first problem is not a bug. The Sum operation (as it is implemented in LO now) works horizontally, i.e. it automatically fills the arguments for "sum" with cells to the left of current cell. If there are no cells to the left, the arguments stay empty. But, as it is pointed out in bug 61228, the sum is the default function in LO formula, so you may even omit the function name and simply write "=<A1:B2>", and it will give you correct answer. If you enter a formula that contain of consecutive values (like in "=sum(<A3>)<A1:B2>", that expand into "=sum(A3) sum(<A1:B2>)", and then to two values "10 10"), the result is the last value, i.e. the last "10". Actually, when you use the "Sum" (Sigma) button, you are not expected to fill the argument list manually (or, if you need so, you should _modify_ the automatically filled argument list). Thus, your actions in your cells B3 and C3 are incorrect (you needed to replace rather than add). Closing this as INVALID. But I filed two follow-up bugs (concerning deletion of formula resulting in 0 -> Bug 72100, and incomplete undo -> Bug 72101) myself, because I suffer from these myself. If you think that the first issue is not resolved, please file another report for it, maybe an enhancement request. I believe tracking it here would be difficult for a developer (taking into account the considerations above). Thank you for reporting! -- 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
