Apache OpenOffice (AOO) Bugzilla – Issue 128152
XOR has been named EXKLUSIV ELLER in Swedish version of Calc
Last modified: 2022-10-28 12:56:59 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
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.
Can it be backported in the next 4.1.7?
(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.
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)
Created attachment 87059 [details] test file (changed function name)
Created attachment 87060 [details] relevant screenshots
+1 for renaming it to XELLER.
Fixed in AOO41X with: https://github.com/apache/openoffice/commit/1e5293583c08fb321afd2000ec8e57f775565280 Note, that the function is now XELLER.