<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body>
<p>
<div>
<b><a class="bz_bug_link
bz_status_NEW "
title="NEW - Validity>Custom>Formula does not have the expected effect without additional measures - evaluation of entered formula only happens after additional trigger"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=131309#c4">Comment # 4</a>
on <a class="bz_bug_link
bz_status_NEW "
title="NEW - Validity>Custom>Formula does not have the expected effect without additional measures - evaluation of entered formula only happens after additional trigger"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=131309">bug 131309</a>
from <span class="vcard"><a class="email" href="mailto:mikekaganski@hotmail.com" title="Mike Kaganski <mikekaganski@hotmail.com>"> <span class="fn">Mike Kaganski</span></a>
</span></b>
<pre>(In reply to Wolfgang Jäger from <a href="show_bug.cgi?id=131309#c0">comment #0</a>)
<span class="quote">> ... I first noticed that the Validity feature
> got the new Allow:>Custom>Formula variant.
>
> ... I judge it to be completely useless; 'Cell range' option
> always allowed to enter a formula, and this is sufficiently made clear
> there</span >
Only answering the cited part.
Since <a href="show_bug.cgi?id=131309#c0">comment 0</a> had mentioned <a class="bz_bug_link
bz_status_NEW "
title="NEW - Validity: Custom option documentation is missing"
href="show_bug.cgi?id=130738">tdf#130738</a>, it's not quite clear to me why could
you "judge it to be completely useless". <a class="bz_bug_link
bz_status_NEW "
title="NEW - Validity: Custom option documentation is missing"
href="show_bug.cgi?id=130738">tdf#130738</a> links to two Q&As with
explanation what "Custom" is for; and it's sufficiently different from "Cell
range". The latter is used to provide a *list of allowed values*. The "Custom"
is for an arbitrary formula that returns TRUE or FALSE that is the result of
validity check. E.g., it can check if the value matches some regex. IIUC thic
can't be accomplished using 'Cell range' formula.</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>