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

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 107385
           Summary: Autofilter sorting breaks rows data alignment without
                    warning
           Product: LibreOffice
           Version: 5.3.2.2 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: pp.luca at tiscali.it

Description:
Autofilter sorting doesn't affect non autofiltered columns, there is no
warning, the result is a complete mess up of a spreadsheet.


Big, big mess.

Solution: for the Autofiler function, just copy MS Excel behaviour in every
aspect. It's perfect.

Steps to Reproduce:
1) Fill in three columns with sortable data
2) Setup three column labels (let's say A, B, C)
3) Select only A and B column labels (leave the C column out of the selection)
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. 

Then: 
7) Select a cell in the C column
8) Select Data/Sort...

Autofilter labels on A and B columns get lost.

Expected Results:
Just copy MS Excel behaviour. It's perfect. 
- Raws alignment should never be broken without warning
- Autofilter labels should never disappear after a sorting operation 
- Sorting should always affect either the whole spreadsheet, or the selected
columns/group of cells.


Reproducible: Always

User Profile Reset: No

Additional Info:


User-Agent: Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:52.0) Gecko/20100101
Firefox/52.0

-- 
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/20170424/569a4e19/attachment-0001.html>