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 7.3.2.2 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.
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
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.