Tab character (Calc)

I've come across a strange problem (July 2022): I can't just insert a tab into a cell and preserve it when copying the content of that cell to a text file.