<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#c8">Comment # 8</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 Buovjaga from <a href="show_bug.cgi?id=107779#c6">comment #6</a>) > Luca: would <a class="bz_bug_link bz_status_NEW " title="NEW - FILEOPEN FILESAVE: Add UpdateReferenceOnSort as a property of a sort range" href="show_bug.cgi?id=96464">bug 96464</a> solve it for your use case? I guess not, if I understand how it works. What is needed is: 1) an option to never ever brake the integrity of a line without a warning 2) if the user selects a range of lines/rows/cells, then applies any sorting operation, the sorting must affect completely and exclusively the selected area, no exceptions. 3) In the help file, a clear, complete and exhaustive documentation of Calc behaviours in every case. I have yet another simple case where I would need the option [X] Update references when sorting range of cells A B C 1 value1 value3 2 value2 value4 3 =B2 (value4) If I modify sorting of rows 1 and 2 according to the column B values, I want the C3 reference updated so that it always points to value4, no matter if it's in B1 or B2. But I can't use the options because it's too dangerous. Without 1) and 2) as I described here above, it's very likely that you will end up with loosing your datasheet completely without even knowing, because of the messed up lines.</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>