https://bugs.documentfoundation.org/show_bug.cgi?id=147567
Bug ID: 147567
Summary: Excel function SIGN wrongly translated into dutch
Product: LibreOffice
Version: 6.4 all versions
Hardware: x86 (IA32)
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
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
--
You are receiving this mail because:
You are the assignee for the bug.
