> At 23:26 09/07/2009 -0700, Peter Dow wrote: > >After you select all the columns and rows you want to sort, ... > > One trick that hasn't been mentioned is that you often don't need to > select exactly the rows and columns which you need sorted. If you > select any *single* cell within the range you require, Calc will make > an intelligent expansion of the selection to the range you probably > require. You can see and check the expanded selection as you do the sort.
Brian Barker wrote: > Indeed, if - in your case - you select just a single cell in column W > and then go to Data | Sort..., you should find not only that the > range has been correctly selected for you but also that "Column W" > has already been suggested under "Sort by" in the Sort window. bg: I'd be carefully checking the results of such a sequence were I you, Brian. I just tried it, and my version (2.0) decidedly does *not* work that way. I selected a single cell in column J - then went to "DATA" / "SORT" and the highlighted range was C through M on a sheet that has columns populated from A though N - as if that wasn't bad enough, the default sort presented was column D, not column J. Where it got C though M is a mystery. As is how it picked column D for the default sort. I frequently sort some sheets that I use for an email notification database, and I have learned that if I don't select the entire sheet before performing a sort, the results can be extremely unpredictable to say the least. Brewster -- ********************************************************************** W. Brewster Gillett [email protected] Portland, OR USA ********************************************************************** Simply because you don't like to hear it, that doesn't make it untrue. ********************************************************************** --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
