[Libreoffice-bugs] [Bug 131186] New: Faulty behavior on Inserting rows in a table

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 131186
           Summary: Faulty behavior on Inserting rows in a table
           Product: LibreOffice
           Version: 6.4.0.3 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: JKluth at dokom.net

Description:
Dear folks ! 

For example in a small table there are TWO ways of inserting rows:

First : 
One can select a row (on left side the row numbers) and then one can INSERT a
(or more) Row by "right clicking the mouse" selecting "Insert Row above".

Second :
With (by) the mouse a part of the table can be market and selectet and then
this selection can be moved (for example) one row down with the same effect to
have a row inserted in the partition of the whole sheet

I have figured out, that both modificaton do NOT have the same Results
especially if some cells have a formula inside.

A simple example is attached with descripion in the file to produce.

kind regard




Steps to Reproduce:
1. create coloumn 1,2,3,4,5, sum of this 5 numbers below
2. create coloumn 6,7,8,9,10, sum of this 5 numbers below
3. select 2 to "sum" by mouse, move selection 1 row down
4. repeat 3 to "sum" 


Actual Results:
formula is wrong

Expected Results:
formula is correct


Reproducible: Always


User Profile Reset: No



Additional Info:
dont know

-- 
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/20200306/bd492271/attachment.htm>