LinuxQuestions.org
Share your knowledge at the LQ Wiki.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices

Closed Thread
 
Search this Thread
Old 09-09-2005, 08:32 PM   #1
joshknape
Member
 
Registered: Jul 2005
Posts: 216

Rep: Reputation: 30
Can OpenOffice alphabetize?


I am alphabetizing a list in an OO document--manually, at present. Is there an automatic alphabetizing function, by any chance?
 
Old 09-09-2005, 08:56 PM   #2
aysiu
Senior Member
 
Registered: May 2005
Distribution: Ubuntu with IceWM
Posts: 1,776

Rep: Reputation: 66
Re: Can OpenOffice alphabetize?

Quote:
Originally posted by joshknape
I am alphabetizing a list in an OO document--manually, at present. Is there an automatic alphabetizing function, by any chance?
I'd copy the list to OpenOffice Calc, sort it there, then copy the text into Gedit or Kate, save it as text-only, then copy it back to OpenOffice Writer.
 
Old 09-09-2005, 08:57 PM   #3
moxieman99
Member
 
Registered: Feb 2004
Distribution: Dabble, but latest used are Fedora 13 and Ubuntu 10.4.1
Posts: 413

Rep: Reputation: 82
I believe that there is, but your question would be better off posted in the user forums at www.openoffice.org
 
Old 09-09-2005, 09:07 PM   #4
bigrigdriver
LQ Addict
 
Registered: Jul 2002
Location: East Centra Illinois, USA
Distribution: Debian Squeeze
Posts: 5,772

Rep: Reputation: 309Reputation: 309Reputation: 309Reputation: 309
Since you don't give any details of what kind of list, other than alphabetical, I'll assume one column (not multiple columns). I also assume the list is a spreedsheet, not a text document.

Enter the items to be sorted in any order you choose. Then, from the main menu, select Data, Sort... When the dialogue box comes up, select the column to be the base of the sort, then select Sort Ascending or Descending (sort from smallest to largest [alphabecitally], or sort from largest to smallest).

Last edited by bigrigdriver; 09-09-2005 at 09:09 PM.
 
Old 09-09-2005, 09:27 PM   #5
aysiu
Senior Member
 
Registered: May 2005
Distribution: Ubuntu with IceWM
Posts: 1,776

Rep: Reputation: 66
I created a screenshot tutorial on this just for you. Let me know if you have any questions. I left out the step of copying it to Kate and then back to OpenOffice Writer, but I think you can figure that out.
 
Old 09-11-2005, 08:56 PM   #6
joshknape
Member
 
Registered: Jul 2005
Posts: 216

Original Poster
Rep: Reputation: 30
It worked, thank you--except for one problem: It is including articles in the alphabetization. Alphabetized lists are supposed to ignore "a" and "the." And I'm sorry to have been unclear; it *is* a text list.

Last edited by joshknape; 09-11-2005 at 09:02 PM.
 
Old 09-11-2005, 09:06 PM   #7
aysiu
Senior Member
 
Registered: May 2005
Distribution: Ubuntu with IceWM
Posts: 1,776

Rep: Reputation: 66
Quote:
Originally posted by joshknape
It worked, thank you--except for one problem: It is including articles in the alphabetization. Alphabetized lists are supposed to ignore "a" and "the." And I'm sorry to have been unclear; it *is* a text list.
How many items in the list start with articles? 10s? 100s? 1000s? If it's 10s, you can go in and manually resort those. If it's 100s or 100s, there's another workaround that uses a text editor and OpenOffice Calc. Let me know if you need it.
 
Old 09-11-2005, 10:07 PM   #8
joshknape
Member
 
Registered: Jul 2005
Posts: 216

Original Poster
Rep: Reputation: 30
It's probably around one hundred items, so I could use that other method.
 
Old 09-11-2005, 10:40 PM   #9
aysiu
Senior Member
 
Registered: May 2005
Distribution: Ubuntu with IceWM
Posts: 1,776

Rep: Reputation: 66
Quote:
Originally posted by joshknape
It's probably around one hundred items, so I could use that other method.
All right. Right now I don't have the patience to do screenshots, but I'll try my best to describe it.

1. Cut and paste the "the" section into a separate text (.txt) document. I mean cut and paste, not copy and paste.
2. Save that document as temp.txt
3. Open up OpenOffice Calc.
4. Press Control-O.
5. Locate temp.txt, but under File Type select Text CSV (*.csv,*.txt)--you'll have to scroll down quite a bit to find it.
6. Then, under Separator Options, select Fixed Width.
7. Hover your mouse over the ruler bar. You'll see a vertical line appear where your mouse is. Put that vertical line just to the left of the words after "the." Then click so that the line sticks.
8. Press OK. You should have a spreadsheet with two columns--one column of "the" and another column of all the words after "the."
9. Repeat steps 1-8 with the "a" section.
10. Cut and paste the "a" section spreadsheet into the "the" spreadsheet. You should now have two columns--one column of "the" and "a" together, another column with their corresponding titles.
11. Cut and paste all the remaining titles (the non-article-prefaced ones) at the end of column B. Make all the empty cells in Column A xxx
12. Sort by column B. Now all of your titles should be sorted by actual title.
13. Cut and paste columns A and B together (one cut and paste that selects both columns) into a text document.
14. Go to "Find/Replace." Replace xxx with nothing.
15. Your list should be sorted now.

Last edited by aysiu; 09-11-2005 at 11:15 PM.
 
Old 07-31-2010, 03:58 PM   #10
harryhill
LQ Newbie
 
Registered: Jul 2010
Posts: 1

Rep: Reputation: 0
Quote:
Originally Posted by bigrigdriver View Post
Since you don't give any details of what kind of list, other than alphabetical, I'll assume one column (not multiple columns). I also assume the list is a spreedsheet, not a text document.

Enter the items to be sorted in any order you choose. Then, from the main menu, select Data, Sort... When the dialogue box comes up, select the column to be the base of the sort, then select Sort Ascending or Descending (sort from smallest to largest [alphabecitally], or sort from largest to smallest).
I have OO 3.1.2--that does not show up. And, when I do what you say, I get a option to 'Extend Selection or Current Selection' (Like Exel) etc. And, alph screws up. But if I select all rows/columns--Like OO used to and select SORT--that worked.
 
Old 08-02-2010, 07:50 AM   #11
pixellany
LQ Veteran
 
Registered: Nov 2005
Location: Annapolis, MD
Distribution: Arch/XFCE
Posts: 17,802

Rep: Reputation: 728Reputation: 728Reputation: 728Reputation: 728Reputation: 728Reputation: 728Reputation: 728
harry*;
This thread is almost 5 years old. Because OOo has evolved quite a bit, there is a lot of opportunity for confusion here-----Please start a new thread with your question.

closed
 
  


Closed Thread


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
alphabetize my list c++ AquamaN Programming 8 10-25-2005 01:20 AM
OpenOffice help mykrob Linux - Software 2 01-29-2005 10:24 AM
alphabetize reviews Present LQ Suggestions & Feedback 2 01-09-2005 06:50 PM
openoffice fabre Linux - Software 2 07-29-2004 08:12 PM
openoffice term789 Linux - Newbie 2 10-22-2003 12:39 PM


All times are GMT -5. The time now is 09:54 AM.

Main Menu
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration