[Libreoffice-bugs] [Bug 111428] New: AutoCalculate stops working when column is inserted

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 111428
           Summary: AutoCalculate stops working when column is inserted
           Product: LibreOffice
           Version: 5.4.0.3 release
          Hardware: x86-64 (AMD64)
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: paravantis at gmail.com

Description:
AutoCalculate stops working when a new column is inserted in a LibreOffice
5.3.0.2 x64 (Windows 10)! To re-enable AutoCalculate, one must close and reopen
the document.

To confirm that it is a bug, this issue was discussed at

https://ask.libreoffice.org/en/question/120044/autocalculate-stops-working-when-column-is-inserted/

and it has been confirmed to occur in version: 5.3.1.2, Build ID:
1:5.3.1-0ubuntu2 as well.

Steps to Reproduce:
1. Start a new spreadsheet and confirm that AutoCalculate is enabled.
2. Type in a number in cell A1.
3. Type in another number in Cell B1.
4. In cell C1 insert the formula `=A1+B1`.
5. Confirm that the sum in C1 works correctly; try changing the values in A1
and B1 to verify that is recalculates correctly.
6. Now select column C and insert an empty column to its left, i.e. between B
and C.
7. Edit the sum formula (which is now located) in cell D1 to `=A1+B1+C1`.
8. Now type in a number in cell C1.
9. Confirm that the sum in cell D1 is not updated correctly, despite the fact
that AutoCalculate is enabled. Hard recalculation works.
10. Close and reopen the spreadsheet.
11. Finally, confirm that recalculate works correctly at all times, now that
the spreadsheet was reopened.

The bug has been confirmed by other users, the same behavior was observed for
`=$A$1+$B$1+$C$1` on a version 5.3.1.2 (Build ID: 1:5.3.1-0ubuntu2) system.

Actual Results:  
As described above, it was confirmed that AutoCalculate stops working when a
new column is inserted, until the spreadsheet is closed and reopened.

Expected Results:
When AutoCalculate is enabled, (1) automatic recalculation should occur
continuously; also, (2) there should be no difference in behavior before and
after closing and reopening a spreadsheet.


Reproducible: Always

User Profile Reset: No

Additional Info:


User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36
(KHTML, like Gecko) Chrome/60.0.3112.90 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/20170807/1fe80cae/attachment.html>