<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><span class="vcard"><a class="email" href="mailto:mikekaganski@hotmail.com" title="Mike Kaganski <mikekaganski@hotmail.com>"> <span class="fn">Mike Kaganski</span></a>
</span> changed
<a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - AutoFilter sort reference not updated with nested IF statement"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=138896">bug 138896</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;">CC</td>
<td>
</td>
<td>erack@redhat.com
</td>
</tr></table>
<p>
<div>
<b><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - AutoFilter sort reference not updated with nested IF statement"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=138896#c10">Comment # 10</a>
on <a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - AutoFilter sort reference not updated with nested IF statement"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=138896">bug 138896</a>
from <span class="vcard"><a class="email" href="mailto:mikekaganski@hotmail.com" title="Mike Kaganski <mikekaganski@hotmail.com>"> <span class="fn">Mike Kaganski</span></a>
</span></b>
<pre>I think steps in <a href="show_bug.cgi?id=138896#c0">comment 0</a> are pretty clear.
And I repro the problem as described, using "Update references when sorting
range of cells" under Options|Calc|General.
With the mentioned setting disabled, I get a different resulting formula in
M56: it's
<span class="quote">> =IF(J56="";"";IF(J57="";SUM(J53:J56);""))</span >
and it is much saner.
I suppose that you should check if this setting solver this for you, or use
things like OFFSET in your formula. My opinion is that it works as designed,
taking into account the absolute impossibility to define "updating references
to ranges (which may change randomly) when sorting".</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>