<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><span class="vcard"><a class="email" href="mailto:albrecht.mueller@astrail.de" title="Albrecht Müller <albrecht.mueller@astrail.de>"> <span class="fn">Albrecht Müller</span></a>
</span> changed
<a class="bz_bug_link
bz_status_REOPENED "
title="REOPENED - Name Scope Handling is Incorrect"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=81295">bug 81295</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>RESOLVED
</td>
<td>REOPENED
</td>
</tr>
<tr>
<td style="text-align:right;">Resolution</td>
<td>NOTABUG
</td>
<td>---
</td>
</tr>
<tr>
<td style="text-align:right;">Ever confirmed</td>
<td>
</td>
<td>1
</td>
</tr></table>
<p>
<div>
<b><a class="bz_bug_link
bz_status_REOPENED "
title="REOPENED - Name Scope Handling is Incorrect"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=81295#c5">Comment # 5</a>
on <a class="bz_bug_link
bz_status_REOPENED "
title="REOPENED - Name Scope Handling is Incorrect"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=81295">bug 81295</a>
from <span class="vcard"><a class="email" href="mailto:albrecht.mueller@astrail.de" title="Albrecht Müller <albrecht.mueller@astrail.de>"> <span class="fn">Albrecht Müller</span></a>
</span></b>
<pre>So the problem is still there and I am not the only one who fell into this
trap.
I think an important part of this problem is that by checking Tools > Options >
LO Calc > Calculate, "Automatically find column and row labels" you allow
LibreOffice to silently apply persistent changes to the semantics of your
formulas.
This behaviour comes quite unexpected as searching usually is thought to be
non-destructive. Therefore from a users point of view this behaviour may cause
many sorts of trouble as correct formulas are lost and spreadsheets will
deliver wrong results.
When you turn on this option you get no warning that alerts you to this
problem. The help information contains no hint either. I don't know the default
value of this option but I think this feature should be off by default and
should issue a warning if you turn it on.
Maybe changing the implementation of this option such that is actually does a
"find" only and not an unexpected "find & replace" would be a better solution.</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>