https://bugs.documentfoundation.org/show_bug.cgi?id=156432
Bug ID: 156432 Summary: Calc data validation: "Allow empty cells" does not work Product: LibreOffice Version: 7.5.5.2 release Hardware: x86-64 (AMD64) OS: Windows (All) Status: UNCONFIRMED Severity: normal Priority: medium Component: Calc Assignee: libreoffice-bugs@lists.freedesktop.org Reporter: spam...@gmx.net Description: 1. Select a cell 2. Select Data\Validity... 3. Set the following Criteria: * Allow: List * Unselect "Allow empty cells" * Entries: Enter the allowed values (e. g. A, B, and C) 4. Press OK 5. Enter an allowed value into the cell (e. g. A) 6. Now empty the cell (click it, press "DEL" and then "Return") Error: The empty cell is accepted (although switched off in step 3). Steps to Reproduce: (see description) Actual Results: Empty cells are allowed although they shouldn't. Expected Results: Empty cells should be rejected (just as any non-empty value that is not in the list). Reproducible: Always User Profile Reset: Yes Additional Info: Version: 7.5.5.2 (X86_64) / LibreOffice Community Build ID: ca8fe7424262805f223b9a2334bc7181abbcbf5e CPU threads: 8; OS: Windows 6.3 Build 9600; UI render: Skia/Raster; VCL: win Locale: de-DE (de_DE); UI: en-US Calc: threaded -- You are receiving this mail because: You are the assignee for the bug.