<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body>
<p>
<div>
<b><a class="bz_bug_link
bz_status_NEW "
title="NEW - delete referenced cell - raise error"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=92419#c15">Comment # 15</a>
on <a class="bz_bug_link
bz_status_NEW "
title="NEW - delete referenced cell - raise error"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=92419">bug 92419</a>
from <span class="vcard"><a class="email" href="mailto:erack@redhat.com" title="Eike Rathke <erack@redhat.com>"> <span class="fn">Eike Rathke</span></a>
</span></b>
<pre>As this is not set to resolved fix it is not implemented, no.
First, we certainly do not want to scan the entire document (or broadcast and
collect a new before-deletion hint) whether a formula expression references a
to be deleted cell or not for each cell/column/row to be deleted. Second, an
expression could also reference a cell/range not only in cell formulas but also
in named expressions, validation, conditional formatting, ... We could
significantly slow things down with such an approach, so anything like that
should be optional not activated by default, which then again doesn't help an
inexperienced user either. Plus, implementation would be cumbersome.
In short, I'm not a friend of this.</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>