OpenOffice 1.1.1 starts & installs in German on English

[user unknown]

LANG='C' isn't canadian, which is 'en_CA' or 'fr_CA'.
C is the special exception and means the language of the programming language C - greetings to Kerninghan & Ritchie at this point - AFAIK, since their language is the default OS language, which should be 'en_US'. But again not sure.

If someones manpages are broken, here is a link to online-manpages:

http://www.rt.com/man/

Craig2: are you waiting on some kind of ok?
I would try it this way.

[Craig2]

LANG='C' isn't canadian, which is 'en_CA' or 'fr_CA'.
C is the special exception and means the language of the programming language C - greetings to Kerninghan & Ritchie at this point - AFAIK, since their language is the default OS language, which should be 'en_US'. But again not sure.

If someones manpages are broken, here is a link to online-manpages:

http://www.rt.com/man/

Craig2: are you waiting on some kind of ok?
I would try it this way.

I must have missed something. Or forgot what I was doing. What should I be trying?

I stopped for a while, and forgot where I was. I have this file open:

#!/bin/bash
PROGRAM_PATH=/opt/openoffice/program
CHECKMEM=""

# Show logo in background
SCREEN="$(xdpyinfo | awk '/dimensions/{print $2; exit 0}')"
X="$(expr ${SCREEN%%x*} / 2 - 235)"
Y="$(expr ${SCREEN##*x} / 2 - 160)"

# Quick visual feedback
xloadimage -quiet -geometry 0x0+$X+$Y -delay 140 /opt/openoffice/program/soffice-startup.gif >/dev/null 2>&1 &
xpid="$!"

[ -x /usr/bin/checkmem ] && CHECKMEM="/usr/bin/checkmem 80"

# Language/Locale settings
[ -z "$LANG" -a -e /etc/sysconfig/i18n ] && . /etc/sysconfig/i18n
export LANG
USELANGUAGE="${LANG%%@*}"
USELANGUAGE="${USELANGUAGE%%_*}"
case "$USELANGUAGE" in
de|ch|at)
USELOCALE=de-DE
;;
nl)
USELOCALE=nl-NL
;;
C)

And suspect that the USELOCALE=de-DE and USELOCALE=nl-NL may have something to do with the problem, but again, I could be wrong. I can't remember where this file came from when I opened it, so I'm going to look for it in a little while, or try and find which shell I used to run kwrite when I opened it, and check the bash history to see the name of the file.

If this file is the problem, can I just change the entry to USELOCALE=en-EN, and what do I do with the following 5 lines? Or the one above USELOCALE=de-DE? Anyone have this file with english settings that they can post for me to look at?

As for waiting, I really wasn't waiting. I spent a lot of time looking for other files or settings from my bash shell, and then I went through every setting and every applicaton in the kde desktop start menu that I could try to find a path or language setting that wasn't correct. Everything is correct from what I see. I've also been googling for hours trying to find something, but no luck there either. If I didn't think this would help someone else, I wouldn't waste any more time on this. I'll just use OpenOffice on Windows on someone else's computer for now, as much as it kills me to say that. In the next few weeks I'll have a hard disk install of Sarge, and it won't be an issue anymore, I'll be able to use apt to uninstall/install whatever necessary. I'll stop my post here because what I was going to write next was going to be out of sheer frustration.

[Craig2]

btw, my man pages are in english, for both the knoppix user, and craig2. In an earlier post, someoone (my friend in Berlin?) said that the man pages would be useless to me because they're in German. They are not, they are English.

I'm not having a problem with anything else that I can think of regarding language. Just OOo.

And a reminder, the file I found in /etc, called language-de, and having the following inside:

# #!/bin/sh -- This should not be executed, but sourced.
# This file was installed by the package user-de and contains the
# settings for German speaking users

# If you just want Umlauts and accents (also in Mutt), but all the
# messages in English then uncomment the following entry.
#LC_MESSAGES=en_GB.UTF-8
#export LC_MESSAGES

# This sets the locale to German/Germany.
# You might want to try de_AT etc. instead
LANG=de_DE.UTF-8
export LANG
# If you want a German GNOME Desktop as well, you also have to set
# LANG=de_DE.UTF-8 in /etc/environment, which is a good idea anyway!!!

# If you should prefer English manpages
# then uncomment the following two lines.
#MANOPT='-L english'
#export MANOPT

Anyone with the English settings inside, or a file called language-en in /etc and no language-de in /etc, can you post the exact name of file, and the contents, if you have a working OOo in English on Knoppix 3.4?

I tried a locate for language-en, but that came up empty.

I'm going to run an updatedb now, so I'm signing off for now.

tia.

[user unknown]

# Language/Locale settings
[ -z "$LANG" -a -e /etc/sysconfig/i18n ] && . /etc/sysconfig/i18n
export LANG
USELANGUAGE="${LANG%%@*}"
USELANGUAGE="${USELANGUAGE%%_*}"
case "$USELANGUAGE" in
de|ch|at)
  USELOCALE=de-DE
  ;;
nl)
  USELOCALE=nl-NL
  ;;
C)

well - this script reads /etc/sysconfig/i18n.
We had that topic. Your settings seem to be fine.
The quote of the script ends, where it would be interesting.
Is there a 'USELOCALE' followed by the C) ?
And is there a section
en) following, with different content than the C) section?

Another idea: Your installation-program is invoked from a kde-menu?
Perhaps this is linked to a installation-script, and passing a parameter like 'LANG=de'...
I'm not running kde, so I can't search for the name of this menuentry, and for the location of the entry 'edit menu'.

[Craig2]

Another idea: Your installation-program is invoked from a kde-menu?
Perhaps this is linked to a installation-script, and passing a parameter like 'LANG=de'...
I'm not running kde, so I can't search for the name of this menuentry, and for the location of the entry 'edit menu'.

I'll check the first part of your post in a few minutes. The installation program has been tried from the kde kicker panel the first time for knoppix user, was invoked the first time for craig2 from a bash shell while in craig2's home directory (where there were earlier OOo641, OOo1.0.3 and whatever else I listed earlier, dot configuration files). I also tried invoking from a shell with knoppix a second time after deleting the configuration file installed for 1.1.1 So it's installing in German whether from a kde icon on the kicker panel, or from a command line. I may have even tried installing from the start button, or applications button in the programs menu of kde. I may not, so I'm thinking of trying that now. Let me review the first part of your post first though.

[Craig2]

ok, it was cut off because of the limit on posting length. I'll post the rest in a few entries:

export LANG
USELANGUAGE="${LANG%%@*}"
USELANGUAGE="${USELANGUAGE%%_*}"
case "$USELANGUAGE" in
de|ch|at)
USELOCALE=de-DE
;;
nl)
USELOCALE=nl-NL
;;
C)
USELOCALE=en-US
;;
*)
USELOCALE="${LANG%%@*}"
USELOCALE="${USELOCALE/_/-}"
[ -z "$USELOCALE" ] && USELOCALE="en-US"
USELANGUAGE="${USELOCALE%%-*}"
;;
esac

# Check if we ever started OpenOffice before. Call setup if not.
if [ ! -e "$HOME"/.sversionrc ]; then

AUTOSETUP=""
[ -f "$PROGRAM_PATH/autosetup.conf" ] && AUTOSETUP="-R:$PROGRAM_PATH/autosetup.conf"

# Call auto-setup
echo "Running OpenOffice for the first time: Calling auto-setup" >&2
$CHECKMEM "$PROGRAM_PATH"/setup $AUTOSETUP || exit 1

LOCALOFFICE=$(awk '/^OpenOffice\.org/{dir=substr($0,match($0,"file://")+7)}END{gsub(/[\n\r]/,"",dir);print dir}' $HOME/.sversionrc 2>/dev/null)

# Change language settings
# Partly adopted from the Debian OpenOffice.org-debian-files package
echo "Running OpenOffice for the first time: Setting up locales and dictionaries" >&2
mkdir -p "$LOCALOFFICE/user/registry/data/org/openoffice/Office"

