<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#c6">Comment # 6</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>(In reply to m.a.riosv from <a href="show_bug.cgi?id=138896#c5">comment #5</a>) > What if you ask in ask.libreoffice.org before report a bug? Searched for potential duplicates four times, to no avail. Believed the parameter asking if I wanted to dynamically re-associate sorted cells with their new locations would actually re-associate sorted cells with their new locations. Mea Culpa > > Using references inside the sort range to the sorted range, it's usually > complex, and more complex with referencing ranges. Does that mean it works or it doesn't? The entire sheet can be sorted by any one of a number of data columns where there is both direct and nominally "clustered relative" referencing which works fine. I wasn't aware that the limitations were not considered bugs. Mea Culpa > > Maybe easy to test having a sample file with a minimum size of data to > reproduce the issue. If you understand the formula you will realise that all the intervening cells by definition must be empty because they're not the current cell. I attempted to add the function today to a pre-existing file with a simple two-dimensional array and discovered the error / feature / designed redundancy. In order to see the error, you could simply sort descending and look at the first two data lines to ascertain the references had gone about 400 cells out of range. You will note that my first report actually provided in full text the corrupted references so it should have been a simple enough procedure for an investigator to follow. the Final cell simply demonstrated what should have happened when it was inverted. Any way up the result should have been 0.6. I didn't think it was rocket science. Mea Culpa > > Remember here we are volunteers not professionals I was referring to the developers who whilst they are voluntarily providing software for all of us to appreciate are undoubtedly professional, accomplished programmers. I considered somebody like Mike Kaganski would probably just say "Oh yeah, we are aware of the bug(feature/limitation all you need to do is ------this", Mea Culpa If it makes you happier - relabel it as NOTABUG. It doesn't work for me so I stripped the function from my spreadsheet anyway. It was simply a forlorn attempt to apprise the foundation of a bewildering feature in the software, in order that they may address the issue in any way they deemed appropriate. Mea Culpa Sighhhhhhhhhh</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>