[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 #5 from Luca <pp.luca at tiscali.it> ---
(In reply to Jean-Baptiste Faure from comment #4)
> (In reply to Luca from comment #0)
> > 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 bug 81309 and bug 81633 to understand where this
> option comes from.
> bug 81309: Sorting should automatically adjust references
> bug 81633: 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.

-- 
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/20171226/3c201841/attachment.html>