steveedmonds wrote > 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
Also, using past special with format allows you to paste data validation to cells without changing the value (really good) but doesn't validate data whether it is complying. -- View this message in context: http://nabble.documentfoundation.org/Bug-with-data-validating-tp4057249p4057251.html Sent from the Users mailing list archive at Nabble.com. -- 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
