<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><span class="vcard"><a class="email" href="mailto:suokunlong@126.com" title="Kevin Suo <suokunlong@126.com>"> <span class="fn">Kevin Suo</span></a>
</span> changed
<a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED WORKSFORME - 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;">Status</td>
<td>UNCONFIRMED
</td>
<td>RESOLVED
</td>
</tr>
<tr>
<td style="text-align:right;">CC</td>
<td>
</td>
<td>suokunlong@126.com
</td>
</tr>
<tr>
<td style="text-align:right;">Resolution</td>
<td>---
</td>
<td>WORKSFORME
</td>
</tr></table>
<p>
<div>
<b><a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED WORKSFORME - EDITING: Formula should be extended to a newly inserted row/column"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=113896#c3">Comment # 3</a>
on <a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED WORKSFORME - 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:suokunlong@126.com" title="Kevin Suo <suokunlong@126.com>"> <span class="fn">Kevin Suo</span></a>
</span></b>
<pre>There is an option in:
Tools - Options - LibreOffice Calc - General - Expand reference when new
columns/rows are inserted.
Check is option and then try the steps in your original bug report, it works
perfect.
That option is not checked by default, because when it is checked, the formula
may change (expand) if new columns/rows are inserted, thus it's dangerous at
some point - only enable this option when you know what you are doing.
Close as WORKSFORME.</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>