Paul Dom wrote:
>
> I am using OpenOffice 2.2 Dutch version.
> I have a problem of validating a date cell in Calc.
>
> I try to ensure that the value I enter is before 01/01/2007. (Or after a
> certain date.)
> I use the menu Data, Validation and enter Date as content and maximum
> value = 01/01/2007.
> I still can enter any value without seeing the message box I entered for
> unappropriate values.
>
> Is this a bug in Calc? Or do I have to specify the maximum value in a
> certain format?
> Can anyone help me?
>
> Thanks!
>
> Paul Dom
>
>
I must admit I've decided to get by without Data >Validity. After
experimenting with a date, I find that you have to insert the numerical
value of the date which is your maximum or minimum. eg. 31/12/2007 = 39447.
--
View this message in context:
http://www.nabble.com/Data-validation-in-Calc-with-dates-does-not-function-properly-tf3677834.html#a10278979
Sent from the openoffice - users mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
