Issue 126981 - Select Drop Down in Validation Not removing blanks
Summary: Select Drop Down in Validation Not removing blanks
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: ui (show other issues)
Version: 4.1.2
Hardware: PC Windows 10
: P5 (lowest) Minor (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2016-05-21 09:20 UTC by Jeremiah Johnson
Modified: 2016-05-22 07:43 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
dynamic validation drop down test (7.99 KB, application/vnd.oasis.opendocument.spreadsheet)
2016-05-21 09:20 UTC, Jeremiah Johnson 		no flags Details
Simple validity with fixed cell range (11.64 KB, application/vnd.oasis.opendocument.spreadsheet)
2016-05-22 07:42 UTC, bmarcelly 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description Jeremiah Johnson 2016-05-21 09:20:21 UTC 
Created attachment 85550 [details]
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.
Comment 1 bmarcelly 2016-05-22 07:42:21 UTC 
Created attachment 85551 [details]
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 !
Comment 2 bmarcelly 2016-05-22 07:43:10 UTC 
Confirmed