You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@openoffice.apache.org by bu...@apache.org on 2016/01/31 18:57:26 UTC

[Issue 126819] New: XOR function not usable in french

https://bz.apache.org/ooo/show_bug.cgi?id=126819

          Issue ID: 126819
        Issue Type: DEFECT
           Summary: XOR function not usable in french
           Product: Calc
           Version: 4.1.1
          Hardware: All
                OS: All
            Status: CONFIRMED
          Severity: Normal
          Priority: P5 (lowest)
         Component: code
          Assignee: issues@openoffice.apache.org
          Reporter: marcelly@club-internet.fr

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

-- 
You are receiving this mail because:
You are the assignee for the issue.

[Issue 126819] XOR function not usable in french

Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=126819

Matthias Seidel <ms...@apache.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Latest|4.1.11-dev                  |4.1.11
    Confirmation in|                            |

-- 
You are receiving this mail because:
You are the assignee for the issue.

[Issue 126819] XOR function not usable in french

Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=126819

--- Comment #3 from bmarcelly <ma...@club-internet.fr> ---
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.

-- 
You are receiving this mail because:
You are the assignee for the issue.

[Issue 126819] XOR function not usable in french

Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=126819

Matthias Seidel <ms...@apache.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
   Target Milestone|4.2.0                       |4.1.12

-- 
You are receiving this mail because:
You are the assignee for the issue.

[Issue 126819] XOR function not usable in french

Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=126819

Czesław Wolański <cz...@gmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |czeslaw.wolanski@gmail.com

--- Comment #4 from Czesław Wolański <cz...@gmail.com> ---
Created attachment 87055
  --> https://bz.apache.org/ooo/attachment.cgi?id=87055&action=edit
Results of test

-- 
You are receiving this mail because:
You are the assignee for the issue.

[Issue 126819] XOR function not usable in french

Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=126819

Matthias Seidel <ms...@apache.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Latest|---                         |4.1.11-dev
    Confirmation in|                            |

-- 
You are receiving this mail because:
You are the assignee for the issue.

[Issue 126819] XOR function not usable in french

Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=126819

Andrea Pescetti <pe...@apache.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |pescetti@apache.org

--- Comment #2 from Andrea Pescetti <pe...@apache.org> ---
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.

-- 
You are receiving this mail because:
You are the assignee for the issue.

[Issue 126819] XOR function not usable in french

Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=126819

--- Comment #6 from Matthias Seidel <ms...@apache.org> ---
Fixed in AOO41X with:
https://github.com/apache/openoffice/commit/38b43223e9b56ce67a590a719ee817a0841de072

Note, that the function is now OUX, like in trunk/AOO42X (Pootle).

I will be doing Test Builds. If the fix is confirmed we can close this issue.

-- 
You are receiving this mail because:
You are the assignee for the issue.

[Issue 126819] XOR function not usable in french

Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=126819

bmarcelly <ma...@club-internet.fr> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |marcelly@club-internet.fr

--- Comment #1 from bmarcelly <ma...@club-internet.fr> ---
Created attachment 85270
  --> https://bz.apache.org/ooo/attachment.cgi?id=85270&action=edit
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.

-- 
You are receiving this mail because:
You are the assignee for the issue.

[Issue 126819] XOR function not usable in french

Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=126819

--- Comment #7 from Matthias Seidel <ms...@apache.org> ---
Test Builds (for Windows) can be found here:
https://home.apache.org/~mseidel/AOO-builds/AOO-4112-Test/

-- 
You are receiving this mail because:
You are the assignee for the issue.

[Issue 126819] XOR function not usable in french

Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=126819

Matthias Seidel <ms...@apache.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
         Resolution|---                         |FIXED
             Status|CONFIRMED                   |RESOLVED

--- Comment #8 from Matthias Seidel <ms...@apache.org> ---
Fixed now.

-- 
You are receiving this mail because:
You are the assignee for the issue.

[Issue 126819] XOR function not usable in french

Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=126819

Matthias Seidel <ms...@apache.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
   Target Milestone|---                         |4.2.0

-- 
You are receiving this mail because:
You are the assignee for the issue.

[Issue 126819] XOR function not usable in french

Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=126819

--- Comment #5 from Czesław Wolański <cz...@gmail.com> ---
Confirmed with the version 4.1.10

A simple test - the faulty function name "OU EXCLUSIF" is located in the file:

\program\resource\forfr.res

I replaced it with "OU.EXCLUSIF" and verified the behaviour in AOO 4.1.10.
It works (cf. the attachment).

-- 
You are receiving this mail because:
You are the assignee for the issue.

[Issue 126819] XOR function not usable in french

Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=126819

Matthias Seidel <ms...@apache.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |mseidel@apache.org

-- 
You are receiving this mail because:
You are the assignee for the issue.