<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>Bug ID</th>
<td><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - CCur doesn't obey to my locale settings"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=128122">128122</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>CCur doesn't obey to my locale settings
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>6.2.7.1 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>All
</td>
</tr>
<tr>
<th>OS</th>
<td>All
</td>
</tr>
<tr>
<th>Status</th>
<td>UNCONFIRMED
</td>
</tr>
<tr>
<th>Severity</th>
<td>normal
</td>
</tr>
<tr>
<th>Priority</th>
<td>medium
</td>
</tr>
<tr>
<th>Component</th>
<td>BASIC
</td>
</tr>
<tr>
<th>Assignee</th>
<td>libreoffice-bugs@lists.freedesktop.org
</td>
</tr>
<tr>
<th>Reporter</th>
<td>guraknugen@gmail.com
</td>
</tr></table>
<p>
<div>
<pre>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.</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>