Ask Your Question

Calc validiy allow date strange behavior?

asked 2020-04-01 12:51:34 +0100

pcl gravatar image

Hi to all

I've set validity date (data->validity->allow date) to a range of cells in Calc.

I've also set 'data greater than 30/12/1899'.

Now there are no problems if I enter any dates like 31/03/2020; but if I enter a function like




I get an "invalid value" message.

It seems a strange behavior because both functions return a date.

Why? Am I wrong?

I'm using Version: Build ID: 1:6.4.2-0ubuntu0.18.04.3

Thanks in advance for replying

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2020-04-01 13:01:12 +0100

keme gravatar image

Data validation is meant for entered (static) data, not for (dynamic) calculation results. If you need to check your calculation results for validity, you must embed validity check in your formula, or use conditional formatting.

If you want to enter static data by a calculated formula, use F9 to do the calculation before pressing enter.

edit flag offensive delete link more


/me learns something new. Thanks for the F9 trick!

Mike Kaganski gravatar imageMike Kaganski ( 2020-04-01 13:05:29 +0100 )edit

Also thanks! I didn't know that. It even works for formulas previously (in advance of editing and using the F9-wand) entered explicitly for array-evaluation (and needing it).
F2 F9 Enter

Lupp gravatar imageLupp ( 2020-04-01 13:26:06 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2020-04-01 12:51:34 +0100

Seen: 56 times

Last updated: Apr 01 '20