Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing |
Summary: | Select Drop Down in Validation Not removing blanks | ||||||||
---|---|---|---|---|---|---|---|---|---|
Product: | Calc | Reporter: | Jeremiah Johnson <j.johnson.bbt> | ||||||
Component: | ui | Assignee: | AOO issues mailing list <issues> | ||||||
Status: | CONFIRMED --- | QA Contact: | |||||||
Severity: | Minor | ||||||||
Priority: | P5 (lowest) | CC: | marcelly.bernard | ||||||
Version: | 4.1.2 | ||||||||
Target Milestone: | --- | ||||||||
Hardware: | PC | ||||||||
OS: | Windows 10 | ||||||||
Issue Type: | DEFECT | Latest Confirmation in: | --- | ||||||
Developer Difficulty: | --- | ||||||||
Attachments: |
|
Description
Jeremiah Johnson
2016-05-21 09:20: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 !
Confirmed |