Issue 128152

Summary: XOR has been named EXKLUSIV ELLER in Swedish version of Calc
Product: Native-Lang Reporter: Jan-Erik Lärka <janerik.larka>
Component: svAssignee: AOO issues mailing list <issues>
Status: CLOSED FIXED QA Contact:
Severity: Normal    
Priority: P5 (lowest) CC: czeslaw.wolanski, mseidel, oooforum, simon.tp.duthoit
Version: 4.1.6   
Target Milestone: 4.1.12   
Hardware: All   
OS: All   
See Also: https://bz.apache.org/ooo/show_bug.cgi?id=126819
Issue Type: DEFECT Latest Confirmation in: 4.1.11
Developer Difficulty: ---
Attachments:
Description Flags
XOR contain a space
none
test file (changed function name)
none
relevant screenshots none

Description Jan-Erik Lärka 2019-07-12 12:23:46 UTC
Created attachment 86714 [details]
XOR contain a space

XOR function was introduced in AOO version 4.0 of Calc.
In Swedish this function is named: EXKLUSIVT ELLER

If you try to write a the formula by hand, you get Err:509, Missing operator.

Only this one has a name of 2 words separated by a space.
In similar cases, translation uses a dot between the words, such as SUMMA.OM for SUMIF
Comment 1 Matthias Seidel 2019-07-12 13:10:14 UTC
Fixed in Pootle now:
https://translate.apache.org/sv/aoo40/translate/formula/source/core/resource.po#unit=14294737

These fixes will be imported into AOO 4.2.0.

If you want to follow progress you can always try my test builds:
https://home.apache.org/~mseidel/AOO-builds/AOO-420-Test/Full%20Installation/

Beware:
The recent changes will not be visible before we do the next export from Pootle to the source code and do a build afterwards.
Comment 2 oooforum (fr) 2019-09-19 10:27:21 UTC
Can it be backported in the next 4.1.7?
Comment 3 Matthias Seidel 2020-07-13 14:38:05 UTC
(In reply to oooforum (fr) from comment #2)
> Can it be backported in the next 4.1.7?

Sorry, 4.1.x will not get translation updates.

But it would be good if someone can confirm it fixed in Swedish 42X so we can close this issue.
Comment 4 Czesław Wolański 2021-10-19 09:59:29 UTC
This seems to be a case analogous to the French XOR
(Issue 126819 - XOR function not usable in french).

1. Test with the 4.1.11 version
The faulty string "EXKLUSIVT ELLER" can be found in the file:

\program\resource\forsv.res

"EXKLUSIVT ELLER" changed to "EXKLUSIVT.ELLER" works fine in
the 4.1.11 version (cf. the attached test file and screenshot).


2. Test with the 4.2 version
Works correctly.
The file created with the 4.1.11 works correctly too.


3. Name of the function
The AOO Swedish community might consider a handier name
for the exclusive OR: "XELLER".

See e.g. Excel
https://support.microsoft.com/sv-se/office/xeller-funktionen-xeller-1548d4c2-5e47-4f77-9a92-0533bba14f37 

or LibreOffice (7.1.6.2).


----------------------------------

Configuration:

1. Windows 7, 64-bit, Home Premium
2. AOO:
   - 4.1.11 en-US (full) + sv (language pack)
   - 4.2 en-US (full), sv (full)
Comment 5 Czesław Wolański 2021-10-19 10:00:46 UTC
Created attachment 87059 [details]
test file (changed function name)
Comment 6 Czesław Wolański 2021-10-19 10:01:39 UTC
Created attachment 87060 [details]
relevant screenshots
Comment 7 Matthias Seidel 2021-10-19 10:02:19 UTC
+1 for renaming it to XELLER.
Comment 8 Matthias Seidel 2021-10-19 11:10:40 UTC
Fixed in AOO41X with:
https://github.com/apache/openoffice/commit/1e5293583c08fb321afd2000ec8e57f775565280

Note, that the function is now XELLER.