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.
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.
Contents pasted into a cell with validity checking are also not checked.
Google sheets marks cells with invalid data with a red corner and error
message. This would be great in LO also
To unsubscribe e-mail to: firstname.lastname@example.org
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
- [libreoffice-users] Bug with data validating · Steve Edmonds
Impressum (Legal Info)
: Unless otherwise specified, all text and images
on this website are licensed under the
Creative Commons Attribution-Share Alike 3.0 License
This does not include the source code of LibreOffice, which is
licensed under the Mozilla Public License (MPLv2
"LibreOffice" and "The Document Foundation" are
registered trademarks of their corresponding registered owners or are
in actual use as trademarks in one or more countries. Their respective
logos and icons are also subject to international copyright laws. Use
thereof is explained in our trademark policy