On Monday 30 April 2007, + Paul Dom wrote: > [ MODERATED ] *********************** > 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?
As you are not subscribed you may not have seen that: On Wednesday 02 May 2007, TerryJ wrote: > > 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. Please reply to [email protected] only. -- CPH : openoffice.org contributor Maybe your question has been answered already? http://user-faq.openoffice.org/#FAQ --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
