https://bugs.documentfoundation.org/show_bug.cgi?id=128122
Bug ID: 128122
Summary: CCur doesn't obey to my locale settings
Product: LibreOffice
Version: 6.2.7.1 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: BASIC
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: guraknu...@gmail.com
>From LibreOffice Help:
”CCur Function
Converts a string expression or numeric expression to a currency expression.
The locale settings are used for decimal separators and currency symbols.”
My locale is Swedish, so my currency is ”kr” and my decimal symbol is a comma.
Yet, the CCur function doesn't accept anything else than a decimal point and
with no currency symbol at all:
Print CCur("75,50 kr") ⇨ Illegal value or data type. Wrong data type.
Print CCur("75.50 kr") ⇨ Illegal value or data type. Wrong data type.
Print CCur("75,50") ⇨ 7550.0000
Print CCur("75.50") ⇨ 75.5000
If I create a dialogue with a currency field in it, and enter 75, the result is
”75,00 kr”, which is correct for my locale.
So either the function doesn't work properly or the help text is wrong.
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
