Ask Your Question

Sort Calc Data on Multiple columns each with custom order? [closed]

asked 2016-11-29 10:17:41 +0100

evileyeball gravatar image

Hey all, I have a calc file where I have implimented several custom sort orders What I want to do is

Sort by Column C with Custom Order A (Column is Text) Then by Column F with Non Custom Order (Column is Numbers) Then by Column E with Custom Order B (Column is Text)

From google it looks like Excel can achieve this because Excel allows you to select custom order for each column you sort by. Libre office Doesn't seem to support this

Hence My question is Is there any way to achieve this?

edit retag flag offensive reopen merge delete

Closed for the following reason not a real question by Alex Kemp
close date 2020-09-16 00:23:54.487605

1 Answer

Sort by » oldest newest most voted

answered 2016-11-29 13:20:43 +0100

erAck gravatar image

True, individual custom sort orders can not be specified, one custom sort order can be used on several columns though and is ignored if the column's data doesn't match the custom sort, i.e. numbers are sorted numerically.

So, if the data of two columns does not belong to the same set then a custom sort order can be specified that includes both sets of items to be sorted.

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2016-11-29 10:17:41 +0100

Seen: 961 times

Last updated: Nov 29 '16