Sorting Sheet

jsanders · Posted: Fri Jan 21, 2005 9:17 pm Post subject: Sorting Sheet

I'm sure this is easy, but i've been beating my head for a few hours trying to figure it out...

Here is the tiny sample sheet I want to sort:

a b c
1 1 Mary Steel 1/1/05
2 2 Areva 2/4/05
3 3 Stephens 1/6/05
4 4 ABC Steel 3/22/05

In excell if I select any single in cell in column b and hit sort A-Z (sort by Name) I get:

a b c
1 4 ABC Steel 3/22/05
2 2 Areva 2/4/05
3 1 Mary Steel 1/1/05
4 3 Stephens 1/6/05

If I do the same thing in calc I get no change, in other words, the data are sorted by number (col A)

WHY? and how can I change it!!

I know I can choose SORt from the DATA menu but this isn't nearly as fast as just selecting a cell in the colum I want to sort the data by and punching the button.
_________________
Help I've stood and I can't get down!

David · Posted: Sat Jan 22, 2005 6:14 am Post subject: Re: Sorting Sheet

JohnV · Posted: Sat Jan 22, 2005 7:20 am Post subject:

Will clicking the column header you want to sort on and then A-Z do what you want?

jsanders · Posted: Sat Jan 22, 2005 9:38 am Post subject: Sorting

Thanks for your response

I know I can select the entire data set and choose SORT off the DATA menu. This requires at least 5 actions:

1 Select data
2 Click on Data menu
3 Click Sort
4 Choose Column
5 Hit enter

In excell you get the same result with 2 clicks:

1 Select a cell in the column you want to sort the data by.
2 Click sort A-Z.

I know it may seem petty but when you are constantally sorting by different critera it gets old really fast. I'm a dispatcher for a freight brokerage and I'm constantaly working with the data while talking on the phone and generally in a big hurry.

Because I'm new to CALC I was hoping there was some setting I was overlooking that would allow me to do this. It sounds like that is not the case.

Selecting the column header will sort the column independent of the other column which would screw up my data.
_________________
Help I've stood and I can't get down!

JohnV · Posted: Sun Jan 23, 2005 6:41 am Post subject:

jsanders · Posted: Sun Jan 23, 2005 10:14 am Post subject: Sort

You're responses are helping me, I appriciate them.

So It sounds like I need to register the sheet as a data source and figure out what the F4 viewer is... I'll dig into the documentation.

Thanks again for your response.

JOE
_________________
Help I've stood and I can't get down!

jsanders · Posted: Sun Jan 23, 2005 10:59 am Post subject: Sort

Ok I got it... This is VERY cool. I've registered my sheet as a database table and i'm off and running

Thanks again for you help.

-JOE
_________________
Help I've stood and I can't get down!