Bug ID: 111428
Summary: AutoCalculate stops working when column is inserted
Version: 184.108.40.206 release
Hardware: x86-64 (AMD64)
AutoCalculate stops working when a new column is inserted in a LibreOffice
220.127.116.11 x64 (Windows 10)! To re-enable AutoCalculate, one must close and reopen
To confirm that it is a bug, this issue was discussed at
and it has been confirmed to occur in version: 18.104.22.168, 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
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 22.214.171.124 (Build ID: 1:5.3.1-0ubuntu2) system.
As described above, it was confirmed that AutoCalculate stops working when a
new column is inserted, until the spreadsheet is closed and reopened.
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.
User Profile Reset: No
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.
Libreoffice-bugs mailing list