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: [email protected]
Reporter: [email protected]
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._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
