why does Calc add or change words when sorting?

When I type words in a column and then use the sort option, some words are changed and some sometimes are deleted. Is there a way to stop this from happening?

Hello @pamtango, Check that there are no hidden rows.


Add Answer is reserved for solutions. Please, click edit below your question to add more information.