Score:0

Libreoffice calc opens sheets with one line of unknown characters

us flag

Does anyone know why Libreoffice opens csv files like this for me recently? I've been having to import them into google sheets instead, where they work fine but it's a pain. Ubuntu 20.04 LO Version: 6.4.7.2 Build ID: 1:6.4.7-0ubuntu0.20.04.1

Screenshot of LO launch screen:

enter image description here

Score:0
uz flag
Jos

You have set the expected character set (the top dropdown list) to UTF-16. Each character is supposed to occupy two bytes, which is intended for languages like Chinese. Regular English can do with one byte per character.

Set your character set to UTF-8 and all will be fine.

Disclaimer: my explanation above is rather simplified: in fact the situation is much more complicated than that. Search for "Unicode" if you want the full details.

mangohost

Post an answer

Most people don’t grasp that asking a lot of questions unlocks learning and improves interpersonal bonding. In Alison’s studies, for example, though people could accurately recall how many questions had been asked in their conversations, they didn’t intuit the link between questions and liking. Across four studies, in which participants were engaged in conversations themselves or read transcripts of others’ conversations, people tended not to realize that question asking would influence—or had influenced—the level of amity between the conversationalists.