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+unsubscr...@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