Data > Sort: Enable 'Range contains column labels' by default [closed]

asked 2015-04-09 21:16:17 +0200

stvn66 gravatar image

I frequently sort lists of data in Calc and would like to set Range contains column labels as the default. My data ALWAYS has column labels and I do not like that every time I sort my data that I have to select the Options tab then find the toggle to designate my data has column labels.

It would make sense if a repeated sort on the same data/worksheet would remember the selection but this is not the case.

A compromise I have found is to highlight the data I want to sort without highlighting the labels, then sorting on column letter. This is not ideal as selecting part of a worksheet takes longer (much longer for large selections) than just selecting the entire sheet by clicking the empty box above the row 1 label. Additionally, it requires I know which column letter is associated with the data I want to sort.

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2020-08-20 00:09:56.014061


I feel your pain. I literally sort extremely large inventory lists (I do inventory in a warehouse) all day every day, and every.single.time. I have to change the "range contains column headers".

I agree with your comment, and think that at the very least it could retain your most recent choice on a per file or per sheet basis.

hoeck gravatar imagehoeck ( 2019-10-11 20:09:25 +0200 )edit

5 years later.... still an issue.

hoeck gravatar imagehoeck ( 2020-08-14 21:37:48 +0200 )edit

oh, it's a 5 year old documented bug:

default_abuser gravatar imagedefault_abuser ( 2020-12-22 21:56:40 +0200 )edit