Issue 126819 - XOR function not usable in french
Summary: XOR function not usable in french
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: 4.1.1
Hardware: All All
: P5 (lowest) Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2016-01-31 17:57 UTC by bmarcelly
Modified: 2016-02-03 07:26 UTC (History)
2 users (show)

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


Attachments
XOR formula created in english version of Apache OpenOffice (10.12 KB, application/vnd.oasis.opendocument.spreadsheet)
2016-01-31 18:00 UTC, bmarcelly
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description bmarcelly 2016-01-31 17:57:26 UTC
XOR function was introduced in AOO version 4.0.
In french, this function is named : OU EXCLUSIF

If a spreadsheet is created in english, then loaded in a french AOO, formulas containing this function work, and the formula displays correctly, example:
   =OU EXCLUSIF(A1;A2;A3)

But if in the french AOO you try to write a similar formula, you get Err:509, Missing operator.

In french, all the boolean functions have been translated. Only this one has a name of 2 words separated by a space.
In similar cases, translation uses a dot between the words, example EST.IMPAIR
Comment 1 bmarcelly 2016-01-31 18:00:46 UTC
Created attachment 85270 [details]
XOR formula created in english version of Apache OpenOffice

Use a french version of OpenOffice.
Open this document. The formula works, it is displayed correctly in french.
Try to write the same formula : you get an error.
Comment 2 Andrea Pescetti 2016-02-02 21:18:16 UTC
Can you find relevant strings in Pootle?

https://translate.apache.org/fr/aoo40/

They can be fixed there and then reimported. I agree that "." should be used as separator.
Comment 3 bmarcelly 2016-02-03 07:26:38 UTC
The translation is in : formula\source\core\resource.po  line 40

#: core_resource.src#RID_STRLIST_FUNCTION_NAMES.SC_OPCODE_XOR.string.text
msgid "XOR"
msgstr "OU EXCLUSIF"

I don't have a Pootle account to change it, and don't know how to reimport and verify. Please do it.