[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 #8 from Luca <pp.luca at tiscali.it> ---
(In reply to Buovjaga from comment #6)
> Luca: would bug 96464 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.

-- 
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/20190102/b640f797/attachment.html>