I'm using LibreOffice 6.0.1.1 and have found that all my .csv files have turned into a single line of apparently Japanese characters.
Has anybody any ideas why this might be, and how to effect a cure?
TJH
.csv problem with libreoffice
-
- Lemon Half
- Posts: 7675
- Joined: November 4th, 2016, 11:20 am
-
- Lemon Quarter
- Posts: 4108
- Joined: November 4th, 2016, 9:42 pm
Re: .csv problem with libreoffice
It's the character set that it's using to import the .csv.tjh290633 wrote:I'm using LibreOffice 6.0.1.1 and have found that all my .csv files have turned into a single line of apparently Japanese characters...
I can reproduce this effect by right-clicking on a .csv and opening with my LibreOffice 4. The 'Import' screen has a 'character set' choice at the top. When I set it to 'Unicode (UTF-16)' it looks exactly as you describe - a single line of Chinese characters.
The default choice (presumably, as I've never consciously changed this) appears to be 'Western European(Windows-1252/WinLatin 1)'. This works fine as do several others, including UTF-8.
There's apparently no reliable way to determine the encoding used in any particular text document. Seems that in LibreOffice the default encoding used when importing a csv is whatever you set as the character set in the Import dialog last time you used it.
Try opening Calc, use File > Open to open any .csv, set the character set to one that works (try UTF-8) then open it. This should make UTF-8 the default from now on - as suggested here...
https://ask.libreoffice.org/en/question ... onsistent/
-
- Lemon Half
- Posts: 7675
- Joined: November 4th, 2016, 11:20 am
Re: .csv problem with libreoffice
Marvellous! That is exactly what has happened. It must have changed to UTF-16 when it was last upgraded.
Many thanks.
TJH
Many thanks.
TJH
-
- Lemon Quarter
- Posts: 4108
- Joined: November 4th, 2016, 9:42 pm
Re: .csv problem with libreoffice
You're more than welcome - we can't have you (of all people) unable to open your .csv filestjh290633 wrote:Many thanks.
TJH