Description: Error Message UI Error. Steps to Reproduce: 1. On a Column add two values on two rows. Example: CellB1=1.1 & CellB2=1.2 2. On CellA1 create a "Data Validity", with a "Cell range" with Source = B1:B2 3. On CellA1 write "1." (number "1" and a Dot ".") and the hit Option+Down (On Mac, normally, it will display the list, can't remember how to do it on Windows) to pick an option. 4. It will Display the Error Message with the message "Invalid value." and "OK". But at the same time you have the option to pick the correct option, if you do, it won't display it on the CellA1, but when you do hit "OK" on the Error Message it will display the option that you picked. It is Just an UI error, but an Error is an Error, and it can lead to something else. Actual Results: It work as Almost it should. Expected Results: It should not display the Error Message Reproducible: Always User Profile Reset: No Additional Info: MacBook Pro (Retina, 13-inch, Late 2013) MacOS Catalina: 10.15.7 (19H2) LibreOffice Version: 6.4.6.2 Build ID: 0ce51a4fd21bff07a5c061082cc82c5ed232f115 CPU threads: 4; OS: Mac OS X 10.15.7; UI render: GL; VCL: osx; Locale: en-US (en_US.UTF-8); UI-Language: en-US Calc: threaded
Created attachment 166066 [details] Calc Data Validity UI Error Not a mayor UI Error
Reproducible on 6.3.6 High Sierra
This bug is still present in 7.0.3.0.0+ MacOS High Sierra: 10.13.6 LibreOffice Version: 7.0.3.0.0+ Build ID: d2cf0df6696e42c36b2de4ca5548da6e656f08c5
The same issue occurs on Excel. Excel .xls doesn't record this option either. I must be and ".xls" error, not option available to save this. Status Resolved, as this is NOT an issue.