Thursday, February 14, 2013

Generate random (word) lists in LibreOffice 4 on Debian Linux



Screenshots: http://mindmapapp.blogspot.com/2013/02/random-word-lists-in-libreoffice-4.html

Captions:

0:00:00.490,0:00:03.430
>> LibreOffice How-To: Random (word) lists

0:00:05.490,0:00:09.430
>> Select the words -> Right-click -> Copy



0:00:10.490,0:00:15.430
>> File -> New -> Spreadsheet

0:00:16.490,0:00:19.430
>> Paste Drop-Down Arrow -> Unformatted text -> OK

0:00:23.490,0:00:37.430
>> B1 -> =rand()

0:00:37.490,0:00:38.430
>> Enter

0:00:39.490,0:00:41.430
>> Drag the handle to copy the formula

0:00:42.490,0:00:43.430
>> Select the cells

0:00:44.490,0:00:46.430
>> Data -> Sort...

0:00:46.490,0:00:51.430
>> Sort key 1 -> Column B -> OK

0:00:51.490,0:00:56.430
>> Select the words -> Copy

0:00:56.490,0:00:59.430
>> In LibreOffice Writer -> Paste Drop-Down Arrow

0:00:59.490,0:01:03.430
>> -> Paste Drop-Down Arrow -> Unformatted text

0:01:05.490,0:01:11.430
>> Select B1 -> Drag the handle to generate random numbers

0:01:11.490,0:01:15.430
>> Data -> Sort... -> Sort key 1 -> Column B

0:01:16.490,0:01:18.430
>> I do not like the order. -> Select B1

0:01:18.490,0:01:21.430
>> -> Select B1 -> Drag the handle

0:01:22.490,0:01:24.430
>> Select the cells -> Data

0:01:24.490,0:01:26.430
>> -> Data -> Sort... -> OK

0:01:26.490,0:01:29.430
>> Select the words -> Copy

0:01:30.490,0:01:32.430
>> In LibreOffice Writer -> Paste Drop-Down Arrow

0:01:32.490,0:01:35.430
>> -> Paste Drop-Down Arrow -> Unformatted text

0:01:35.490,0:01:48.430
>> Select the words -> Numbering On/Off

No comments:

RSS