Apache OpenOffice (AOO) Bugzilla – Issue 62643
Numeric values in userfields handled inconsistently in multilingual environments
Last modified: 2017-05-20 11:22:44 UTC
I have OOo2.0RC2 with german and english language pack installed on WinXP with german locale. The chosen UI language for OOo is "English (UK)" The attached document contains a userfield with a numeric value of "1.23". The language setting saved with the document is "german". The current locale setting is default, which resolves to "german" because of my german WinXP installation. The value is thus shown as "1,23" actual behaviour: a) if I change the language setting for the current document to "English (UK)", the displayed value of the field gets correctly updated to "1.23". When choose "Extras->Update->Fields", the value *incorrectly* changes to "123". b) if I try to correct the change value "123" back up "1.23" (double-click on field, enter value in dialog "Edit Fields: Variables"), entering "1,23", the value keeps getting reset to "123". c) If I try to correct the value entering "1.23" the value gets set to "44927". To set the value back to "1.23", I have to enter "001.23", which gets reset to "123" when I reopen the document. d) when I open the document, change the locale setting from "default" to "English (UK)", and then change the language setting (Extras-Options->Language Settings->Languages->Default language for document->Western) to "english (uk)", the same as in a) happens e) when I close the document, change the locale setting to "English (UK)", then open the document and *then* change the language setting for the current document to "English (UK)", the field correctly keeps its value, and the display gets correctly updated to "1.23" (from "1,23"). expected behaviour: - the locale setting should determine how values entered in a dialog are interpreted - changing language or locale setting should change the display of values but have no influence whatsoever on the values themselves. c) is a regression from OOo 1.1.4, which correctly intreprets "1.23" as "1.23" when the locale settings are set to "English (UK)"
Created attachment 34509 [details] Document with language setting "de_DE", containing a userfield
Reassigned to ES.
confirmed with OOo 2.0.2 RC4 on WinXP Pro SP2; but this seems to be a duplicate of your own issue 62527
It's related, but it's not a duplicate. The first issue concerns formulas, and formulas are stored as strings in OOo. This issue concerns userfields, which can handle different datatypes (string, double and date). I guess I should file a seperate issue for c), because it's a regression (works for me in OOo 1.1.4) and deals with *entering* values, not calculating or displaying values.
ES->OS: maybe a duplicate of issue 62527.
Reset assigne to the default "issues@openoffice.apache.org".