<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_NEEDINFO " title="NEEDINFO - Sorting breaks rows data alignement when functions include columns with no data" href="https://bugs.documentfoundation.org/show_bug.cgi?id=107779#c5">Comment # 5</a> on <a class="bz_bug_link bz_status_NEEDINFO " title="NEEDINFO - Sorting breaks rows data alignement when functions include columns with no data" href="https://bugs.documentfoundation.org/show_bug.cgi?id=107779">bug 107779</a> from <a class="email" href="mailto:pp.luca@tiscali.it" title="Luca <pp.luca@tiscali.it>"> Luca</a> <pre>(In reply to Jean-Baptiste Faure from <a href="show_bug.cgi?id=107779#c4">comment #4</a>) > (In reply to Luca from <a href="show_bug.cgi?id=107779#c0">comment #0</a>) > > In Tools / Options / LibreOffice Calc / General > > select: > > > > [X] Update references when sorting range of cells. > > Why did you check this option ? > Please, have a look at <a class="bz_bug_link bz_status_RESOLVED bz_closed" title="RESOLVED FIXED - Sorting should automatically adjust references." href="show_bug.cgi?id=81309">bug 81309</a> and <a class="bz_bug_link bz_status_RESOLVED bz_closed" title="RESOLVED FIXED - Sorting shouldn't always automatically adjust references." href="show_bug.cgi?id=81633">bug 81633</a> to understand where this > option comes from. > <a class="bz_bug_link bz_status_RESOLVED bz_closed" title="RESOLVED FIXED - Sorting should automatically adjust references." href="show_bug.cgi?id=81309">bug 81309</a>: Sorting should automatically adjust references > <a class="bz_bug_link bz_status_RESOLVED bz_closed" title="RESOLVED FIXED - Sorting shouldn't always automatically adjust references." href="show_bug.cgi?id=81633">bug 81633</a>: Sorting shouldn't always automatically adjust references > > Set status to NEEDINFO, please set it back to UNCONFIRMED once requested > informations are provided. (Sorry for my delayed reply) The option [X] Update references when sorting range of cells is necessary when you have two sheets in the same file with cells in a column of the first sheet pointing to corresponding cells in a column of the second sheet, because without that option, resorting one sheet would result in loosing data rows integrity: Sheet 1: Sheet 2: A B A B =$'Sheet 2'.A1 1a a 2a =$'Sheet 2'.A2 1b b 2b =$'Sheet 2'.A3 1c c 2c (values a, b, c, must appear in column As of Sheet 1 and Sheet 2, always connected to corresponding values in column Bs, no matter how you sort one sheet or the other) But I think you're missing the point. There are two issues here: 1) lacking of warnings, whenever a sorting operation would result in data loss by breaking the rows integrity; 2) arbitrary restriction of a specifically selected area to perform an operation that will result in data loss (this is the worst problem, see my previous messages for details). As for the issue in 1): when you select one column and then try a sorting operation, the program already issues a warning and proposes an extension of the selection. The case I described here are far more dangerous and less intuitive, all the more reason they should need a warning.</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>