Andy,The CONCATENATE at the bottom of the spreadsheet works perfectly to produce completely random sentences when the three pairs of columns are sorted manually. However, when creating a macro to sort the the pairs of columns (to save time), it no longer works correctly. It seems that the macro doesn't allow the three separate sorts to happen. Instead it seems that all three pairs are sorted together causing the contents of columns B D and F to always stay on the same row as each other; therefore, no longer producing a random sentence at the bottom. For example, the television will always be red and small. This should not be the case, and is not the case when sorting the three pairs of columns manually.
And in regard to the macro not being included with the file when I send it, I have no idea how to include the macro. It's in the file on my computer.
Thanks for your time. I really appreciate your help. John-----Original Message----- From: RA Brown
Sent: Saturday, November 20, 2010 10:13 AM To: [email protected] Cc: [email protected] Subject: Re: [users] Re: reporting bug with openoffice calc On Sat Nov 20 2010 09:02:59 GMT-0800 (PST) John Connelly wrote:
What is the email address to the mailing list so I won't have to reply directly to you? And yes, it is intended. The CONCATENATE at the bottom of the spreadsheet is supposed to produce random sentences.
Someone that knows Calc better will have to answer but I do not think that is going to work the way you think.
-----Original Message----- From: RA Brown Sent: Saturday, November 20, 2010 9:42 AM
To: [email protected]
Cc: [email protected] Subject: Re: [users] Re: reporting bug with openoffice calc
See the To: in the line above, that is the users mailing list address. If you hit "Reply all" it will send a copy to both the list and to me, but then I can reply from the list.Andy
Example Spreadsheet.ods
Description: application/vnd.oasis.opendocument.spreadsheet
--------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
