[Libreoffice-bugs] [Bug 131309] Validity>Custom>Formula does not have the expected effect without additional measures - evaluation of entered formula only happens after additional trigger

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=131309

--- Comment #4 from Mike Kaganski <mikekaganski at hotmail.com> ---
(In reply to Wolfgang Jäger from comment #0)
> ... 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

Only answering the cited part.
Since comment 0 had mentioned tdf#130738, it's not quite clear to me why could
you "judge it to be completely useless". tdf#130738 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.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20201208/89fa5025/attachment.htm>