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: 25
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.1.1/, LO 4.2.8.2 on W7E SP1 for testing
User avatar
eremmel
Volunteer
 
Posts: 728
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.1.1, LO4.2.8; LO4.3.6 and latest Portable versions on Win7x64Prof, WinXPprof.SP3x86
User avatar
Zizi64
Volunteer
 
Posts: 2263
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.1.1, LO4.2.8; LO4.3.6 and latest Portable versions on Win7x64Prof, WinXPprof.SP3x86
User avatar
Zizi64
Volunteer
 
Posts: 2263
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 24 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: 19228
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany


Return to Calc

Who is online

Users browsing this forum: No registered users and 20 guests