[Libreoffice-bugs] [Bug 118466] New: EDITING: Clicking the Sum toolbar button (Σ) after using Select All gives unexpected results

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 118466
           Summary: EDITING: Clicking the Sum toolbar button (Σ) after
                    using Select All gives unexpected results
           Product: LibreOffice
           Version: 6.0.5.2 release
          Hardware: x86-64 (AMD64)
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: rwcaret2 at gmail.com

Description:
The toolbar button for Sum (Σ) should sum up only the contents of the
filled-cells and output to an adjacent area instead of the extreme corners for
the entire worksheet.

This operation as currently implemented also takes longer than is necessary
because instead of summing only the contents of a few cells, it tries to work
on the entire sheet (1023 columns x 1048575 rows).

Steps to Reproduce:
1. Enter in 1 and 1 in separate rows in a new sheet (Cells A1 and A2).

2. Select All using any method (Edit > Select All / Ctrl+A / Cmd+A /
Ctrl+Shift+Space).

3. Click the Sum button (Σ) in the toolbar (to the left of the Formula Input
line).

Actual Results:
- Calc will try to work on the entire sheet.

- Outputs will be entered into each corner of the sheet (use Ctrl+Arrow or
Cmd+Arrow to jump to the end of the sheet): Cells AMJ1, AMJ2, AMJ1048576 and
A1048576.

- The operation will take a long time and force one CPU core to be at 100% for
about 12 seconds in 6.1.0.0.beta2 and 18 seconds in 6.0.5.2 with an Intel(R)
Core(TM) i3-4130 CPU @ 3.40GHz) (as reported by lscpu).

- It will appear to the user as if LibreOffice Calc has frozen.

Expected Results:
In this example the calculation should only be applied to the filled cells and
result should output to Cell A3 only.


Reproducible: Always


User Profile Reset: Yes



Additional Info:
Tested with LibreOffice 6.0.5.2 and 6.1.0.0.beta2 on both Fedora 28 and macOS
10.13.5 - I believe the behaviour in Windows will be the same (to be
confirmed).

While the user will quickly learn to not press the Sum after a Select All
again, Gnumeric and Excel both correctly lead the user to summing and
outputting to A3. Interestingly, Google Sheets and Apple Numbers also have less
desirable outcomes (but no CPU spikes).

With Calc, the user might think Calc has hung and might forcibly terminate it -
potentially leading to data loss.

A previous version on Mac (I believe 6.0.1) was also tested and showed
completely different totals - so this may or may not be of interest.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20180630/2f19d8b7/attachment.html>