Issue 62527 - formula fields results change when document language is changed
Summary: formula fields results change when document language is changed
Status: CONFIRMED
Alias: None
Product: Writer
Classification: Application
Component: formatting (show other issues)
Version: OOo 2.0.2
Hardware: PC All
: P3 Trivial with 2 votes (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords: oooqa
Depends on:
Blocks:
 
Reported: 2006-02-24 10:37 UTC by pjentsch
Modified: 2017-05-20 11:19 UTC (History)
2 users (show)

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

Attachments
Sample document with en-UK language setting (7.28 KB, application/vnd.sun.xml.writer)
2006-02-24 10:41 UTC, pjentsch 		no flags Details
Sample document with de_DE language setting (7.25 KB, application/vnd.sun.xml.writer)
2006-02-24 10:42 UTC, pjentsch 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description pjentsch 2006-02-24 10:37:01 UTC 
It's possible to insert text formulas into writer documents.
These formulas may contain number constants with decimal seperators
When the document language is changed, the decimal seperators in the document
will be interpreted according to the new locale setting. Thus, formulas
containing constants will have different results after changing the language. 
This seems wrong. Constants in formulas should be considered numbers, and, as
such, language independent. Changing the document language should change to way
number constants are displayed in formulas, not the formula result.
Comment 1 pjentsch 2006-02-24 10:41:47 UTC 
Created attachment 34430 [details]
Sample document with en-UK language setting
Comment 2 pjentsch 2006-02-24 10:42:10 UTC 
Created attachment 34431 [details]
Sample document with de_DE language setting
Comment 3 michael.ruess 2006-02-24 12:47:49 UTC 
This deals with formula fields, not formula objects. Reassigned to ES.
Comment 4 lars 2006-02-24 19:30:42 UTC 
when I change the document language, the decimal seperator in formula fields 
doesn't change for me, but the result of formulas do: open the second file 
(test_ger), change the document langauage to english (UK), press F9: the 3 
becomes 30. This even seems to be an incorrect calculation. So confirmed with 
680_m156 on WinXP Pro SP2.
Comment 5 eric.savary 2006-03-14 10:17:33 UTC 
ES->OS:
1) changing the document language should change the numbers attributes but not
the result = yes!

2) as Rainner noticed too: I don't understand why changing the language causes
"1,5" to be interpreted as "15" (result is 30). I would rather expect (if we
ignore point 1) ) that "1,5" is intepreted as a string so that the result would
be 0.
Comment 6 Marcus 2017-05-20 11:19:50 UTC 
Reset assigne to the default "issues@openoffice.apache.org".