Ask Your Question
2

Validation Custom, how to use ?

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

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
1

answered 2020-02-17 15:34:52 +0100

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

edit flag offensive delete link more

Comments

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

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

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?

See also https://ask.libreoffice.org/en/question/225447/calc-how-to-specify-formula-for-custom-data-validity/

tdf#130738

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

Beggining in what LibreOffice version?

LeroyG gravatar imageLeroyG ( 2020-06-19 01:49:30 +0100 )edit
1
Login/Signup to Answer

Question Tools

2 followers

Stats

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

Seen: 217 times

Last updated: Feb 17 '20