[Libreoffice-bugs] [Bug 107779] Sorting breaks rows data alignement when functions include columns with no data

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=107779

--- Comment #9 from Luca <pp.luca at tiscali.it> ---
(In reply to Luca from comment #8)

> 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.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20190105/6fc45f1c/attachment.html>