I use LibreOffice for data on organisms with mostly scientific names. The problem occurs when an organism has several synonyms. For example: The asian small-clawed otter is both refered to as Aonyx cinerea and Amblonyx cinereus. I want to be able to put the most used one visible in the cell and the others invisible in the same cell. So when Amblonyx cinereus is visible and I type Aonyx cinerea at the bottom It’s still highlighted, telling me that I have this name already in the data. I was wondering if there was a way that I could do this one way or the other, I’m unable to find any answers on the internet.
With kind regards,
Marckosaurus