[Libreoffice-bugs] [Bug 128122] BASIC CCur function docs need to be corrected regarding locale settings

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Wed Jan 20 12:22:18 UTC 2021


https://bugs.documentfoundation.org/show_bug.cgi?id=128122

--- Comment #9 from Andreas Heinisch <andreas.heinisch at yahoo.de> ---
Tested with MS-Excel using a German locale, where the group separator is "."
and the decimal separator is "," respectively:

MsgBox CCur("75,50 €") ' 75.5
MsgBox CCur("75.50 €") ' 7550
MsgBox CCur("75,50") ' 75.5
MsgBox CCur("75.50") ' 7550

Same examples in LO using a German locale:

MsgBox CCur("75,50 €") ' Illegal value or data type. Wrong data type.
MsgBox CCur("75.50 €") ' Illegal value or data type. Wrong data type.
MsgBox CCur("75,50") ' 7550.0000
MsgBox CCur("75.50") ' 75.5000

-- 
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/20210120/12247b25/attachment-0001.htm>


More information about the Libreoffice-bugs mailing list