[upstream] Locale Settings for decimal separator ignored

[Nikolaus Rath]

Openoffice uses "," as a decimal separator, although it should use "." instead.

[0] nokile:~$ locale
LANG=en_GB.UTF-8
LANGUAGE=en_GB:en
LC_CTYPE=de_DE.UTF-8
LC_NUMERIC=en_US.UTF-8
LC_TIME=de_DE.UTF-8
LC_COLLATE=de_DE.UTF-8
LC_MONETARY=de_DE.UTF-8
LC_MESSAGES=en_US.UTF-8
LC_PAPER=de_DE.UTF-8
LC_NAME=de_DE.UTF-8
LC_ADDRESS=de_DE.UTF-8
LC_TELEPHONE=de_DE.UTF-8
LC_MEASUREMENT=de_DE.UTF-8
LC_IDENTIFICATION=en_US.UTF-8
LC_ALL=

[Matthias Klose (doko)]

please could you elaborate?

[Nikolaus Rath (nikratio)]

My locale settings clearly say that 1 and a half has to be printed and entered as "1.5"'. Openoffice ignores this and uses "1,5": So if I enter "1.5" into a spreadsheet, it is treated as a string and I cannot do any computations with it.

(This of course applies to all numbers and not just 1.5)

[Brian Murray (brian-murray)]

Thanks for taking the time to report this bug and helping to make Ubuntu better. With which specific version of the openoffice.org package did you notice this issue? You can check using the command 'dpkg -l openoffice.org'. Thanks in advance.

[Nikolaus Rath (nikratio)]

[0] nokile:~$ dpkg -l openoffice.org
Desired=Unknown/Install/Remove/Purge/Hold
| Status=Not/Installed/Config-files/Unpacked/Failed-config/Half-installed
|/ Err?=(none)/Hold/Reinst-required/X=both-problems (Status,Err: uppercase=bad)
||/ Name Version Description
+++-=====================-=====================-==========================================================
ii openoffice.org 2.2.0-1ubuntu3 OpenOffice.org Office suite

[Ludovic Lebègue (llebegue)]

Seems to be OK in openoffice.org 2.3.0

See attachment for the configuration I use.

 dpkg -l openoffice.org
Desired=Unknown/Install/Remove/Purge/Hold
| Status=Not/Installed/Config-f/Unpacked/Failed-cfg/Half-inst/t-aWait/T-pend
|/ Err?=(none)/Hold/Reinst-required/X=both-problems (Status,Err: uppercase=bad)
||/ Name Version Description
+++-==============-==============-============================================
ii openoffice.org 1:2.3.0-1ubunt OpenOffice.org Office suite

[Jaap Versteegh (j-r-versteegh)]

This issue still exists in Jaunty.
LC_NUMERIC isn't respected.

[Chris Cheney (ccheney)]

Can you please file this upstream bug at http://qa.openoffice.org/issue_handling/pre_submission.html and add the bug number back to this report?

[David Morley (d-morlo)]

Link to upstream bug

[Björn Michaelsen (bjoern-michaelsen)]

No new OOo releases in Ubuntu => WontFix
Possibly moved to LibreOffice => Incomplete (needs upstream bug reference)