[Libreoffice-bugs] [Bug 141745] New: Reordering columns alters sort settings

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 141745
           Summary: Reordering columns alters sort settings
           Product: LibreOffice
           Version: 7.1.0.0.alpha0+
          Hardware: All
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: nadie.nada.nunca at mail.com

Description:
If you have a spreadsheet that you frequently sort with headers in the first
row, your sorting criteria is preserved every time you invoke Data | Sort. But
if you reorder the columns by dragging them with the Alt key pressed, Calc will
ignore that fact and still use the columns by their order in the spreadsheet. 

Example: you have a spreadsheet with columns ID (A), Description (B), Date (C),
Cost (D), Manufacturer (E), and invoke Data | Sort to get them ordered first by
Date, then by Manufacturer, and then by Cost. Every time you invoke Data |
Sort, you'll have these columns preselected. 

But if you then reorder the columns, so that they become for example
Manufacturer (A), Date (B), Cost (C), ID (D), and Description (E), the next
time you invoke Data | Sort your preselected columns will be Cost, then
Description, then ID. 

This is kiiind of technically correct but it's in no way what the user expects,
so I consider it a bug.


Steps to Reproduce:
See description.

Actual Results:
See description.

Expected Results:
See description.


Reproducible: Always


User Profile Reset: No



Additional Info:
[Information automatically included from LibreOffice]
Locale: en-US
Module: SpreadsheetDocument
[Information guessed from browser]
OS: Windows (All)
OS is 64bit: no

-- 
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/20210418/421da6eb/attachment.htm>