-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On Friday, 2013-06-21 at 13:45 +0100, Dave Howorth wrote:
But I have not found a "reverse" option in the menus. Did I miss it?
I don't know the official answer but there are at least two ways to solve it:
(1) add an additional column that contains monotonically increasing integers. Reverse sort on that column. Then delete the column.
Yep. I thought of this way two minutes after posting. Usually writing a post has this effect on me, finding the answer, or an answer ;-) I added a column, first cell is 1, next is previous +1. Then copy paste values to destroy the formula, then sort by that column. I think there is another way to fill a column with consecutive numbers, but that's the way I remember. Do all that on an auxiliary sheet, copy back to original table the resulting table less the sorting column. Otherwise, add a column, number it, sort, delete column. I had been sorting by date previously, till today I noticed the numbers in the total column were wrong, ie, the entries were sorted wrong. I had to import the original data and sort again, correctly this time.
(2) sort on both the date and another column
In the case of your example of course you could just reverse sort on either of the other columns :)
Yes, right, but unreliable on an account, the "total" column goes up and down :-) - -- Cheers, Carlos E. R. (from 12.3 x86_64 "Dartmouth" at Telcontar) -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.19 (GNU/Linux) iEYEARECAAYFAlHETZAACgkQtTMYHG2NR9WzZwCeMlZq0dEIuB08XZ9aftnWs47m SAYAnA44gfq95MjXlG1qC2zB6U5kGZ7z =kxps -----END PGP SIGNATURE----- -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org