[Libreoffice-bugs] [Bug 116145] New: Inserting columns using selected (grouped) sheets causes calculation error.

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 116145
           Summary: Inserting columns using selected (grouped) sheets
                    causes calculation error.
           Product: LibreOffice
           Version: 5.4.3.2 release
          Hardware: All
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: LibreOffice
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: julian.morris at sandhurst.zzn.com

Description:
Example when using a LibreOffice Calc spreadsheet containing 6 sheets. 
Sheets 2, 4, & 6 have data in columns C, E, G & I which are added together in
column K using =C2+E2+G2+I2
Then select (group) sheets 6, 4, & 2 (using Ctrl+ clicking on relevant sheet)
and use “Insert Column Left” before column E on sheet 6

The additional column is correctly added to sheets 6, 4 & 2 but the calculation
in column L (the original column K) on sheets 6 & 4 is incorrect e.g.
=D2+F2+H2+J2 – it should be =C2+F2+H2+J2
On sheet 2 the calculation is also incorrect e.g. =A2+F2+H2+J2 - it should be
=C2+F2+H2+J2

Then select “Undo”. 
Column K on sheets 6 & 4 shows the correct value but the calculation is
incorrect e.g. =D2+E2+G2+I2 - it should be =C2+E2+G2+I2
The calculation on sheet 2, column K is correct, e.g. =C2+E2+G2+I2 but extra
calculations have been incorrectly added to columns L & M

Saving and re-opening the file, recalculates sheets 6 & 4 column K and now also
shows the wrong value. Sheet 2 still has the calculations incorrectly added to
columns L & M

A similar problem occurs if using “Insert Column Right”.

The attached spreadsheet was used to highlight this error.


Steps to Reproduce:
1.See Description for steps to Reproduce
2.
3.

Actual Results:  
See Description

Expected Results:
See Description


Reproducible: Always


User Profile Reset: Yes



Additional Info:
[Information automatically included from LibreOffice]
Locale: en-GB
Module: StartModule
[Information guessed from browser]
OS: Windows (All)
OS is 64bit: no




User-Agent: Mozilla/5.0 (Windows NT 10.0) AppleWebKit/537.36 (KHTML, like
Gecko) Chrome/64.0.3282.167 Safari/537.36

-- 
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/20180302/e2778cf5/attachment.html>