Request for Sort Dialog change

[waltp]

In the Sort Key dropdown, can the word “Column” be removed? When I need to sort my file on columns (B,C,D) and my cursor is in column AK (it needs to be there to start my selection) I can’t simply change the column to B, I need to scroll all the way to the top of the dropdown. And since I sort a lot and CALC is flaky on remembering my sort parameters, I need to scroll a lot.

It would also make setting up different sorts on multiple columns easier by hitting the letter of the column rather than having to scroll constantly.

Thanks,
Walt

[Wanderer]

@waltp

CALC is flaky on remembering my sort parameters

I wouldn’t say so. If I set my sort parameters, sort, then save my setup is kept. I also have some templates prepared for sorting: Fill with test-data, sort, remove data, save empty file in my projects folder, wich I copy for new projects. Same sort-setup is available, when I fill the file again.
(Win 10 pro, several versions of LO 6 and 7)

[waltp]

@Wanderer

@waltp

CALC is flaky on remembering my sort parameters

I wouldn’t say so. If I set my sort parameters, sort, then save my setup is kept.

Hmmm. Then what am I seeing that I’m interpreting as sometimes saving and sometimes having to reload the sort parameters multiple times during a session? Because that’s IS what I’m seeing. What settings have you selected that I haven’t?

[mariosv]

Define a range in Menu/Data/Range, and after that the sort options while in the range. The options are saved with defined range.

https://help.libreoffice.org/latest/en-US/text/scalc/guide/database_define.html?&DbPAR=CALC&System=WIN

[Villeroy]

Sorting is broken beyond repair. Sorting spreadsheet rows by date column and not including headers keeps breaking
Base is the one and only component able to sort properly and remember sort orders.

[Wanderer]

No solution but a better place for your request:

Feature requests should go directly to
https://bugs.documentfoundation.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&bug_severity=enhancement

is cited from here:

This is the guide - How to use the Ask site?

Ask a question To do this, click on “+ New topic” in the top bar. [EN Button New Topic] The “Create a new topic” dialog appears. [EN Dialog Create a new Topic] In the “Type title, or paste a link here” line, enter as short a title as possible for the question. In any case, avoid entering the entire content of your question in the “Title” line. If you create your question in the “English” category, “English” will appear automatically. To the right of “Select at least 1 item”, you can sel…