[Libreoffice-bugs] [Bug 107385] Autofilter sorting breaks rows data alignment without warning

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #9 from kokbira <kokbira at gmail.com> ---
Well, it happened to me...

I was searching for issues on data stored from an inventory software, OCS. So I
extracted a CSV from all columns of about 1200 inventoried computers, applied
autofilters, sort from HOST NAME column and did a lot of operations.

After some great 8h headache searching for the cause of some errors on a sheet,
I found that LibreOffice Calc make wrong on sorting columns, because IP and
GATEWAY columns did not show right values.

I thought to change LibreOffice suite for another one because that issue
happened with all LO Calc versions I tested.

So, searching on www, I found that bug report that fixed my problem - I forget
to add autofilters to two columns.

Thanks a lot :)

About sorting columns, without the use of autofilters, I knew from LO Calc or
Microsoft Excel that it will sort all columns selected or, if none is selected,
all columns near that are not separated by an empty column.

So I thought LO Calc followed that behavior on autofilters, and it was my
error. I rarely use autofilters on MS Excel to compare, so I do not know if LO
Calc is "cloning" its behavior...

Then I agree to warn user about that behavior or to change that behavior to
something more intuitive (like a label "sort only filtered columns", or a popup
warning that the operation will sort only filtered colums, or an popup with two
options - to sort all columns or only those filtered etc.).

-- 
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/20200117/030c64ca/attachment-0001.htm>