What is the point of Data->Validation->Ignore Blank?

[Vindaloo]

Hi,

I need to make a particular cell a required entry between 1 and 10.
This cell must not be blank. I would have thought that this would be
achieved by
- Setting the Data Validation to Allow="whole number",
data="between", minimum="1", maximum="10"
- Clearing the checkbox "Ignore Blank"

Part 1 works fine, e.g. it gives an error if I enter "11"

However I can go to the cell, delete the contents and it doesn't give
an error. My question therefore is what is the point of the "Ignore
Blank" checkbox if point 2 doesn't prevent the cell from being left
blank?

I've no problem achieving the desired result programmatically, so I'm
not after an alternate solution, I'd just like to know whether this is
a bug or whether this checkbox has a different use.

I've searched for similar posts regarding this checkbox but couldn't
find a definite answer.

Thanks,
Vindaloo

 

[Bob Phillips]

Unchecking ignore blank does not allow you to clear the field with the
Backspace key, but it doesn't stop it being cleared by the Delete key. That
seems like a bug to me, but there may be a reason that I am not aware of.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[Vindaloo]

Thanks for your reply, I'd put my money on it being a bug too.

Regards,
Vindaloo