I have a problem in the XamSpreadsheet regarding dropdowns. I created a small prototype to reproduce the problem.
Both, the prototype and the excel-file that needs to be loaded into the application I put as an attachement to this post.

Steps in Excel:

Open the dropdown in any Cell of Column B:

• 500 Test-entries are shown.

Steps in the sample-WPF-program with the XamSpreadsheet /community/cfs-file/__key/communityserver-discussions-components-files/1041/SpreadsheetMinimalPrototype.zip :

• Start the program.
• Click on the top left (Button “LOAD”) to load the excel-workbook.
• Open the dropdown in any Cell of Column B:
• 10000 entries are shown (500 Test-entries + blank entries).

Sample-Configuration in the Excel-Attachment (already done, just for informational purposes /community/cfs-file/__key/communityserver-discussions-components-files/1041/DropdownExample.xlsx):

Column A with 500 Entries

Select column B (or a single cell) -> Data -> DataValidation (under Data Tools) -> Settings ->

• Allow: List
• Ignore blank: checked
• In-cell dropdown: checked
• Source: =$A$2:$A$10000
• 10000 to keep the flexibility of extending the list, since blank cells should be ignored

So my question is now: Why is it showing the blank entries in the XamSpreadsheet-Dropdown, that I configured to be ignored? How can I remove them from the dropdown-list to make the dropdown usable?

Thanks!