Bug 147567

Summary: Excel function SIGN wrongly translated into dutch
Product: LibreOffice Reporter: Larry Poort <larry.poort>
Component: LocalizationAssignee: Not Assigned <libreoffice-bugs>
Status: CLOSED FIXED    
Severity: normal CC: 79045_79045, cno, himajin100000, serval2412, xiscofauli
Priority: medium    
Version: 6.4 all versions   
Hardware: x86 (IA32)   
OS: All   
Whiteboard:
Crash report or crash signature: Regression By:

Description Larry Poort 2022-02-21 08:56:40 UTC 
Description:
When using dutch formulas in Calc using Excel functions, the function POS.NEG (nl-NL) is not recognized as the translation for the formula SIGN (en-EN). 
Libre Office itself translates the function SIGN into TEKEN (which should be used to translate the function CHAR) 

Steps to Reproduce:
1. Open Libre Office Calc using Dutch Language setting
2. Open a new Calc sheet with formula using Calc option `Gebruik Engelse functienamen´ ticked
3. Enter function =SIGN(3)
4. Un-tick option `Gebruik Engelse functienamen´
5. entered function translates into =TEKEN(3)

Actual Results:
=TEKEN(3)
the actual processing is correct. However this should be POS.NEG. 

Expected Results:
=POS.NEG(3)
When entering POS.NEG as a function into the formula it is not recognized


Reproducible: Always


User Profile Reset: Yes


OpenGL enabled: Yes

Additional Info:
Version: 7.3.0.3 / LibreOffice Community
Build ID: 0f246aa12d0eee4a0f7adcefbf7c878fc2238db3
CPU threads: 4; OS: Linux 5.4; UI render: default; VCL: gtk3
Locale: nl-NL (nl_NL.UTF-8); UI: nl-NL
Calc: threaded
Comment 1 Xisco Faulí 2022-02-22 09:52:08 UTC 
@Cor, I thought you might be interested in this issue
Comment 2 Cor Nouws 2022-02-27 21:04:16 UTC 
(In reply to Xisco Faulí from comment #1)
> @Cor, I thought you might be interested in this issue

thanks Xisco, Thanks Larry!
Will be looked at.
Comment 3 Kees Kriek 2022-02-28 07:53:18 UTC 
I changed the Dutch translation into POS.NEG.
It will be changed in the next update of LibreOffice.
Comment 4 Roman Kuznetsov 2022-05-02 13:22:06 UTC 
(In reply to Kees Kriek from comment #3)
> I changed the Dutch translation into POS.NEG.
> It will be changed in the next update of LibreOffice.

So can we close it as FIXED?
Comment 5 Julien Nabet 2022-07-09 14:02:44 UTC 
If it's fixed on Weblate, there's nothing remaining to be done, just wait for synchronization of translation repos with Weblate.
=> FIXED
Comment 6 Kathy Barrera 2023-06-02 07:21:32 UTC 
The Dutch translation was altered to POS.NEG.
It will be changed in the next LibreOffice update. 
build in there:  0f246aa12d0eee4a0f7adcefbf7c878fc2238db3 https://doodle-jump.io
Comment 7 samy 2023-06-06 17:25:20 UTC Comment hidden (spam)