I have a table where the first column is a drop-down list. I am trying to sort on the entries, but it does not 'seem to be working.
With the 1st column highlighted in blue, I click on the Sort A/Z button and the pop-up below shows the default settings, which I am using. I click OK but the sort does not work.
Any help would be appreciated.
This is only a part of the problem description, the important part is “I click OK but the sort does not work”.
How do you insert a “drop-down list” in the first column of the table? I suspect this is with form controls. In this case, whatever you do, it won’t work. Sorting operates only on “common” text. If you place objects in the cells, they won’t sort. Or if they sort, that’ll be on the global “definition”, whatever it is and this definition does not take into account attribute setting like the line which is ticked. All lists will sort equal and the table won’t change.
In the dialog box shown, the option selected under Direction is “rows”. Maybe it should be “columns” since that is how your data is organized, unless there is something else that I don’t understand about sorting.
All I want is for the 1st column to reorganize the rows so that the items in the drop-down are regrouped. For example, the Item choices I set up for the dropdown are “Alpha”, “Beta”. and"Charlie"
In each new row, one of these is chosen and so on for the next 10 rows. There also other columns in which other data is entered However, the rows are not all entred in alphabetical order i.e they are entered randomly. I want to now group all the entries so that all the “Alpha”'s are grouped together, etc…
I hope that explains this more clearly.
I have created this document in Word and opened it in Libre
F or the other comment, yes It is Form and to modify I highlight and right-click and use Control Properties.
I can sort on the Drop-down column In Word, but it may not work in Libre.
Please let me know
