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
@Cor, I thought you might be interested in this issue
(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.
I changed the Dutch translation into POS.NEG. It will be changed in the next update of LibreOffice.
(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?
If it's fixed on Weblate, there's nothing remaining to be done, just wait for synchronization of translation repos with Weblate. => FIXED
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
amazing. http://www.winmilliongame.com http://www.gtagame100.com http://www.subway-game.com http://www.clash-games.com