<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 - EDITING: Formula should be extended to a newly inserted row/column"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=113896">113896</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>EDITING: Formula should be extended to a newly inserted row/column
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>6.0.0.0.alpha1+ Master
</td>
</tr>
<tr>
<th>Hardware</th>
<td>All
</td>
</tr>
<tr>
<th>OS</th>
<td>All
</td>
</tr>
<tr>
<th>Status</th>
<td>UNCONFIRMED
</td>
</tr>
<tr>
<th>Severity</th>
<td>enhancement
</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>thomas.lendo@gmail.com
</td>
</tr></table>
<p>
<div>
<pre>Formulas should be automatically extended to newly inserted rows/columns at the
beginning or end (for example if the cell where the action is done is within
the formula cell range).
STR/example with SUM:
1. A1: cell content "1"
2. A2: cell content "2"
3. A3: cell content "3"
4. A4: cell content "=SUM(A1:A3)"
5. Right-click on row header of row 3.
6. Select "Insert Rows Below".
Current result:
Cell content of A5 (formerly A4) still is "=SUM(A1:A3)".
Expected result:
Cell content of A5 should be "=SUM(A1:A4)".
The automatic adjustment of the SUM formula would prevent the user to do it by
himself/herself. I assume that the user want to have A4 added to SUM.
It's questionable under which circumstances the formula should be adjusted
automatically:
* If the cell where the action is done is within the formula cell range. This
would extend the formula to newly created A1 if the user clicks "Insert Row
Above" in row 1 and this would behave also as described in the example above.
* If the cell which is inserted is between SUM cell and its summed cells (in
the example above: A1-A3). This would extend the formula to A4 if the user
clicks "Insert Rows Above" in row 4. Would this also extend the formula to
newly created A1 if the user clicks "Insert Row Above" in row 1?
And is this technically distinguishable?</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>