Sunday, February 10, 2013

Random (word) lists in LibreOffice 4

The screenshots below show how to create random (word) lists in LibreOffice 4:


Copy the list of words.




In LibreOffice Calc, select Paste Drop-Down Arrow
-> Unformatted text
-> Select B1
-> Type =rand()
-> Drag the handle to copy and paste the formula


Select B1
-> drag the handle (for generating random numbers again if you do not like the order)


Select the cells containing the words and random numbers
-> Data -> Sort...
-> Sort Criteria
-> Sort key 1
-> Column B
-> OK




Select the list of words.
-> Copy

In LibreOffice Writer, select Paste Drop-Down Arrow
-> Unformatted text
-> Select the words
-> Numbering On/Off



The video is here:

http://youtu.be/O0LVAjwkqLw

No comments: