[Issue 126981] New: Select Drop Down in Validation Not removing blanks

[bu...@apache.org]

https://bz.apache.org/ooo/show_bug.cgi?id=126981

          Issue ID: 126981
        Issue Type: DEFECT
           Summary: Select Drop Down in Validation Not removing blanks
           Product: Calc
           Version: 4.1.2
          Hardware: PC
                OS: Windows 10
            Status: UNCONFIRMED
          Severity: Minor
          Priority: P5 (lowest)
         Component: ui
          Assignee: issues@openoffice.apache.org
          Reporter: j.johnson.bbt@gmail.com

Created attachment 85550
  --> https://bz.apache.org/ooo/attachment.cgi?id=85550&action=edit
dynamic validation drop down test

When using validation to dynamically filter results for a select list, the
blanks show in the list of results. Someone on the forums noted that this only
happened after 3.2. See here for thread:
https://forum.openoffice.org/en/forum/viewtopic.php?f=9&t=83385

In the attachment, I have it being filtered for "Vegetables". On Sheet2 click
C3 to see the issue happening.

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

[Issue 126981] Select Drop Down in Validation Not removing blanks

[bu...@apache.org]

https://bz.apache.org/ooo/show_bug.cgi?id=126981

bmarcelly <ma...@orange.fr> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |marcelly.bernard@orange.fr

--- Comment #1 from bmarcelly <ma...@orange.fr> ---
Created attachment 85551
  --> https://bz.apache.org/ooo/attachment.cgi?id=85551&action=edit
Simple validity with fixed cell range

The problem is not due to a dynamic contents.
This attachment uses a fixed list in cells A2:A11.
This list contains empty cells, and the term "red" appears two times.

Cell C2 has a validity against A2:A11, option Allow empty cells is not checked,
option sort is not checked. The displayed drop-down list shows all empty lines.

Cell C7 has a validity against A2:A11, option Allow empty cells is not checked,
option sort IS checked. The displayed drop-down list shows only one empty line,
at top, and only one occurrence of the "red" value, since sort option
eliminates duplicates.

The bug is that if option Allow empty cells is NOT checked, there is no reason
to display an empty item !

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

[Issue 126981] Select Drop Down in Validation Not removing blanks

[bu...@apache.org]

https://bz.apache.org/ooo/show_bug.cgi?id=126981

bmarcelly <ma...@orange.fr> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
     Ever confirmed|0                           |1
             Status|UNCONFIRMED                 |CONFIRMED

--- Comment #2 from bmarcelly <ma...@orange.fr> ---
Confirmed

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