incubator-ooo-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Brian Barker <>
Subject Re: #VALUE! warning in spreadsheet
Date Sun, 26 Aug 2012 21:39:13 GMT
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:
For additional commands, e-mail:

View raw message