[Libreoffice-bugs] [Bug 138761] New: Writer table sum feature doesn't insert formula in empty cell at bottom of selected column range

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 138761
           Summary: Writer table sum feature doesn't insert formula in
                    empty cell at bottom of selected column range
           Product: LibreOffice
           Version: 6.4.6.2 release
          Hardware: All
                OS: Linux (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Writer
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: amiableroz at yahoo.com

Description:
In Calc can sum a column at least two ways:
#1 select cell at bottom of column of numbers and click Sum button at left of
Input line. Contiguous range above selected cell is selected. =sum(<range>) in
input line. Click green check and formula is entered in selected cell.

#2 select column of numbers and empty cell beneath column. Click sum button.
=sum(<range>) appears immediately in empty cell. No need to confirm.

For both methods =sum() formula is inserted in empty cell

In Writer if attempt to sum column similar to #1 above then after inserting
cursor in empty cell range to be summed must be selected after clicking sum
button. And then must click green check to complete summing operation.

If range to sum is selected and end of selection is empty cell presumed to be
destination for sum formula then sum button clicked selected range is emptied
and Input line appears with =sum() formula with third-to-last selected cell
loaded as range of formula. Clicking check to enter formula causes 0 to be
entered in last cell, value in second-to-last cell to again be visible, and
value in third-to-last cell and any cells above to be empty.

This is very unexpected behavior. Especially if one is familiar with either
method of summing described for Calc. 

Request Writer table cell sum feature be modified to work like descriptions
provided for Calc. 

Alternately, request Writer table cell sum feature be modified so that if range
is selected prior to clicking sum button then sum is entered in last cell of
selected range vs current behavior of emptying range.

Steps to Reproduce:
1. create a multi row table in Writer
2. enter numbers in a column in the table, leave at least one empty row beneath
last number
3. select column of numbers and empty cell beneath 
4. click Sum button on table toolbar
5. after clicking Sum button all selected cells are empty
6. click green check mark next to =sum formula in input line
7. all except last two cells that were selected are now empty. Last cell has 0
entered. Next to last cell has number that was there before Sum button was
clicked.

Actual Results:
The result cell value is set to 0 (zero). The cell above the result cell
returns to its original value. All cells above these last two cells have been
emptied.

Expected Results:
Selecting column of numbers then clicking sum button should sum the numbers and
enter result in last selected cell.

Summing cells should work way it works in Calc.


Reproducible: Always


User Profile Reset: Yes



Additional Info:
see attachment for bug demo

-- 
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/20201209/918915f1/attachment.htm>