Bug 148378 - Allow user to set Data > Sort, Options: "Range contains column labels" as a persistent variable
Summary: Allow user to set Data > Sort, Options: "Range contains column labels" as a p...
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: All All
: medium normal
Assignee: Not Assigned
Depends on:
Reported: 2022-04-04 20:32 UTC by jw.hendy
Modified: 2022-04-05 13:05 UTC (History)
0 users

See Also:
Crash report or crash signature:


Note You need to log in before you can comment on or make changes to this bug.
Description jw.hendy 2022-04-04 20:32:24 UTC
This is a possible repeat/re-creation of #94668 which was closed as "worksforme."

tl;dr: allow me to set Data > Sort, Options: "Range contains column labels" globally instead of per session/per file. I always want it to default as checked.

I'm on and for years have always had to go into the Options tab to select "Range contains column labels" whenever I sort. I can't recall the last (or any?) time I *didn't* want this.

Could this be made a globally persistent options so that users who [almost] always work with data containing a header row don't have to do this one additional step (or more accurately, forget, sort, wonder where their header is, ctrl+z, sort, this time click options and check box, apply)?

Related to #131155, which wants to move the option from Options to in the main sort pane... This would save a click, but I'd just prefer to toggle this globally like e.g. auto-fill/auto-correct options.
Comment 1 Eike Rathke 2022-04-04 22:07:21 UTC
This happens when using Ctrl+A to select *all* before the Sort. Don't.
See https://ask.libreoffice.org/t/set-persistent-option-to-include-column-headers-when-using-data-sort/76087/11
Comment 2 jw.hendy 2022-04-05 13:05:27 UTC
Wow, of all the possible "solutions." Thanks for the post as well. I vaguely recall having a partial sort occur at one point and using ctrl+a forever more to compensate.

Crazy that I have been doing this for *years* without knowing it affects the sort settings, but also incredible to have such an easy "fix." Many thanks.