<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><span class="vcard"><a class="email" href="mailto:laurentiusilviu@gmail.com" title="laurentiusilviu@gmail.com">laurentiusilviu@gmail.com</a>
</span> changed
<a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - Data validity has problems if input data is changed"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=121619">bug 121619</a>
<br>
<table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>What</th>
<th>Removed</th>
<th>Added</th>
</tr>
<tr>
<td style="text-align:right;">Version</td>
<td>6.1.0.3 release
</td>
<td>6.1.3.2 release
</td>
</tr></table>
<p>
<div>
<b><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - Data validity has problems if input data is changed"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=121619#c3">Comment # 3</a>
on <a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - Data validity has problems if input data is changed"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=121619">bug 121619</a>
from <span class="vcard"><a class="email" href="mailto:laurentiusilviu@gmail.com" title="laurentiusilviu@gmail.com">laurentiusilviu@gmail.com</a>
</span></b>
<pre> You are right, also this behavior as "input" future is also present in
Excel; However, at the same time this situation is strange because if I will
try to change from keyboard the 1 value on Sheet2 with the same number 1
(considering before example), I received an error message "Invalid value" in
situation when in that cell is already filled-in number 1, but because in
Sheet1 the number 1 was changed before with number 3, the number 1 can't be
written in Sheet2 even if it already exists in the same cell. This is without
any logic.
The right behavior, could be to receive a message where I'm informed that
the next cells (A1, A2 ...) from Sheet2, which have the old value inside, will
be changed with the new value, or I can choose to cancel the action and to keep
in the validity list the value before.
Many thanks!</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>