Bug#274210: openoffice.org: locales clash with ODBC driver

["Pascal A. Dupuis" <Pascal.Dupuis@esat.kuleuven.ac.be>]

Package: openoffice.org
Version: 1.1.2-4
Severity: normal
Tags: l10n

Hello,

my setup:
LANG=fr_BE@euro 

steps: launch openoffice. New spreadsheet, select data source: ODBC
connection to external dB. Perform some query: all float numbers are
truncated.

workaround:
LC_ALL=C openoffice
same steps: float numbers come along with the right decimals

Explanation:

under LANG=fr_BE@euro, the decimal separator is ',' UnixODBC doesn't
seem to care about locales, and uses '.' as decimal separator. So the
result parsed from openoffice choke and truncate the decimal part.

Changes:
1) for the user: use 'C' as locales. Document it.
2) within openoffice: 
  a) have an option in the ODBC setup screen: 
	is the driver locales aware yes/no ?
  b) detect if the ODBC driver as locales support
If required, perform internally the locales conversion.

Best regards

Pascal Dupuis

-- System Information:
Debian Release: 3.1
  APT prefers testing
  APT policy: (500, 'testing')
Architecture: i386 (i686)
Kernel: Linux 2.6.8.1
Locale: LANG=fr_BE@euro, LC_CTYPE=fr_BE@euro

Versions of packages openoffice.org depends on:
ii  dictionaries-common [openo 0.22.40sarge3 Common utilities for spelling dict
ii  openoffice.org-bin         1.1.2-4       OpenOffice.org office suite binary
ii  openoffice.org-debian-file 1.1.2-4+1     Debian specific parts of OpenOffic
ii  openoffice.org-l10n-en [op 1.1.2-4       English (US) language package for 
ii  openoffice.org-l10n-fr [op 1.1.2-4       French language package for OpenOf
ii  openoffice.org-l10n-nl [op 1.1.2-4       Dutch language package for OpenOff
ii  ttf-opensymbol             1.1.2-4       The OpenSymbol TrueType font

-- no debconf information