<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>Bug ID</th>
<td><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - AutoCalculate stops working when column is inserted"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=111428">111428</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>AutoCalculate stops working when column is inserted
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>5.4.0.3 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>x86-64 (AMD64)
</td>
</tr>
<tr>
<th>OS</th>
<td>All
</td>
</tr>
<tr>
<th>Status</th>
<td>UNCONFIRMED
</td>
</tr>
<tr>
<th>Severity</th>
<td>normal
</td>
</tr>
<tr>
<th>Priority</th>
<td>medium
</td>
</tr>
<tr>
<th>Component</th>
<td>Calc
</td>
</tr>
<tr>
<th>Assignee</th>
<td>libreoffice-bugs@lists.freedesktop.org
</td>
</tr>
<tr>
<th>Reporter</th>
<td>paravantis@gmail.com
</td>
</tr></table>
<p>
<div>
<pre>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
<a href="https://ask.libreoffice.org/en/question/120044/autocalculate-stops-working-when-column-is-inserted/">https://ask.libreoffice.org/en/question/120044/autocalculate-stops-working-when-column-is-inserted/</a>
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</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>