[Libreoffice-bugs] [Bug 117061] New: Editing : Formulas broken when dragging a row in a spreadsheet containing a scenario

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 117061
           Summary: Editing : Formulas broken when dragging a row in a
                    spreadsheet containing a scenario
           Product: LibreOffice
           Version: 5.4.6.2 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: philippe at hemmel.fr

Created attachment 141420
  --> https://bugs.documentfoundation.org/attachment.cgi?id=141420&action=edit
sample speadsheet with scenarios : problem

## Steps to reproduce

Create a spreadsheet with two sheets : 
In the first sheet insert some values, sum and two scenarios
In the second sheet insert some values and sums : 

See the attached file "test drag with scenario.ods"

Check the formula in sheet2.B4 : =SUM(B9:B13)
Check the formula in sheet1.B4 : =SUM(B5:B6)
and sheet1.B7 : =SUM(B8:B9)

In the second sheet, drag the row 5 between 6 and 7, with alt and ctrl pressed,
in order to copy and insert the 4 row between the formula in sheet2.B4 and the
cells used in that formula.

## Actual behaviour

The row 5 isn't inserted between the rows 6 and 7 but replace the row 7.

Check the formula in sheet2.B4 : =SUM(B10:B14). It isn't correct anymore : the
references have changed but the cells haven't been shifted because no line has
been inserted.

Check the formula in sheet1.B4 : =SUM(B5:B6). Ok
Sheet1.B7 : =SUM(B9:B10). Incorrect : the references have changed but no cells
have been shifted in this sheet.

## Expected behaviour

The row 5 should have been inserted between the rows 6 and 7.
The cells used in the formula in sheet2.B4 should have been shifted (that's ok)
The formula in sheet1.B7 should not have changed.

Check the "test drag without scenario.ods" file: it's the same file without
scenario. Apply the same changes on that file: the results are corrects.

## Desktop configuration

**Operating system:** Linux 4.13 (Kubuntu 17.10 Artful 64 bits)

Plasma 5.12.3 (kubuntu-ppa/backports)

**LibreOffice version:** 

Version: 5.4.6.2
Build ID: 1:5.4.6-0ubuntu0.17.10.1
CPU threads: 4; OS: Linux 4.13; UI render: default; VCL: kde4; 
Locale: fr-FR (fr_FR.UTF-8); Calc: single

-- 
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/20180417/adc0c175/attachment.html>