<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 - EDITING: Regression in handling of the group separator in formula context"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=123752">123752</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>EDITING: Regression in handling of the group separator in formula context
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>6.2.0.1 rc
</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>Calc
</td>
</tr>
<tr>
<th>Assignee</th>
<td>libreoffice-bugs@lists.freedesktop.org
</td>
</tr>
<tr>
<th>Reporter</th>
<td>bugz.j@tukesoft.com
</td>
</tr></table>
<p>
<div>
<pre>Calc version 6.2 introduced a regression with a possibility of data corruption.
This affects locales where the grouping separator is not comma.
Steps to reproduce:
1) use a locale like fi_FI for the document
2) enter a value like 12345,67 into a worksheet cell
3) pick a number format like "# ##0,00" for the cell
4) copy the cell to clipboard
5) enter another cell, type a starting = and paste
The result is Err:509 in the target cell and the pasted value has an extra zero
before the decimal separator, i.e. =123450,67
If the worksheet with such an error is closed and then reopened, the error
status gets cleared but the value in the target cell is the one with an extra
zero.
This happens with both the provided Windows binary (6.2.0.3) and a Linux
version (6.2.1.1) compiled from source.
If the originating cell has a format with no group separator or if the group
separator of the locale is comma, everything works like before.
The reason behind the regression appears to be an incomplete fix to <a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED FIXED - No warning when wrong decimal separators are used, resulting in bad outcome for formulas in tables"
href="show_bug.cgi?id=42518">bug 42518</a>,
since reverting commits 673bd16887c354981120f7ebea44b25b0ab2e41e and
9336286a7ea5385541344f444e6f8702c85bdacb is enough to build a binary without
the regression.</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>