<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><span class="vcard"><a class="email" href="mailto:thomas.lendo@gmail.com" title="Thomas Lendo <thomas.lendo@gmail.com>"> <span class="fn">Thomas Lendo</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;">Blocks</td>
<td>
</td>
<td>108253, 113943
</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#c4">Comment # 4</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:thomas.lendo@gmail.com" title="Thomas Lendo <thomas.lendo@gmail.com>"> <span class="fn">Thomas Lendo</span></a>
</span></b>
<pre>(In reply to Kevin Suo from <a href="show_bug.cgi?id=113896#c3">comment #3</a>)
<span class="quote">> 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.</span >
Thank you very much, Kevin. That's what I requested. I should read the help
more carefully ...</pre>
</div>
</p>
<div id="referenced">
<hr style="border: 1px dashed #969696">
<b>Referenced Bugs:</b>
<ul>
<li>
[<a class="bz_bug_link
bz_status_NEW "
title="NEW - [META] Calc cell formula bugs and enhancements"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=108253">Bug 108253</a>] [META] Calc cell formula bugs and enhancements
</li>
<li>
[<a class="bz_bug_link
bz_status_NEW "
title="NEW - [META] Options dialog's Calc settings bugs and enhancements"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=113943">Bug 113943</a>] [META] Options dialog's Calc settings bugs and enhancements
</li>
</ul>
</div>
<br>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>