Re: [libreoffice-users] Bug with data validating

At 13:45 22/05/2013 +1200, Steve Edmonds wrote:
> I have found a bug in LO3.6 with data validating. If someone would 
> be kind enough to check if it is resolved in LO4 before I file a bug 
> report and a feature request.
>
> Bug
> To replicate create some data to be the validate list such as
> A1 = cat
> A2 = dog
> A3 = cat2
>
> Now in a cell (A5) enter cat2 and Data>Validity validation from the 
> list A1:A3. In error have Stop and a message, say "invalid value".
> Try to type mouse into the cell, an error message arrives.
> Click on the cell and drag the + down to copy down. cat2 auto 
> increments to cat3 and the data is not checked for validity.

You may not like it, but it's not a bug: it's by design.  The manual 
makes clear that data validation is about validating "new data 
*entered* by a user" (my emphasis).  The help text makes this even 
clearer: "If an invalid value has already been inserted into the 
cell, or if you insert a value in the cell either with drag-and-drop 
or by copying and pasting, the validity rule will not take effect."

Incidentally, if you want dragging down a column like this to carry 
data validation down as it appears you do, you'd need to use A$1:A$3 
as the source range, not A1:A3.

> Contents pasted into a cell with validity checking are also not checked.

Also by design.

At 19:30 21/05/2013 -0700, Steve Edmonds wrote:
> Also, using paste special with format allows you to paste data 
> validation to cells without changing the value (really good) ...

Again, the manual makes clear that "a validity rule is considered 
part of a cell's format".

> ... but doesn't validate data whether it is complying.

See earlier comments.

I trust this helps.

Brian Barker


--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted