OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

[SOLVED] How to reorder randomly words in multiple rows?

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> General Discussion
View previous topic :: View next topic  
Author Message
peter_yt
Newbie
Newbie


Joined: 23 Oct 2011
Posts: 3

PostPosted: Sun Oct 23, 2011 9:59 am    Post subject: [SOLVED] How to reorder randomly words in multiple rows? Reply with quote

I want to reorder/shuffle words randomly in multiple rows but it only shuffles the words in the first row. I am still new with open office so i need help how to do this for all rows. This is what i am doing: I select the rows and then i choose data>sort. Then in the options i choose "left to right (sort column)" but it shuffles only the words in the first row.

I uploaded one example file if someone wants to check it.


http://www.mediafire.com/?7k5whsix8vbadsn


Thanks!


Last edited by peter_yt on Thu Oct 27, 2011 3:40 am; edited 1 time in total
Back to top
View user's profile Send private message
floris_v
Moderator
Moderator


Joined: 12 Jul 2007
Posts: 4791
Location: Netherlands

PostPosted: Sun Oct 23, 2011 12:33 pm    Post subject: Reply with quote

It did shuffle words in all rows for me in LibreOffice. What version of OOo did you try it with?
_________________
LibreOffice 3.6.3; OOo 3.4.1 on Windows Vista
Join the Official community forum - in several languages, including Nederlandstalig forum
Back to top
View user's profile Send private message
peter_yt
Newbie
Newbie


Joined: 23 Oct 2011
Posts: 3

PostPosted: Mon Oct 24, 2011 1:24 am    Post subject: Reply with quote

I found how to shuffle the words but now how i can join them?

This is what i want to do. I am pasting in spreadsheet in A column 100 sentences that have a different number of words in them. Then i am using "text to column" and separating the words in these sentences using "space" as a delimiter. Then i shuffle the words. And now i want to join the words in sentences again. How can i do this?

I am using the last version of open office 3.3.0


Thanks!
Back to top
View user's profile Send private message
ken johnson
Super User
Super User


Joined: 23 Apr 2009
Posts: 2032
Location: Sydney, Australia

PostPosted: Tue Oct 25, 2011 4:04 am    Post subject: Reply with quote

Attached doc (Reorder Sentence.ods) uses formulae to shuffle the words after Text to Columns, and formulae on Sheet2 to form jumbled sentences.
http://www.mediafire.com/view/?de3reiq57dabm73
Formulae in Sheet1.A110:AX209 return either random number or blank depending on number of words in sentence in column A (rows 1 to 100)

Formulae in Sheet1.A212:AX311 reorder the words.
Formulae in Sheet2.A1:AX100 reassemble the word into a jumbled sentence.
On Sheet2 columns A to AW are hidden.

Since only columns A to AX (50 columns) have been used, this setup has a limit of 50 words per sentence.
For more than 50 word per sentence the formulae in Sheet1AX110:AX209, Sheet1.AX212:AX311 and Sheet2.AX1:AX100 will all need to be filled across their respective sheets for extra columns.

Ken Johnson
_________________
If your problem has been solved please add "[Solved]" to the beginning of your first post title (edit button).


Last edited by ken johnson on Thu Sep 27, 2012 6:55 pm; edited 1 time in total
Back to top
View user's profile Send private message
peter_yt
Newbie
Newbie


Joined: 23 Oct 2011
Posts: 3

PostPosted: Thu Oct 27, 2011 3:41 am    Post subject: Reply with quote

Thanks!
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> General Discussion All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group