You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@openoffice.apache.org by Robert Peeters <ro...@yahoo.com.INVALID> on 2020/11/03 23:28:34 UTC
Sorting in Open Office
Hello,
I cannot get my Open Office to sort lists for me. I am trying to alphabetize a list,and have followed all tutorials and google searches to try it. For example, here isthe list I would like to put in alphabetical order from A to Z:
Is this problem due to the fact that there are several words on each line?
AppleJack & Peel
Vanilla Bean
Cinnamon
FreshCut Christmas Tree
Smell of Christmas
Christmas Splendor
Sugared Spruce
Hillbilly Mistletoe
Fireside
Vanilla Bean Noel
Re: Sorting in Open Office
Posted by Dick Groskamp <di...@apache.org>.
On 2020/11/04 03:31:37, Robert Peeters <ro...@yahoo.com.INVALID> wrote:
> Steve,
> Thanks for your reply. Actually, it is just a text page in Open Office Writer. I am trying to alphabetize my listsand am having no success doing so.
> I AM NOT using a spreadsheet, and I have no idea what a '' Data Range '' is. Here is a photo of my list of items Iam simply trying to alphabetize from A to Z.
> I have tried to highlight the items, go to TOOLS > sort > etc but it has no effect on alphabetizing the list.
> Thank you. Rob
>
Rob,
select the items in the list you want to sort.
Then Options > Sort
Make sure Rows is selected in the dialog, section Direction.
Other options could stay as they are ( Key 1 Column = 1 and Type key = Alphanumeric)
That sorts your list to:
AppleJack & Peel
Christmas Splendor
Cinnamon
Fireside
FreshCut Christmas Tree
Hillbilly Mistletoe
Smell of Christmas
Sugared Spruce
Vanilla Bean
Vanilla Bean Noel
At least at my setup
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
For additional commands, e-mail: users-help@openoffice.apache.org
Re: Sorting in Open Office
Posted by Robert Peeters <ro...@yahoo.com.INVALID>.
Steve,
Thanks for your reply. Actually, it is just a text page in Open Office Writer. I am trying to alphabetize my listsand am having no success doing so.
I AM NOT using a spreadsheet, and I have no idea what a '' Data Range '' is. Here is a photo of my list of items Iam simply trying to alphabetize from A to Z.
I have tried to highlight the items, go to TOOLS > sort > etc but it has no effect on alphabetizing the list.
Thank you. Rob
> On Tuesday, November 3, 2020, 08:06:51 PM CST, Steven Ahlers <sa...@yahoo.com> wrote:
Rob,
Are you using a spreadsheet in Calc? If so have you defined your DATA RANGE?
Your example list will sort fine once you have defined the DATA RANGE.
If you’re not subscribed to the users list you may not see all of the responses to your inquiry. Please DO NOT respond to my email address instead respond to: users@openoffice.apache.org
Sent from my iPhone
>> On 11/3/2020 5:28 PM, Robert Peeters wrote:
>> Hello,
>> I cannot get my Open Office to sort lists for me. I am trying to alphabetize a list,and have followed all tutorials and google searches to try it. For example, here isthe list I would like to put in alphabetical order from A to Z:
>> Is this problem due to the fact that there are several words on each line?
>> AppleJack & Peel
>> Vanilla Bean
>> Cinnamon
>> FreshCut Christmas Tree
>> Smell of Christmas
>> Christmas Splendor
>> Sugared Spruce
>> Hillbilly Mistletoe
>> Fireside
>> Vanilla Bean Noel
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
> For additional commands, e-mail: users-help@openoffice.apache.org
Re: Sorting in Open Office
Posted by Steven Ahlers <sa...@yahoo.com.INVALID>.
Rob,
Are you using a spreadsheet in Calc? If so have you defined your DATA RANGE?
Your example list will sort fine once you have defined the DATA RANGE.
If you’re not subscribed to the users list you may not see all of the responses to your inquiry. Please DO NOT respond to my email address instead respond to: users@openoffice.apache.org
Sent from my iPhone
>> On 11/3/2020 5:28 PM, Robert Peeters wrote:
>> Hello,
>> I cannot get my Open Office to sort lists for me. I am trying to alphabetize a list,and have followed all tutorials and google searches to try it. For example, here isthe list I would like to put in alphabetical order from A to Z:
>> Is this problem due to the fact that there are several words on each line?
>> AppleJack & Peel
>> Vanilla Bean
>> Cinnamon
>> FreshCut Christmas Tree
>> Smell of Christmas
>> Christmas Splendor
>> Sugared Spruce
>> Hillbilly Mistletoe
>> Fireside
>> Vanilla Bean Noel
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
> For additional commands, e-mail: users-help@openoffice.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
For additional commands, e-mail: users-help@openoffice.apache.org
Re: Sorting in Open Office
Posted by Web Shari <we...@gmail.com>.
Are you using cal or writer?
Shari
On 11/3/2020 5:28 PM, Robert Peeters wrote:
> Hello,
> I cannot get my Open Office to sort lists for me. I am trying to alphabetize a list,and have followed all tutorials and google searches to try it. For example, here isthe list I would like to put in alphabetical order from A to Z:
> Is this problem due to the fact that there are several words on each line?
>
>
> AppleJack & Peel
> Vanilla Bean
> Cinnamon
> FreshCut Christmas Tree
> Smell of Christmas
> Christmas Splendor
> Sugared Spruce
> Hillbilly Mistletoe
> Fireside
> Vanilla Bean Noel
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
For additional commands, e-mail: users-help@openoffice.apache.org