<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_UNCONFIRMED " title="UNCONFIRMED - Sorting breaks rows data alignement when functions include columns with no data" href="https://bugs.documentfoundation.org/show_bug.cgi?id=107779#c9">Comment # 9</a> on <a class="bz_bug_link bz_status_UNCONFIRMED " title="UNCONFIRMED - 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 Luca from <a href="show_bug.cgi?id=107779#c8">comment #8</a>) > 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. I would add: even the more confusing all this is, if you consider that when manually resorting rows (alt+drag) the reference in C3 gets updated, but if you use the sorting function instead to obtain the same result, it does not. If all this is intentionally by design, well, it's very bad design, in my opinion. Counterintuitive and dangerous. For sure it would require extensive and exhaustive description of all possible cases, in the help file.</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>