<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><span class="vcard"><a class="email" href="mailto:todventtu@suomi24.fi" title="Buovjaga <todventtu@suomi24.fi>"> <span class="fn">Buovjaga</span></a>
</span> changed
<a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - EDITING: Formula should be extended to a newly inserted row/column"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=113896">bug 113896</a>
<br>
<table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>What</th>
<th>Removed</th>
<th>Added</th>
</tr>
<tr>
<td style="text-align:right;">CC</td>
<td>
</td>
<td>todventtu@suomi24.fi
</td>
</tr></table>
<p>
<div>
<b><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - EDITING: Formula should be extended to a newly inserted row/column"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=113896#c2">Comment # 2</a>
on <a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - EDITING: Formula should be extended to a newly inserted row/column"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=113896">bug 113896</a>
from <span class="vcard"><a class="email" href="mailto:todventtu@suomi24.fi" title="Buovjaga <todventtu@suomi24.fi>"> <span class="fn">Buovjaga</span></a>
</span></b>
<pre>Currently the formula is updated, if you move a cell referenced in it. In your
steps you do not move A3, so nothing happens.
The current behaviour would conflict with your proposed: "This would extend the
formula to newly created A1 if the user clicks "Insert Row Above" in row 1"
This sort of mind-reading is difficult and changed behaviour might cause users
to be upset.
A working solution for these simple "numbers + sum formula" things is to have
one blank row above the sum row and to include it in the sum range. Now when
you insert rows from the last row with numbers, the formula range is updated.</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>