5
Every time I open a CSV (comma separated values) document in OpenOffice.org Calc I get a dialog with CSV preferences.
The current default character set is "Eastern Europe (ISO-8859-2)".
I would like "UTF-8" to be selected by default instead.
user14944
Posted 2010-03-15T12:06:54.627
Reputation: 171
2
The problem was in LC_ settings in my system. It was set to:
LANG="cs_CZ"
which probably defaults to ISO-8859-2. After altering this to:
cat /etc/env.d/02locale
...
LANG="cs_CZ.UTF-8"
...
env-update && source /etc/profile
reboot # just to be sure
Everything is ok. CSV defaults to UTF-8.
user14944
Posted 2010-03-15T12:06:54.627
Reputation: 171
0
I think this is controlled by your Locale Settings.
For me CSV files default to UTF-8
In Tools > Options > Language Settings > Languages.
My Locale is set to default. My Language is set to English (UK)
The Locale of the PC is English (UK)
Richard Holloway
Posted 2010-03-15T12:06:54.627
Reputation: 1 129
I tried this too, but no luck. Locale setting, User interface, Default languages for documents - Western. All set to English (UK). – user14944 – 2010-03-16T09:07:00.337
I am running OOo 3.1.1 on Ubuntu Linux. I do not know if that makes a difference. Perhaps you are on an older version or you have found a bug! – Richard Holloway – 2010-03-16T10:24:55.593
I am running OO-3.2.0 on Gentoo. It's strange that OO honors LC_ settings instead it's own settings. Anyway, I posted solution which worked for me. Thanks for your time Richard. – user14944 – 2010-03-17T12:14:19.570
http://forum.openoffice.cz/viewtopic.php?pid=4574#p4574 -> The same question in Czech (posted by me, answered by myself). Just to let Google know these questions are related. – user14944 – 2010-03-17T12:16:46.317