Validation Custom, how to use ?

Under Validation Data, there is on the Criteria tab, Allow Custom option, and field to insert Formula.

Does anyone know how to use it?

Any example in use ?

image description

Help says nothing about it:

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

Just use any formula that returns a value that maps to FALSE (0) or TRUE (non-0).

Hello @Mike Kaganski, it is possible to post an example, my attempts nothing happens.

Schiavinatto ( 2020-02-17 15:43:29 +0100 )edit

Example of what? E.g., if you are checking validity of cell A1, you could use ISNUMBER(A1). Better tell attempts to do what is failing?

Mike Kaganski ( 2020-02-17 15:48:42 +0100 )edit

Beggining in what LibreOffice version?

LeroyG ( 2020-06-19 01:49:30 +0100 )edit

Mike Kaganski ( 2020-06-19 06:08:42 +0100 )edit

2 followers

Asked: 2020-02-17 15:04:34 +0100

Seen: 217 times

Last updated: Feb 17 '20