From LibreOffice Help:
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.
I can confirm with Version: 184.108.40.206.alpha0+
Build ID: 9b5dad13b56bdde7c40970351af3da3a2c3c9350
CPU threads: 4; OS: Linux 4.15; UI render: default; VCL: x11;
I don't think it's a bug, because ccur should be compatible with VBA (or it's VBA function).
So then the manual is wrong (”The locale settings are used for decimal separators and currency symbols”, but they are clearly not). Should I report that in a separate bug report for the documentation?
Let's repurpose this existing report