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 Alphabetically

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


Joined: 11 Nov 2005
Posts: 18
Location: Bay City, MI

PostPosted: Mon Dec 05, 2005 11:40 am    Post subject: Sorting Alphabetically Reply with quote

Can this be done in aspreadsheet? Or just in text documents?

Could someone help me If it can be done in Calc ?

I've read tutorials but can't seem to find answer.
Back to top
View user's profile Send private message Send e-mail
jrkrideau
Super User
Super User


Joined: 08 Aug 2005
Posts: 6732
Location: Kingston ON Canada

PostPosted: Mon Dec 05, 2005 11:49 am    Post subject: Re: Sorting Alphabetically Reply with quote

ihaveaquestion wrote:
Can this be done in aspreadsheet? Or just in text documents?

Could someone help me If it can be done in Calc ?

I've read tutorials but can't seem to find answer.


Try it and see Smile

Yes you can.
_________________
jrkrideau
Kingston ON Canada
Currently using Windows 7 & OOo 3.4.0 and Ubuntu 12.04 & LibreOffice 3.5.2.2
Back to top
View user's profile Send private message
AndrewZ
Moderator
Moderator


Joined: 21 Jun 2004
Posts: 4140
Location: Colorado, USA

PostPosted: Mon Dec 05, 2005 12:00 pm    Post subject: Reply with quote

You could probably find the answer through OpenOffice.org's help. When in OOo, just press F1 to bring up the help. It will let you search too.

In Calc there are at least two ways to sort:
1. Through sort button on toolbar
2. Through menu: Data->Sort
Back to top
View user's profile Send private message Visit poster's website
ihaveaquestion
General User
General User


Joined: 11 Nov 2005
Posts: 18
Location: Bay City, MI

PostPosted: Mon Dec 05, 2005 12:39 pm    Post subject: Reply with quote

That's what I was trying to do from the tutorials.

First- the Sort button does not light up when I highlight the cells I want to sort

Second- Data-Sort-OK does nothing either.

I have to use OO 1.1 and that is the tutorial I was using.
Back to top
View user's profile Send private message Send e-mail
ihaveaquestion
General User
General User


Joined: 11 Nov 2005
Posts: 18
Location: Bay City, MI

PostPosted: Mon Dec 05, 2005 12:46 pm    Post subject: Reply with quote

Maybe this will help.

Data-Sort-Options= Sun,Mon,Tue,Wed,Thu.Fri,Sat (greyed out)
Back to top
View user's profile Send private message Send e-mail
jrkrideau
Super User
Super User


Joined: 08 Aug 2005
Posts: 6732
Location: Kingston ON Canada

PostPosted: Mon Dec 05, 2005 6:25 pm    Post subject: Reply with quote

ihaveaquestion wrote:
Maybe this will help.

Data-Sort-Options= Sun,Mon,Tue,Wed,Thu.Fri,Sat (greyed out)


That's an awfully old version. I have never used anything lower than 1.9.113 so I' m afraid Icannot help. It is strange. I just did your sort with 2.0.0 with no problem. What version does the tutorial refer to? If it is 1.4 or something it may be using something that was not in 1.1
_________________
jrkrideau
Kingston ON Canada
Currently using Windows 7 & OOo 3.4.0 and Ubuntu 12.04 & LibreOffice 3.5.2.2
Back to top
View user's profile Send private message
ihaveaquestion
General User
General User


Joined: 11 Nov 2005
Posts: 18
Location: Bay City, MI

PostPosted: Tue Dec 06, 2005 4:06 am    Post subject: Reply with quote

I did get it to work in Writer after restarting computer.

The company has version 1.1.4 and upgrading is out of the question.

I have both versions on home computer but still use 1.1.4 for stuff from work.
I know 2.0 will save it to 1.1 format but, by actually using the 1.1 version I know it will also work at work.

I still cannot get either version to sort in Calc but not worried about it.

Thank you for responses.
Back to top
View user's profile Send private message Send e-mail
jrkrideau
Super User
Super User


Joined: 08 Aug 2005
Posts: 6732
Location: Kingston ON Canada

PostPosted: Tue Dec 06, 2005 6:58 am    Post subject: Reply with quote

ihaveaquestion wrote:
I did get it to work in Writer after restarting computer.

The company has version 1.1.4 and upgrading is out of the question.

I have both versions on home computer but still use 1.1.4 for stuff from work.
I know 2.0 will save it to 1.1 format but, by actually using the 1.1 version I know it will also work at work.

I still cannot get either version to sort in Calc but not worried about it.

Thank you for responses.


It sounds like you have something seriously wrong with those installations. Both Write and Calc sort just fine in 2.0 and I have difficulty imagining that Calc in an 1.x version would not sort.
_________________
jrkrideau
Kingston ON Canada
Currently using Windows 7 & OOo 3.4.0 and Ubuntu 12.04 & LibreOffice 3.5.2.2
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