AutoCalculate stops working when column is inserted

[paravantis]

It appears that 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.

I ask that you kindly try to reproduce these steps in your installation, to confirm that it is a bug:

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.

Frankly, I am amazed, and look forward to your feedback, before I report this as a bug.

[mariosv]

Please report the bug.

[librebel]

Confirmed, same for =$A$1+$B$1+$C$1
( Version: 5.3.1.2 Build ID: 1:5.3.1-0ubuntu2 )

[newbie-02]

not occuring in LO 4.0.4.2_win_x86 (win7 pro SP1), in step 9 cell D1 is updated correctly,
from own experiments and other posts i suspect something is broken in autocalculate since ver. 4.2 - and that’s quite a long time for ignoring a fault -
i know the bug is marked fixed, from other similar problems which still occur i suspect a ‘design problem’ in triggering the autocalculation

• looks like gone in 6.2.0.3 (x64)

[newbie-02]

the bug is not finally fixed, a little more complexity and it fails again, not on all systems?!?!, i’d like users to test and give feedback:

Start a new spreadsheet and confirm that AutoCalculate is enabled.
Type a number in cell A1, e.g. '2'
Type a number in cell B1, e.g. '3'
In cell C1 insert the formula =SUM(A1:B1)
Confirm that the sum in C1 works correctly; try changing the values in A1 and B1 to verify that it recalculates correctly.
Now select A1:C1 and copy, 

paste that in the range A2:C10,
select column B and insert an empty column to its left, i.e. between A and then C.
select cells B3:B8 and delete them with ‘shift left’ to fill the gap,
select column D and insert an empty column to its left, i.e. between C and then E.
Now delete the number from C2,
watch cell E2 not! being updated,
Hard recalculation works, but shouldn’t be neccessary with autocalc on,
on feedback pls. include the info from ‘help - about libre office’

[paravantis]

Thank you fellow LibreOffice users, the bug has been reported:

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