[Libreoffice-bugs] [Bug 124643] New: Calc - skips existing sum cell if I create a new sum containing the existing cell(using mouse for selecting cells)

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 124643
           Summary: Calc - skips existing sum cell if I create a new sum
                    containing the existing cell(using mouse for selecting
                    cells)
           Product: LibreOffice
           Version: Inherited From OOo
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: ppetr74 at centrum.cz

Description:
Hello I'd like to report an issue I'm having
This is what's happening:
When I type numbers into two different cells, select those two + an empty one
and click "Sum", I get the sum from those two cells and the result is typed
into the third one. This is fine, the problem appears when I try to continue
this by typing another number into a cell below the result, select the result,
the new cell with a number and an empty cell. Now when I click "Sum" I just get
the number from the new cell.
An example to provide a better explanation:
Type 2 in cell A1
Type 2 in cell A2
Select A1, A2 and A3 (A3 is empty, that's where I want my result)
Click on "Sum"
This works fine, I get 4 in cell A3 "=Sum(A1:A2)"
But when I continue:
Type 2 in cell A4
Select A3 to A5
Click "Sum"
And now the number I get in A5 is 2 instead of 6 as it should be "=Sum(A4:A4)"
instead of "=Sum(A3:A4)"
I've observed this issue for some time now throughout all versions. It works as
expected in Excel, but unfortunately doesn't in Libreoffice.
Any help would be appreciated.

Steps to Reproduce:
Refer to description

Actual Results:
Refer to description

Expected Results:
New sum including existing sum


Reproducible: Always


User Profile Reset: Yes



Additional Info:

-- 
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/20190410/30b9862d/attachment.html>