Ask Your Question

Change default sort options in Calc? [closed]

asked 2013-03-18 16:52:51 +0200

Skinnerbird gravatar image

Is there any way to change the default sort options? I almost always need to sort with column labels, but the default is not "Range contains column labels"

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2015-10-27 12:31:18.756295

4 Answers

Sort by » oldest newest most voted

answered 2013-03-22 19:03:06 +0200

razon_22 gravatar image

@Skinnerbird - What version of LibreOffice are you using? I tested with 4.0.1 and once Range contains column labels is checked it's persistent, even after LibreOffice is closed and reopened.

edit flag offensive delete link more


I'm on Version: Build ID: 430m0(Build:2)

"Range contains column labels" checked is not persistent for me. I also tried finding the option in the profile, without success.

alavarre gravatar imagealavarre ( 2014-11-18 15:10:51 +0200 )edit

Adding a range definition (e.g., All for the entire sheet) works, but then the definition is persistent across all sheets, so trying to sort another sheet fails again. There needs to be a way to change the default action to Range contains column labels

alavarre gravatar imagealavarre ( 2014-11-18 15:18:46 +0200 )edit

answered 2013-03-19 11:27:24 +0200

qubit gravatar image

Hi @Skinnerbird,

Good question. I looked for an enhancement request in the bug tracker, but I didn't see anything at first glance.

Do the default sort options persist in a given document? If so, maybe a template could be helpful for you.

edit flag offensive delete link more

answered 2015-09-16 16:42:30 +0200

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

How is this a solution? The solution has more steps than the problem was trying to avoid?

edit flag offensive delete link more

answered 2013-03-22 23:04:59 +0200

m.a.riosv gravatar image

To save the sort options, there is needed to define the range in Menu/Data/Define. After selecting on Menu/Data/Selecting or selecting a cell in the range, retrieve the sort options defined for that range.

edit flag offensive delete link more

Question Tools


Asked: 2013-03-18 16:52:51 +0200

Seen: 765 times

Last updated: Mar 22 '13