# Kill registration wizard (license already axxepted with network install)
echo '<?xml version="1.0" encoding="UTF-8"?>
<oor:component-data xmlnsor="http://openoffice.org/2001/registry" xmlnss="http://www.w3.org/2001/XMLSchema" oor:name="Common" oorackage="org.openoffice.Office">
<node oor:name="Internal">
<prop oor:name="CurrentTempURL" oor:type="xs:string">
<value/>
</prop>
</node>
<node oor:name="Help">
<node oor:name="Registration">
<prop oor:name="ReminderDate" oor:type="xs:string">
<value xsi:nil="true"/>
</prop>
<prop oor:name="RequestDialog" oor:type="xs:int">
<value>0</value>
</prop>
</node>
</node>
<node oor:name="Misc">
<prop oor:name="FirstRun" oor:type="xs:boolean">
<value>false</value>
</prop>
</node>
</oor:component-data>' > "$LOCALOFFICE/user/registry/data/org/openoffice/Office/Common.xcu"

# Locales
echo '<?xml version="1.0" encoding="UTF-8"?>
<oor:component-data xmlnsor="http://openoffice.org/2001/registry" xmlnss="http://www.w3.org/2001/XMLSchema" oor:name="Linguistic" oorackage="org.openoffice.Office">
<node oor:name="SpellChecking">
<prop oor:name="IsSpellAuto" oor:type="xs:boolean">
<value>true</value>
</prop>
</node>
<node oor:name="ServiceManager">
<node oor:name="HyphenatorList">
<prop oor:name="de-DE" oorp="replace" oor:type="xs:string">
<value>org.openoffice.lingu.LibHnjHyphenator</value>
</prop>
<prop oor:name="de-AT" oorp="replace" oor:type="xs:string">
<value>org.openoffice.lingu.LibHnjHyphenator</value>
</prop>
<prop oor:name="en-US" oorp="replace" oor:type="xs:string">
<value>org.openoffice.lingu.LibHnjHyphenator</value>
</prop>
<prop oor:name="nl-NL" oorp="replace" oor:type="xs:string">
<value>org.openoffice.lingu.LibHnjHyphenator</value>
</prop>
</node>
<node oor:name="LastFoundHyphenators">
<prop oor:name="de-DE" oorp="replace" oor:type="oor:string-list">
<value>org.openoffice.lingu.LibHnjHyphenator</value>
</prop>
<prop oor:name="de-AT" oorp="replace" oor:type="oor:string-list">
<value>org.openoffice.lingu.LibHnjHyphenator</value>
</prop>
<prop oor:name="en-US" oorp="replace" oor:type="oor:string-list">
<value>org.openoffice.lingu.LibHnjHyphenator</value>
</prop>
<prop oor:name="nl-NL" oorp="replace" oor:type="oor:string-list">
<value>org.openoffice.lingu.LibHnjHyphenator</value>
</prop>
</node>
<node oor:name="LastFoundSpellCheckers">
<prop oor:name="de-DE" oorp="replace" oor:type="oor:string-list">
<value>org.openoffice.lingu.MySpellSpellChecker</value>
</prop>
<prop oor:name="de-AT" oorp="replace" oor:type="oor:string-list">
<value>org.openoffice.lingu.MySpellSpellChecker</value>
</prop>
<prop oor:name="en-US" oorp="replace" oor:type="oor:string-list">
<value>org.openoffice.lingu.MySpellSpellChecker</value>
</prop>
<prop oor:name="it-IT" oorp="replace" oor:type="oor:string-list">
<value>org.openoffice.lingu.MySpellSpellChecker</value>
</prop>
<prop oor:name="nl-BE" oorp="replace" oor:type="oor:string-list">
<value>org.openoffice.lingu.MySpellSpellChecker</value>
</prop>
<prop oor:name="nl-NL" oorp="replace" oor:type="oor:string-list">
<value>org.openoffice.lingu.MySpellSpellChecker</value>
</prop>
</node>
<node oor:name="LastFoundThesauri">
<prop oor:name="de-DE" oorp="replace" oor:type="oor:string-list">
<value>org.openoffice.lingu.basic.Thesaurus</value>
</prop>
<prop oor:name="en-US" oorp="replace" oor:type="oor:string-list">
<value>org.openoffice.lingu.basic.Thesaurus</value>
</prop>
</node>
<node oor:name="SpellCheckerList">
<prop oor:name="de-DE" oorp="replace" oor:type="oor:string-list">
<value>org.openoffice.lingu.MySpellSpellChecker</value>
</prop>
<prop oor:name="de-AT" oorp="replace" oor:type="oor:string-list">
<value>org.openoffice.lingu.MySpellSpellChecker</value>
</prop>
<prop oor:name="en-US" oorp="replace" oor:type="oor:string-list">
<value>org.openoffice.lingu.MySpellSpellChecker</value>
</prop>
<prop oor:name="nl-BE" oorp="replace" oor:type="oor:string-list">
<value>org.openoffice.lingu.MySpellSpellChecker</value>
</prop>
<prop oor:name="nl-NL" oorp="replace" oor:type="oor:string-list">
<value>org.openoffice.lingu.MySpellSpellChecker</value>
</prop>
</node>
<node oor:name="ThesaurusList">
<prop oor:name="de-DE" oorp="replace" oor:type="oor:string-list">
<value>org.openoffice.lingu.basic.Thesaurus</value>
</prop>
<prop oor:name="en-US" oorp="replace" oor:type="oor:string-list">
<value>org.openoffice.lingu.basic.Thesaurus</value>
</prop>
</node>
</node>
<node oor:name="General">
<prop oor:name="DefaultLocale" oor:type="xs:string">
<value>'"${USELOCALE}"'</value>
</prop>
<node oor:name="DictionaryList">
<prop oor:name="ActiveDictionaries" oor:type="oor:string-list">
<value>soffice.dic sun.dic IgnoreAllList</value>
</prop>
</node>
</node>
</oor:component-data>' > "$LOCALOFFICE/user/registry/data/org/openoffice/Office/Linguistic.xcu"

# Language
echo '<?xml version="1.0" encoding="UTF-8"?>
<oor:component-data xmlnsor="http://openoffice.org/2001/registry" xmlnss="http://www.w3.org/2001/XMLSchema" oor:name="Setup" oorackage="org.openoffice">
<node oor:name="Office">
<prop oor:name="ooSetupInstallPath" oor:type="xs:string">
<value>'"$LOCALOFFICE"'/user</value>
</prop>
</node>
<node oor:name="Configuration">
<prop oor:name="TransferUserSettingsOnce" oor:type="xs:boolean">
<value>false</value>
</prop>
</node>
<node oor:name="L10N">
<prop oor:name="ooLocale" oor:type="xs:string">
<value>'"$USELOCALE"'</value>
</prop>
</node>
</oor:component-data>' > "$LOCALOFFICE/user/registry/data/org/openoffice/Setup.xcu"

# End autoinstall
fi

# Font bug workaround for OpenOffice 1.0
[ -z "$LOCALOFFICE" ] && LOCALOFFICE=$(awk '/^OpenOffice\.org/{dir=substr($0,match($0,"file://")+7)}END{gsub(/[\n\r]/,"",dir);print dir}' $HOME/.sversionrc 2>/dev/null)
[ -e "$LOCALOFFICE/user/psprint/pspfontcache" ] && rm -f "$LOCALOFFICE/user/psprint/pspfontcache"

# Start openoffice
echo "Starting OpenOffice.org." >&2
( exec $CHECKMEM "$PROGRAM_PATH"/soffice "$@" & )
sleep 5
i=0; while [ "$i" -lt 120 ]; do sleep 2; xwininfo -root -tree | grep -q 'OpenOffice.org '; [ "$?" = "0" ] && break; i=`expr $i + 2`; done
kill $xpid 2>/dev/null
exit 0

[Craig2]

I believe that's all of the rest of it. It starts about ten lines above where you were interested, so the very beginning is missing, but can be seen at my earlier post.

[user unknown]

It looks as if there are preparations for english.
You could consider changing the first lines to avoid installing a german version again, and exit the script, like this:

case "$USELANGUAGE" in
de|ch|at)
#USELOCALE=de-DE
exit
;;
nl)
#USELOCALE=nl-NL
exit 
;;

[Markus]

Do you actually have the english language package for openoffice?

sh-2.05b$ COLUMNS=160 dpkg -l|grep -w en
ii  myspell-en-us                      20030813-3                         English (US) dictionary for myspell
ii  openoffice.org-help-en             1.1+20030814-3                     OpenOffice.org office suite help (English)
ii  openoffice.org-hyphenation-en-us   20030813-3                         English (US) hyphenation pattern for OpenOffice.org
ii  openoffice.org-l10n-en             1.1.1-2                            English (US) language package for openoffice.org
ii  trans-de-en                        1.3-3                              A German-English translation dictionary

sh-2.05b$ locate openoffice.org |grep -w en

Should also give some output.