Comment 64 for bug 1389858

I think adjust it's fine, but in my understanding, sometimes wrong, it must be in the same way like Copy/Paste, adjust relative references and retain absolute references, like it is supposed a spreadsheet works. It's an user matter use properly relative/absolute references.

Now with sample in https://bugs.freedesktop.org/show_bug.cgi?id=83276:

A9: =IF(C9<C8;RANK(C9;$C$2:$C$16;0);IF(C9>C8;"Re-sort";IF(AND(C9=C8;B9<B8);"Re-sort";"")))

changing C9 value to 500,
after Menu/Data/Sort - Column C descending / Options - Range contain column labels.
now in
A5: =IF(C5<C9;RANK(C5;$C$2:$C$16;0);IF(C5>C9;"Re-sort";IF(AND(C5=C9;B5<B9);"Re-sort";"")))

seems that references to the same row are updated properly (C5), but references to other rows change in a strange way for me (C8->C9), maybe they have several changes while sorting.

Forgive me, but I can't see why keep relative references changed in a different way than Copy/Paste, when a priori you don't know what data finish in what row.
I think most times comparisons/sums are with previous/next row, like in the sample, or to sum all the previous or all the rest rows/columns.