Re: [libreoffice-users] Bug with data validating

Steve, 4.0.3.3 on Fedora 18

Enter cat2 in A5 - no error
Change cat2 to moose and the error appears. Cell changes back to cat2
Drag cat2 down into A6. This becomes cat3 and no error appears
Change cat3 in A6 to mouse and the error appears

If I enter mouse into A7, copy and paste into A5 the validation rules 
are lost

HTH

On 05/22/2013 11:45 AM, Steve Edmonds 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
>
> steve


--
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