Random sort

Discuss the spreadsheet application
Post Reply
Ruriko
Posts: 27
Joined: Sun Jun 19, 2011 6:41 am

Random sort

Post by Ruriko »

Is it possible to random sort in a column? instead of doing alphabetically
Openoffice 3.2.1
Windows 7
eremmel
Posts: 1080
Joined: Tue Dec 30, 2008 1:15 am

Re: Random sort

Post by eremmel »

You can do that with the help of an extra column, see this post
Last edited by eremmel on Sun Sep 15, 2013 1:05 pm, edited 1 time in total.
It's Microsoft marketing that tells you computers are qualified for non-technicians
W11 22H2 (build 22621), LO 7.4.2.3(x64)
User avatar
Zizi64
Volunteer
Posts: 11352
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: Random sort

Post by Zizi64 »

Tibor Kovacs, Hungary; LO7.5.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
User avatar
Zizi64
Volunteer
Posts: 11352
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: Random sort

Post by Zizi64 »

or:
You can try the 'Mixer' extension:
http://extensions.libreoffice.org/exten ... r-for-calc
http://extensions.openoffice.org/en/pro ... r-calc-013

and finally:
It possible to write a StarBasic macro (similar to extension "mixer") for this task...
Tibor Kovacs, Hungary; LO7.5.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
User avatar
Villeroy
Volunteer
Posts: 31269
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Random sort

Post by Villeroy »

random_sort.ods
(13.75 KiB) Downloaded 275 times
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Post Reply