Issue 62643 - Numeric values in userfields handled inconsistently in multilingual environments
Summary: Numeric values in userfields handled inconsistently in multilingual environments
Status: CONFIRMED
Alias: None
Product: Writer
Classification: Application
Component: formatting (show other issues)
Version: OOo 2.0.2
Hardware: PC Windows XP
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords: oooqa
Depends on:
Blocks:
 
Reported: 2006-02-28 12:32 UTC by pjentsch
Modified: 2017-05-20 11:22 UTC (History)
2 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---


Attachments
Document with language setting "de_DE", containing a userfield (6.95 KB, application/vnd.sun.xml.writer)
2006-02-28 12:33 UTC, pjentsch
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description pjentsch 2006-02-28 12:32:24 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)"
Comment 1 pjentsch 2006-02-28 12:33:08 UTC
Created attachment 34509 [details]
Document with language setting "de_DE", containing a userfield
Comment 2 michael.ruess 2006-02-28 13:28:54 UTC
Reassigned to ES.
Comment 3 lars 2006-02-28 18:21:19 UTC
confirmed with OOo 2.0.2 RC4 on WinXP Pro SP2; but this seems to be a duplicate 
of your own issue 62527
Comment 4 pjentsch 2006-02-28 18:25:37 UTC
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. 
Comment 5 eric.savary 2007-01-12 12:58:56 UTC
ES->OS: maybe a duplicate of issue 62527.
Comment 6 Marcus 2017-05-20 11:22:44 UTC
Reset assigne to the default "issues@openoffice.apache.org".