[Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register]

Author Message
jsanders
General User

Joined: 21 Jan 2005
Posts: 8
Location: Southern Oregon

 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
Super User

Joined: 24 Oct 2003
Posts: 5668

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

 jsanders wrote: 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.

In Calc, select all the data, then from the menu choose Data Sort, then choose to sort by column B descending.
JohnV

Joined: 07 Mar 2003
Posts: 9133
Location: Lexinton, Kentucky, USA

 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
General User

Joined: 21 Jan 2005
Posts: 8
Location: Southern Oregon

 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

Joined: 07 Mar 2003
Posts: 9133
Location: Lexinton, Kentucky, USA

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

 Quote: Selecting the column header will sort the column independent of the other column which would screw up my data.
Sorry, this works the way you want when the spreadsheet is registered as a data source and you use the F4 viewer but not in Calc. I had just been doing this with a data source, thus my answer.
jsanders
General User

Joined: 21 Jan 2005
Posts: 8
Location: Southern Oregon

 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
General User

Joined: 21 Jan 2005
Posts: 8
Location: Southern Oregon

 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!
 Display posts from previous: All Posts1 Day7 Days2 Weeks1 Month3 Months6 Months1 Year Oldest FirstNewest First
 All times are GMT - 8 Hours Page 1 of 1

 Jump to: Select a forum OpenOffice.org Forums----------------Setup and TroubleshootingOpenOffice.org WriterOpenOffice.org CalcOpenOffice.org ImpressOpenOffice.org DrawOpenOffice.org MathOpenOffice.org BaseOpenOffice.org Macros and APIOpenOffice.org Code Snippets Community Forums----------------General DiscussionSite Feedback
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum