Bug#301203: openoffice.org: oocalc (possibly others, too) does not respect LC_TIME, _NUMERIC, but uses LC_MESSAGES instead
Package: openoffice.org
Version: 1.1.3-8
Severity: important
OpenOffice.org Calc ignores *at least* the following environment variables:
LC_TIME and LC_NUMERIC, when deciding how to represent dates and decimal
numbers. It, however, uses the value of LC_MESSAGES to decide this. I think
this must be a policy violation since LC_MESSAGES should just affect menu
languages and such, not how to represent "1/7" in decimal or January 3rd 2005
in numeric format.
Example:
LC_MESSAGES=en_GB.ISO-8859-15 LC_TIME=fi_FI@euro LC_NUMERIC=fi_FI@euro oocalc
Then type 2.2.2 into a cell, and you get 2/2/2 instead of 2.2.2 like you should.
The same happens with typing "=1/4", which produces 0.25 instead of 0,25 as the
Finnish locale would require.
Changing LC_MESSAGES to a finnish one, too, fixes both representations, but has
the side-effect of changing the menus to ununderstandable finglish (this is,
of course, what it should do).
-- System Information:
Debian Release: 3.1
APT prefers unstable
APT policy: (999, 'unstable')
Architecture: i386 (i686)
Kernel: Linux 2.6.10+juhaj+v1.8+iproute-fix-refcount-patch
Locale: LANG=C, LC_CTYPE=fi_FI@euro (charmap=ISO-8859-15)
Versions of packages openoffice.org depends on:
ii dictionaries-common [openoffi 0.25.0 Common utilities for spelling dict
ii openoffice.org-bin 1.1.3-8 OpenOffice.org office suite binary
ii openoffice.org-debian-files 1.1.3-8+1 Debian specific parts of OpenOffic
ii openoffice.org-l10n-en [openo 1.1.3-8 English (US) language package for
ii openoffice.org-l10n-fi [openo 1.1.3-8 Finnish language package for OpenO
ii ttf-opensymbol 1.1.3-8 The OpenSymbol TrueType font
ii xml-core 0.09 XML infrastructure and XML catalog
-- no debconf information
Reply to: