Hi.
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.
Contents pasted into a cell with validity checking are also not checked.

Feature.
Google sheets marks cells with invalid data with a red corner and error message. This would be great in LO also

steve

--
To unsubscribe e-mail to: [email protected]
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

Reply via email to