Forums Ultimate UI for WPF
Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
Close
Tomas B
925
XamSpreadsheet shows empty entries in cell validation
posted

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!