[Libreoffice-bugs] [Bug 71339] EDITING sigma icon (sum function) operating on selected range

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=71339

Eike Rathke  changed:

   What|Removed |Added

 Status|NEW |ASSIGNED
   Hardware|Other   |All
   Assignee|libreoffice-b...@lists.free |er...@redhat.com
   |desktop.org |
   Severity|critical|major

--- Comment #15 from Eike Rathke  ---
For test cases shedding some light how it is to work see
https://bz.apache.org/ooo/attachment.cgi?id=46097 (.ods)
For the test case specification/description see
https://bz.apache.org/ooo/attachment.cgi?id=46096 (.html)

However, I agree that when selecting additional empty rows/columns on top/left
of the actual data range these should be included in the final result and not
stripped.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 71339] EDITING sigma icon (sum function) operating on selected range

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=71339

--- Comment #14 from Xzorg6  ---
This bug is still present in LibreOffice 5.1.4.2 (July 2016) on any OS.
With the same behavior reported in 2013.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 71339] EDITING sigma icon (sum function) operating on selected range

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=71339

Robinson Tryon (qubit)  changed:

   What|Removed |Added

 CC||qu...@runcibility.com
   Severity|blocker |critical

--- Comment #13 from Robinson Tryon (qubit)  ---
Dropping Severity -> critical (we've deprecated the 'blocker' value)
https://wiki.documentfoundation.org/QA/Bugzilla/Fields/Severity#Severity_Levels

-- 
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

[Libreoffice-bugs] [Bug 71339] EDITING sigma icon (sum function) operating on selected range

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=71339

raal r...@post.cz changed:

   What|Removed |Added

 CC||anth...@youngman.org.uk

--- Comment #12 from raal r...@post.cz ---
*** Bug 93257 has been marked as a duplicate of this bug. ***

-- 
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

[Libreoffice-bugs] [Bug 71339] EDITING sigma icon (sum function) operating on selected range

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=71339

--- Comment #11 from Anthony Youngman anth...@youngman.org.uk ---
Just done even more testing ...

If the user selects a *horizontal* row, the autosum appears to respect the
user's request, and sums the selected cells.

If the user does an autosum on a column consisting solely of sums, the autosum
does NOT ignore cells containing sums, as claimed, but correctly sums the
entire column.

Try the following - create a 4x4 grid of random numbers, select and sum the
rows. Now sum the totals column *without* doing a select. See what I mean?

Confusing or what?

-- 
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

[Libreoffice-bugs] [Bug 71339] EDITING sigma icon (sum function) operating on selected range

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=71339

--- Comment #9 from Anthony Youngman anth...@youngman.org.uk ---
Just to point out that this behaviour was actually probably copied from Excel.
Check it out in Excel 2003, but this is exactly what I expect when I'm working
with Excel (and I agree, it is a nuisance ... damn programs thinking they know
best! :-)

-- 
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

[Libreoffice-bugs] [Bug 71339] EDITING sigma icon (sum function) operating on selected range

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=71339

--- Comment #10 from Anthony Youngman anth...@youngman.org.uk ---
Just adding that I've filed a similar bug (93257) again asking for autosum to
respect the user's selection. This is behaviour I expect from Excel, and I
believe was in QuattroPro before that (that's QP for Win3.11, ie back in the
DOS days).

And even used as described here, autosum doesn't work. Enter a column of
figures, click in the cell below and click autosum. Works fine. Add more
figures below (ie, in the user's mind, the previous sum was a *sub*total). Now
autosum the column again. It creates a new total of just the numbers after the
previous total!

Okay, that behaviour *could* be seen as logical. But if that behaviour is
wanted, surely the user can just stick a blank line after the previous subtotal
to indicate it? If I do that, I always want a new (sub)total of the *entire*
column.

Basically, it seems to me that the design of autosum makes sense, it just
doesn't work in the real world the way most people want to use it :-( (and
breaks the principle of least surprise in that it produces very different
results from what most people expect from other spreadsheets).

Cheers,
Wol

-- 
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

[Libreoffice-bugs] [Bug 71339] EDITING sigma icon (sum function) operating on selected range

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=71339

Goran Rakic gra...@devbase.net changed:

   What|Removed |Added

Version|4.0.2.2 release |Inherited From OOo

-- 
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

[Libreoffice-bugs] [Bug 71339] EDITING sigma icon (sum function) operating on selected range

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=71339

--- Comment #8 from Goran Rakic gra...@devbase.net ---
This is a duplicate of #62279, but I think this one is better documented.

There is a discussion on LibreOfficeForum.org about the issue:
http://en.libreofficeforum.org/node/6918

I know at least one annoyed user that would very much like if the AutoSum can
be modified to respect selected range. That would break consolidation usage
(making sum of the sums) but it could still work for those users, just without
selecting the range.

-- 
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

[Libreoffice-bugs] [Bug 71339] EDITING sigma icon (sum function) operating on selected range

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=71339

--- Comment #7 from QA Administrators qa-ad...@libreoffice.org ---
** Please read this message in its entirety before responding **

To make sure we're focusing on the bugs that affect our users today,
LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed
bugs which have not been touched for over a year.

There have been thousands of bug fixes and commits since anyone checked on this
bug report. During that time, it's possible that the bug has been fixed, or the
details of the problem have changed. We'd really appreciate your help in
getting confirmation that the bug is still present.

If you have time, please do the following:

   *Test to see if the bug is still present on a currently supported version of
LibreOffice (4.4.1 or later)
   https://www.libreoffice.org/download/

   *If the bug is present, please leave a comment that includes the version of
LibreOffice and your operating system, and any changes you see in the bug
behavior

   *If the bug is NOT present, please set the bug's Status field to
RESOLVED-WORKSFORME and leave a short comment that includes your version of
LibreOffice and Operating System

Please DO NOT

   *Update the version field
   *Reply via email (please reply directly on the bug tracker)
   *Set the bug's Status field to RESOLVED - FIXED (this status has a
particular meaning that is not appropriate in this case)


