https://bugs.freedesktop.org/show_bug.cgi?id=81633
--- Comment #14 from [email protected] --- (In reply to comment #13) > 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. After sorting, the formula in A6 reads: =IF(C6<C4,RANK(C6,$C$2:$C$16,0),IF(C6>C4,"Re-sort",IF(AND(C6=C4,B6<B4),"Re-sort",""))) Similarly, A10 reads: =IF(C10<C5,RANK(C10,$C$2:$C$16,0),IF(C10>C5,"Re-sort",IF(AND(C10=C5,B10<B5),"Re-sort",""))) I agree that the references need updating properly - the current method updates some, but not all, relative references. As far as I can tell, I now have no method of knowing reliably when to sort my tables - unless I copy a correct formula to all the rows after sorting my tables (not practical). -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
