https://bugs.documentfoundation.org/show_bug.cgi?id=151794

            Bug ID: 151794
           Summary: Validity drop-down shows empty value when 'Allow empty
                    cells' is disabled
           Product: LibreOffice
           Version: 7.4.2.3 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: [email protected]
          Reporter: [email protected]

Description:
In data validity menu 'Allow empty cells' option has no efect (empty values are
present in the pick list). Document opened by Excel behaves properly.

Steps to Reproduce:
1) Data -> Validity -> Allow: Cell range (don't show empty values: 'Allow empty
cells' is disabled)
2) Set 'Source': that contains empty and non-empty cells.


Actual Results:
Data validity drop-down menu contains empty entry.

Expected Results:
Data validity drop-down menu should not contain empty value, when 'Allow empty
cells' is disabled


Reproducible: Always


User Profile Reset: No

Additional Info:
As shown in the attached pictures.

-- 
You are receiving this mail because:
You are the assignee for the bug.

Reply via email to