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