At 23:11 26/08/2012 +0200, Ennio Sr wrote:
>I would rather prefer that warning be fired when an inappropriate 
>value is typed in a cell more than in the cell containing the 
>formula: if a cell is formatted to contain a date, it should not be 
>possible to put a space in it ...

That's fairly easy:
o Select the relevant range of cells.
o Go to Data | Validity... .
o On the Criteria tab, for Allow select Date.
o On the Error Alert tab, tick "Show error message when invalid 
values are entered" and for Action select Stop.

I trust this helps.

Brian Barker


---------------------------------------------------------------------
To unsubscribe, e-mail: ooo-users-unsubscribe@incubator.apache.org
For additional commands, e-mail: ooo-users-help@incubator.apache.org