Issue 128152 - XOR has been named EXKLUSIV ELLER in Swedish version of Calc
Summary: XOR has been named EXKLUSIV ELLER in Swedish version of Calc
Status: CLOSED FIXED
Alias: None
Product: Native-Lang
Classification: NLC
Component: sv (show other issues)
Version: 4.1.6
Hardware: All All
: P5 (lowest) Normal
Target Milestone: 4.1.12
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2019-07-12 12:23 UTC by Jan-Erik Lärka
Modified: 2022-10-28 12:56 UTC (History)
4 users (show)

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


Attachments
XOR contain a space (46.00 KB, image/png)
2019-07-12 12:23 UTC, Jan-Erik Lärka
no flags Details
test file (changed function name) (31.95 KB, application/vnd.oasis.opendocument.spreadsheet)
2021-10-19 10:00 UTC, Czesław Wolański
no flags Details
relevant screenshots (610.72 KB, image/jpeg)
2021-10-19 10:01 UTC, Czesław Wolański
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
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.