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@lists.freedesktop.org
Reporter: rwcar...@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._______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
