[Solved] Sorting a table in AOO Writer

[wdc]

Please tell me how to SORT a table such that the entries in Column 1 are alphabetized and their associated column 2 and column 3 entries "stay" with their masters from column 1?

Thus I want

Code: Select all

    grapes       purple      round
    bananas      yellow      long
    apples       red         round
    figs         brown       flat

to come out

Code: Select all

    apples       red         round
    bananas      yellow      long
    figs         brown       flat
    grapes       purple      round

Thank you. ....wdc

[robleyd]

Select the entire table you want to sort; go to Tools | Sort or Table | Sort; under sort criteria, select key1 and column 1, ascending (probably the default) and click OK.

[wdc]

David: Thanks for responding. There seems to be a difference in our versions of OOW. I have been working with the SORT under TABLES. The SORT under TOOLS is inactive, shaded out. So I cannot follow your suggestion.

Sorting (under) Table <does> alphabetize the designated column but it does not "carry along' the associated entries in columns 2, 3, et al. wdc

[MrProgrammer]

Sorting (under) Table <does> alphabetize the designated column but it does not "carry along' the associated entries in columns 2, 3, et al.

On my Openoffice installation, Table → Sort keeps row entries together if I select the entire table (Table → Select → Table) before performing the sort.

Before sort

Screen Shot 2019-04-12 at 15.16.58 .png (8.03 KiB) Viewed 1169 times

Sort dialog

After sort

Screen Shot 2019-04-12 at 15.18.15 .png (7.84 KiB) Viewed 1169 times

Read about Sorting data in a table, especially the note at the end of that subject. You have to select …

If you continue to have difficulty, you are more likely to get your problem solved quickly if you attach a document demonstrating the situation (remove confidential information then use Post Reply, not Quick Reply, and don't attach a picture instead of the document itself). Explain in detail all the steps you use to perform the sort,

If this solved your problem please go to your first post use the Edit button and add [Solved] to the start of the title. You can select the green checkmark icon at the same time.

[robleyd]

Sorting (under) Table <does> alphabetize the designated column but it does not "carry along' the associated entries in columns 2, 3, et al

As mentioned,you need to select all the columns to have them included in the sort process.

[Bill]

David: Thanks for responding. There seems to be a difference in our versions of OOW. I have been working with the SORT under TABLES. The SORT under TOOLS is inactive, shaded out. So I cannot follow your suggestion.

Table > Sort and Tools > Sort open the same Sort dialog, so you should be able to follow David's suggestion by using Table > Sort instead of Tools > Sort.

[wdc]

Thank you all for your directions and your patience.
I am ok now. Wdc