[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 #14 from Luca <pp.luca at tiscali.it> ---
(In reply to b. from comment #13)
> (In reply to Luca from comment #12 and OP)

> ??? imho calc wont harm a backup from before your daily work in the evening,

Then you just lost your daily work, the moment you saved the mess and closed
the file. Please, drop it, this is not the place to learn how to do backups. If
you want to keep on arguing about this you'd better write to me in private.

> > 4) Select Data/Autofilter, to setup autofilter labels on A and B, but not C.
> > 5) Click on the A lable
> > 6) Select Sort/Descending (or Ascending, depending on how you sorted data in 
> > the first place)
> 
> > Actual Results:  
> > Only the A and B column get sorted, while the C column sticks to the original > sorting. Raws data 
> > alignment is broken. Big mess. 
> 
> what do you expect calc to do after you explicitly! told it to work on
> columns A and B ??? 

No I didn't. The autofilter column menu item that I selected doesn't say "Sort
all and only autofiltered column ascending/descending". It reads "Sort
ascending/descending". Full stop. The expected behaviour is the standard
applied to any other command with the same "Sort ascending/descending"
indication: apply sort to what I selected, and issue a warning when "The cells
next to the current selection also contain data".

>From the help file:
| The AutoFilter function inserts a combo box on one or more data columns that 
| lets you select the records (rows) to be displayed.

It says "select RECORDS". What Calc programmers fail to understand is that the
integrity of the record is sacred. The program should NEVER brake the integrity
of a record, unless the user EXPLICITLY told it to do that. They ignore this
rule and they cause users' data loss. This is not the only case, also see bug
107779.

-- 
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/20200609/30aebe2c/attachment.htm>