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.
