Ask Your Question

Change default sorting settings [closed]

asked 2013-08-07 18:33:09 +0100

SystemShock gravatar image

I'd like to make a sorting option named "Range contains column labels" disabled by default. Having to disable this option each time I want to sort rows is annoying and counterproductive.

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2015-11-06 04:53:08.466889

1 Answer

Sort by » oldest newest most voted

answered 2013-08-07 20:53:34 +0100

m.a.riosv gravatar image

updated 2013-08-08 00:40:44 +0100

You can preserve the options defining first a range for data in Menu/Data/Define range and after selecting the range in Menu/Data/Select range, define the sort options in Menu/Data/Sort.


Please open the attached file created with LIbreOffice 4.0.4 in Win7x64.
The sort options are preserved for me.
Sample file, (please change the extension to ods, there is an error in type files to attach)
Have you followed the steps?:
1- Define data range in Menu/Data/Define range.
2- Select the range in Menu/Data/Select range.
3- Menu/Data/Sort to set up the options.
In this way it is possible to have several ranges in the same sheet with sort+filter definitions.

edit flag offensive delete link more


Unfortunately it doesn't work. I can save a range, then I can select it, but I still have to do Menu/Sort.../Options and uncheck "Range contains column labels" each time, because this option is still checked by default :/

SystemShock gravatar imageSystemShock ( 2013-08-07 23:15:16 +0100 )edit

I checked the sample file and surprisingly the unwanted option was unchecked. But then I did descending sort and all was lost :( So this method worked but it is too fragile to be useful. I use LibreOffice Version: on Win 8 64bit.

SystemShock gravatar imageSystemShock ( 2013-08-08 14:42:10 +0100 )edit

Question Tools

1 follower


Asked: 2013-08-07 18:33:09 +0100

Seen: 613 times

Last updated: Aug 08 '13