Sort function in LibreWriter v24.8

I have related data in separate columns e.g. Spanish word & English translation. I want to sort the Spanish column alphabetically. If I highlight both columns and choose to sort, nothing happens. I can’t sort each column separately because the columns correlate to each other. I’ve tried the sort in Tables and also in Tools. It’s been frustrating not being able to find help and I’ve spent the whole day trying to figure a simple sort out! any help is appreciated! TIA

Have you chosen the correct column to sort by in the Sort dialogue?


In the above dialogue I have chosen to sort by column 1. If I choose to sort by column two, nothing will happen because it is already sorted by column two.
Have you chosen to sort by row?