When sorting in calc, one must click the option “Range contains column headers” to treat the first row as, well, a header and not as part of the data.
Every time I do this, I wonder “can I set this option permanently?” I can’t recall the l last time I didn’t want this option. So, after years of this, I’m finally taking the time to ask. Can I permanently make this my default instead of having to click it each time?
Edit for clarity: I’m talking about a global, persistent, universal setting for this option. Not for a file or this file, but for all files I ever open. That box should default to being checked anywhere and always after I apply whatever magic you propose.