If you want to do more to help you can test to see if your issue is a
REGRESSION. To do so: 

1. Download and install oldest version of LibreOffice (usually 3.3 unless your
bug pertains to a feature added after 3.3)

http://downloadarchive.documentfoundation.org/libreoffice/old/

2. Test your bug 
3. Leave a comment with your results. 
4a. If the bug was present with 3.3 - set version to inherited from OOo; 
4b. If the bug was not present in 3.3 - add regression to keyword


Feel free to come ask questions or to say hello in our QA chat:
http://webchat.freenode.net/?channels=libreoffice-qa

Thank you for your help!

-- The LibreOffice QA Team This NEW Message was generated on: 2015-04-18

-- 
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

[Libreoffice-bugs] [Bug 71339] EDITING sigma icon (sum function) operating on selected range

[bugzilla-daemon]

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

[Libreoffice-bugs] [Bug 71339] EDITING sigma icon (sum function) operating on selected range

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=71339

--- Comment #6 from Dominique Boutry dominique.bout...@laposte.net ---
Click on the Sigma, then select [the range] : I appreciate the simplicity of
this assertion (understanding it is preceded by Select the cell where you want
the SUM, then).

In this case, there would be no tentative of misuse if the sum was unique and
housed only in the (unique) active cell, instead of trying a possibly useless
computing on all selected cells.

However, the feature consisting in filling in 1 clic the empty bottom line of a
table with column SUMs (on a proposed range which is globally rectangular) is
provided both in Excel, AOO and LibO, so we can't get rid of it as easily, even
if it is impossible to subsequently adjust the ranges globally. So we really
need a specification for AutoSUM.

-- 
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

[Libreoffice-bugs] [Bug 71339] EDITING sigma icon (sum function) operating on selected range

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=71339

GerardF gerard.farg...@orange.fr changed:

   What|Removed |Added

 Status|UNCONFIRMED |NEW
 CC||gerard.farg...@orange.fr
 Ever confirmed|0   |1

--- Comment #5 from GerardF gerard.farg...@orange.fr ---
The Sigma is called *auto*sum.

The way to use it is the following :

Put the focus on the cell where you want to have the Sum, then Calc detect the
range going up to the 1st empty cell (or to the left is cell above is empty).
If the proposed range is not that you want, select the correct range with
mouse.

So it is Click on the Sigma, then select. Not select, then Click.
The AutoSum is not intended to sum the previous selection but to automatically
detect the range in function of the position of the cursor.

The way you use it is a misuse.

Despite everything, I set it to NEW to have the opinion of a Calc dev.

-- 
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