https://bugs.freedesktop.org/show_bug.cgi?id=71339
Ady <ady...@hotmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Summary|EDITING SUM function range |EDITING sigma icon (sum
|selection broken |function) operating on
| |selected range
--- Comment #3 from Ady <ady...@hotmail.com> ---
(In reply to comment #2)
> Just to be sure that we are speaking about the same behaviour :
> - in a new spreadsheet, I set A1 to 1, A2 to 2, A4 to 4 and A5 to 5
> - and I select A6 and press the SIGMA icon next to the formula bar
> - this result to a proposal of range A4:A5, resulting from the hypothesis
> that the A3 empty cell marks the end of the current table and the beginning
> of a new one, above; of course I'm supposed to correct the range if the
> hypothesis is wrong (LibO can't know...)
> - the following major spreadsheet programs (Works ; Excel 97 ; AOO 4.0 ; OOo
> as far as I remember) work this way.
>
> Can I humbly, without any "troll" tentative, ask you to write down the
> expected SIGMA behaviour, for you and your organisation ?
>
> Regards
No, the behavior the reporter is talking about is for example:
A1: (empty)
A2: 2
A3: 3
A4: (empty)
A5: 5
Then select A1:A6 and press the SIGMA icon. The result is:
A6: =SUM(A2:A5)
but the reporter is expecting:
A6: =SUM(A1:A5)
So, if the initial selection is A6 *only*, then Calc goes up until the first
empty cell when SIGMA is pressed. This is expected ( =SUM(A5:A5) ).
But if the initial selection is the *range* A1:A6, then the user is expecting
for that selection to be respected, getting the SUM function in the latest
lower cell with the whole selected range (except the latest lower cell)
included in the SUM function.
For my example here:
_ Actual result (according to the reporter) in A6: =SUM(A2:A5)
_ Expected result (according to the reporter) in A6: =SUM(A1:A5)
I am not saying that the current behavior is necessarily wrong. I am only
trying to give an example of what the reporter is saying.
(BTW, this report is currently set as BLOCKER. I am not changing this now, but
I doubt this should be really consider as such).
Since the behavior is related to the SIGMA icon, while the SUM function itself
is correct, I am editing the Summary accordingly.
Regards,
Ady.
--
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
