[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