Ask Your Question
0

Sort Calc Data on Multiple columns each with custom order?

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 close merge delete

1 Answer

Sort by » oldest newest most voted
1

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
Login/Signup to Answer

Question Tools

1 follower

Stats

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

Seen: 647 times

Last updated: Nov 29 '16