<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <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#c9">Comment # 9</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 <a class="email" href="mailto:that.man.colin@gmail.com" title="Colin <that.man.colin@gmail.com>"> Colin</a> <pre>As I mentioned, attempting to truncate the range resulted in even more catastrophic erroneous cell references so what I provided is what best demonstrates the feature - WYSIWYG 1. Set autofilter Column C to "All" - this obviates one of the the existing autofilter bugs on newly opened sheets. 2. Ensure autofilter column B is set to "Sort Ascending" 3. Observe the value in M434 - This is the anticipated "Correct Value" 4. Observe the range references in M434 they are current, 1 following & 3 preceding rows - the preceding rows array grows according to the current location of the focus cell in the daily "cluster" 5. Set Auto Filter on column B - "Sort Descending" NOTE: M56 is the new location of the focus cell in the current daily cluster 6. Observe the range references in M56 - they are NOT the current focus array references, they are "out" by 378 rows 7. Observe the value in M56 - this is incorrect</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>