And please remember, when recording the macro I sorted columns A & B, THEN C
& D, THEN E & F. These sorts have to be done separately in order to produce
a completely random sentence at the bottom. However, when using the macro,
the Television is always Red and Small. This is not supposed to be the
case. If the three pairs are sorted separately, then sometimes the
Television might be Blue and Expensive for example.
-----Original Message-----
From: RA Brown
Sent: Saturday, November 20, 2010 4:43 PM
To: [email protected]
Cc: [email protected]
Subject: Re: [users] Re: reporting bug with openoffice calc
On Sat Nov 20 2010 15:08:03 GMT-0800 (PST) John Connelly wrote:
When I first opened the Basic Macros window, there WAS a + to the left of
Example Spreadsheet.ods. However, when I click on it, it disappears and
there is nothing under it. I've done this four times and ONE of the times
there actually was a Standard folder under it, but it had nothing in it.
Also, like I said before, it will only take a few seconds to record the
macro yourself and hook it to that button on my spreadsheet. The macro
simply selects the entire columns A & B then sorts them by Rand #1 (by
clicking Data> Sort, then choosing Rand #1); then selects columns C & D
and sorts by Rand #2; then selects columns E & F and sorts by Rand #3.
That's it :)
Thanks
The macro I recorded selects all the columns and sorts on the first and
everything changes. As I said I do not know how to attach to the button
but runs from the "Run Macro" under Tools.
Andy
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
