https://bugs.documentfoundation.org/show_bug.cgi?id=161763
--- Comment #12 from [email protected] --- I have checked two things 1) in the Help of Calc > Tools > General I found no mention to the 'Update references when sorting range of cells' (https://help.libreoffice.org/latest/en-US/text/shared/optionen/01060300.html?&DbPAR=SHARED&System=UNIX) 2) I created the same file in Google Sheets and the behavior is the same as the default one in Calc (ie, with 'Update references when sorting range of cells' disabled). In Google Sheets there is not even an option to change this behavior (good for Calc!). If we trust Google did a thoughtful design of their Google Sheets (i.e. the chances Google got it wrong is very low), then I have to accept that my expectations are wrong and/or I am simply misusing Calc and I have to avoid this kind of situations in the future. -- You are receiving this mail because: You are the assignee for the bug.
