[Bug 160506] Possibility to Find and Replace on Validity Formulas

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Mon Aug 5 11:40:54 UTC 2024


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

--- Comment #3 from ady <adylo811517 at gmail.com> ---
FWIW, IMHO, Validity (aka Validation), Custom Condition format, and any other
place in which formulas could be used, should be at least considered as an
alternative addition to the areas in which F&R could be optionally searching
on.

OTOH, there could be a misinterpretation of the meaning/intention of these
items. ATM, the items "Formulas" and "Values" refer to either the cell's
formula, or their results, respectively. But then, if there are other items
such as Validity (or CF for example), what would be the search acting on?

For example, in the case of a Validity > List, you would be searching on the
content of the list. But if we have Validity > Custom, using a formula, would
the search be performed on the custom formula, or instead, on its result? Or
both? Or, should there be two separate items to search on, "Validity
(formula)", and "Validity (values)"?

BTW, I mentioned a similar feature as a side-note in the ticket requesting an
"All" item (in addition to "formulas", "values" and "comments").

-- 
You are receiving this mail because:
You are on the CC list for the bug.


More information about the Libreoffice-ux-advise mailing list