<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body>
<p>
<div>
<b><a class="bz_bug_link
bz_status_NEW "
title="NEW - EDITING: Regression in handling of the group separator in formula context"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=123752#c3">Comment # 3</a>
on <a class="bz_bug_link
bz_status_NEW "
title="NEW - EDITING: Regression in handling of the group separator in formula context"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=123752">bug 123752</a>
from <span class="vcard"><a class="email" href="mailto:erack@redhat.com" title="Eike Rathke <erack@redhat.com>"> <span class="fn">Eike Rathke</span></a>
</span></b>
<pre>Entering a formula it was never guaranteed to accept group separators in values
(as in many locales the group separator also is the parameter separator ',').
It may have worked by chance in some locales that use a NO-BREAK SPACE as group
separator, but already using an ordinary SPACE character instead made that
attempt fail; or if parameter separator was set to ';' a group separator of ','
may have worked.
I can investigate why an extra zero is added in
12345,67 => =123450,67
of the original description (fi-FI locale).
But in an en-US locale with default ',' parameter separator things like
1,000 => 1,0
are logical because it is parsed as
number 1 separator , number 0
Certainly the result of SUM(1,234) shall not be 1234 but 235 instead..
This was not different in earlier versions.</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>