Bug 137246 - Calc Data Validity. Error Message UI Error
Summary: Calc Data Validity. Error Message UI Error
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: x86-64 (AMD64) macOS (All)
: medium minor
Assignee: Not Assigned
Depends on:
Blocks: Cell-Validity
  Show dependency treegraph
Reported: 2020-10-04 16:22 UTC by G
Modified: 2021-02-09 12:28 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:
Regression By:

Calc Data Validity UI Error (183.45 KB, image/png)
2020-10-04 16:28 UTC, G

Note You need to log in before you can comment on or make changes to this bug.
Description G 2020-10-04 16:22:22 UTC
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)

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
Comment 1 G 2020-10-04 16:28:53 UTC
Created attachment 166066 [details]
Calc Data Validity UI Error

Not a mayor UI Error
Comment 2 mrei 2020-10-05 00:39:04 UTC
Reproducible on 6.3.6 High Sierra
Comment 3 mrei 2020-10-11 22:08:25 UTC
This bug is still present in

MacOS High Sierra: 10.13.6
Build ID: d2cf0df6696e42c36b2de4ca5548da6e656f08c5
Comment 4 G 2021-02-05 22:30:58 UTC
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.