OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

sorting on a simple list

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc
View previous topic :: View next topic  
Author Message
thetosser
Newbie
Newbie


Joined: 11 Jul 2010
Posts: 3

PostPosted: Sun Jul 11, 2010 7:28 am    Post subject: sorting on a simple list Reply with quote

I have built a simple list of items and using the A to Z button can sort them without issue. The problem comes when the first item is out of order e.g.

pate
beef
burgers
chicken
rashers
sausages

I click on pate and select the whole list and select the sort toolbar button. Everything on the list reorders apart from the first item. I am forced to include the empty cell above pate in the range but then it shifts the whole list up one cell.

I assume this is a very bug!
Back to top
View user's profile Send private message
aloarjr810
OOo Enthusiast
OOo Enthusiast


Joined: 04 Jun 2008
Posts: 113

PostPosted: Sun Jul 11, 2010 7:48 am    Post subject: Reply with quote

When you go to the menu Data>Sort. and the sort window opens.

Click on Options and uncheck "Range contains column labels"
Back to top
View user's profile Send private message
thetosser
Newbie
Newbie


Joined: 11 Jul 2010
Posts: 3

PostPosted: Sun Jul 11, 2010 8:30 am    Post subject: Reply with quote

Thank you

Now how do I stop it from assuming all my other lists include a label as I don't want to have to do what you suggest for each list I have
Back to top
View user's profile Send private message
annsmith0320
Newbie
Newbie


Joined: 11 Jul 2010
Posts: 1

PostPosted: Sun Jul 11, 2010 12:40 pm    Post subject: Reply with quote

You won't need to do it for every list. Once you have unchecked that option, it is automatically followed for the whole document.
Back to top
View user's profile Send private message
thetosser
Newbie
Newbie


Joined: 11 Jul 2010
Posts: 3

PostPosted: Mon Jul 12, 2010 2:47 pm    Post subject: Reply with quote

annsmith0320 wrote:
You won't need to do it for every list. Once you have unchecked that option, it is automatically followed for the whole document.


I am using OO 3.2 and what you say is not correct. Using Data->Sort->Current Selection->Options....Range contains column labels

I continually have to deselect this setting everytime I do a sort on a list in my spreadsheet even if its a list i've just sorted that option is selected when i go back in!!
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
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


Powered by phpBB © 2001, 2005 phpBB Group