[Libreoffice-bugs] [Bug 128122] New: CCur doesn't obey to my locale settings

[bugzilla-daemon at bugs.documentfoundation.org]

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 at lists.freedesktop.org
          Reporter: guraknugen at 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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20191013/7c1ad375/attachment.html>