I'm really annoyed that even Open/LibreOffice copied this crap behaviour. I try to avoid spreadsheets. I won't use them unless there's calculations to be done.

I'm really annoyed that even Open/LibreOffice copied this crap behaviour. I try to avoid spreadsheets. I won't use them unless there's calculations to be done. When I do use them, the first thing when I create a new sheet is to select all cells and set it to text. It's probably a bad habit, but it's the only way to avoid future frustration and mistakes.