Set CSV import default to UTF-8 in Calc

8,214

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.

Share:
8,214
user14944
Author by

user14944

Updated on September 17, 2022

Comments

  • user14944
    user14944 about 1 year

    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
    user14944 over 13 years
    I tried this too, but no luck. Locale setting, User interface, Default languages for documents - Western. All set to English (UK).
  • user14944
    user14944 over 13 years
    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
    user14944 over 13 years
    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.