<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><span class="vcard"><a class="email" href="mailto:joaoemanuel1981@gmail.com" title="joaoemanuel1981@gmail.com">joaoemanuel1981@gmail.com</a>
</span> changed
<a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED INVALID - Cell validation allowing a blank cell even with the option unchecked"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=142568">bug 142568</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;">Resolution</td>
<td>---
</td>
<td>INVALID
</td>
</tr>
<tr>
<td style="text-align:right;">Status</td>
<td>UNCONFIRMED
</td>
<td>RESOLVED
</td>
</tr></table>
<p>
<div>
<b><a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED INVALID - Cell validation allowing a blank cell even with the option unchecked"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=142568#c3">Comment # 3</a>
on <a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED INVALID - Cell validation allowing a blank cell even with the option unchecked"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=142568">bug 142568</a>
from <span class="vcard"><a class="email" href="mailto:joaoemanuel1981@gmail.com" title="joaoemanuel1981@gmail.com">joaoemanuel1981@gmail.com</a>
</span></b>
<pre>(In reply to Uwe Auer from <a href="show_bug.cgi?id=142568#c2">comment #2</a>)
<span class="quote">> (In reply to joaoemanuel1981 from <a href="show_bug.cgi?id=142568#c0">comment #0</a>)
> > Cell validation allowing a blank cell even with the option unchecked. And
> > with that, a cell that has defined validation and with the blank cell option
> > unchecked may exist, something that should not be allowed, if the option was
> > working.
>
> According to LibreOffice help page [1] the option about "empty cells / blank
> cells" (documentation inaccuracy here) seems to be designed to have a
> different meaning than one may expect. This option assures, if used in
> conjunction with "Tools - Detective - Mark invalid Data", being marked as
> invalid data. It seems not to be designed to cause an "invalid data" error
> message (popup).
>
>
> [1] LibreOffice Help - Criteria:
> <a href="https://help.libreoffice.org/latest/en-US/text/scalc/01/12120100">https://help.libreoffice.org/latest/en-US/text/scalc/01/12120100</a>.
> html?&DbPAR=CALC&System=UNIX</span >
Well if you need Detective for that, then I'll close the bug. However, they
could change this mentality of using the Detective and put the popup window.
Thanks for the reply.</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>