Created attachment 138767 [details] Calc file with sheet with bug in sort I use Calc with the Function if() and cell adresses in the function Sometimes, I change a date in the first column. After, when I make a sort on the first column (date) ; cell adresses do not change. You can verify it in the file attachment. This fact arrives since more 1 mounth with the precedent version and the last version. ---- Version: 5.3.7.2 (x64) Build ID: 6b8ed514a9f8b44d37a1b96673cbbdd077e24059 Threads CPU : 4; Version de l'OS :Windows 6.19; UI Render : par défaut; Moteur de mise en page : nouveau; Locale : fr-FR (fr_FR); Calc: group ----
It's unclear what are the specific steps to see the problem (like "change A15 to "this"; select A3:X100; Data->Sort..., Sork key 1 = Column A ascending; OK"), as well as what problem looks like (e.g., "After those steps, formula in cell XN contains formula "....", while I expect ...") Actually, I strongly suspect simple misunderstanding the basics of relative addressing (see https://help.libreoffice.org/Calc/Addresses_and_References,_Absolute_and_Relative).
Or maybe in relation with the option: Menu/Tools/Options/LibreOffice calc/General - Update references when sorting range of cells.
From the private email exchange, it became clear that m.a.riosv is absolutely correct. Closing NOTABUG (though the option's documentation needs love indeed :))