Random sort

Discuss the spreadsheet application

Random sort

Postby Ruriko » Sun Sep 15, 2013 12:51 pm

Is it possible to random sort in a column? instead of doing alphabetically
Openoffice 3.2.1
Windows 7
Ruriko
 
Posts: 17
Joined: Sun Jun 19, 2011 6:41 am

Re: Random sort

Postby eremmel » Sun Sep 15, 2013 1:04 pm

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.
Please, edit this thread's initial post and add "[Solved]" to the subject line if your problem has been solved.
OOo 3.3.0 on XP SP3 for real life with ORB; AOO 3.4.1, 4.0.1, LO 4.1.2.3 on W7 for testing
User avatar
eremmel
Volunteer
 
Posts: 656
Joined: Tue Dec 30, 2008 1:15 am
Location: Barneveld, Netherlands

Re: Random sort

Postby Zizi64 » Sun Sep 15, 2013 1:05 pm

Tibor Kovacs, Hungary; AOO4.0.1, LO3.6.4, LO4.2.2 on WinXPprof.SP3
Zizi64
Volunteer
 
Posts: 1784
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: Random sort

Postby Zizi64 » Sun Sep 15, 2013 1:26 pm

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; AOO4.0.1, LO3.6.4, LO4.2.2 on WinXPprof.SP3
Zizi64
Volunteer
 
Posts: 1784
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: Random sort

Postby Villeroy » Sun Sep 15, 2013 1:47 pm

random_sort.ods
(13.75 KiB) Downloaded 17 times
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 12.04, Apache OpenOffice 4.x
User avatar
Villeroy
Volunteer
 
Posts: 17294
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany


Return to Calc

Who is online

Users browsing this forum: No registered users and 19 guests