Bug 156432

Summary: Calc data validation: "Allow empty cells" does not work
Product: LibreOffice Reporter: Lenge <Spampot>
Component: CalcAssignee: Not Assigned <libreoffice-bugs>
Status: NEW ---    
Severity: normal CC: iavs.leroy
Priority: medium    
Version: Inherited From OOo   
Hardware: x86-64 (AMD64)   
OS: All   
Whiteboard:
Crash report or crash signature: Regression By:
Bug Depends on:    
Bug Blocks: 108988    

Description Lenge 2023-07-23 18:30:39 UTC 
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
Comment 1 ady 2023-07-23 20:12:43 UTC 
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.
Comment 2 LeroyG 2023-07-23 21:30:18 UTC 
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.
Comment 3 LeroyG 2023-07-23 21:32:54 UTC 
You can't edit the cell content, and leave the cell empty.