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
I'm not sure whether the behavior is expected or a mistake, but it changes depending on whether the "Error Alert" message is activated/checked. In both cases (error alert on or off), the content of the cell can be deleted without getting into edit mode (press [DEL] directly). Not limited to "List". Inherited from OOo.
The actual procedure seems correct to me. Think about what would happen when you set the validation options and the cell range still is empty. You also can skip the validation when you paste an invalid value.
You can't edit the cell content, and leave the cell empty.