Last Updated: 19 Feb 2021 09:45 by ADMIN
Release R1 2021 SP2
Created on: 05 Nov 2019 17:57
Category: Spreadsheet
Type: Feature Request
RadSpreadsheet: ListDataValidation not working, dropdown does not appear in control

I have implemented the ListDataValidationRule code to add a dropdownlist to the spreadsheet. Based on the code I can find and the searching I have conducted, it seems to be correct, however the dropdown does not appear in the control.

The dropdown list does appear in Excel when I export the file.


Dim Context As ListDataValidationRuleContext = New ListDataValidationRuleContext(CurrentWorksheet, CurrentCellIndex)

Context.InputMessageTitle = "Restricted input"
Context.InputMessageContent = "The input is restricted to the week days."
Context.ErrorStyle = ErrorStyle.Stop
Context.ErrorAlertTitle = "Invalid Bedroom Type"
Context.ErrorAlertContent = "The entered value is not valid."
Context.InCellDropdown = True

Context.Argument1 = String.Join(",", _Data.ArchitectCert_UnitBedrooms.AsEnumerable().Select(Function(x) x.Field(Of Integer)("UnitBedroomNumber").ToString()).ToArray())

Dim Rule As ListDataValidationRule = New ListDataValidationRule(Context)

1 comment
Dess | Tech Support Engineer, Principal
Posted on: 06 Nov 2019 07:34

Hello, Michael, 

Indeed, the drop down is correctly exported in the Excel file: 

However, in RadSpreadsheet it is not currently displayed.

I have logged it in our feedback portal by making this thread public. You can track its progress, subscribe for status changes and add your comments on the following link - feedback item.


I have also updated your Telerik points.

I hope this information helps. If you need any further assistance please don't hesitate to contact me. 

Dess | Tech Support Engineer, Sr.
Progress Telerik

Get quickly onboarded and successful with your Telerik and/or Kendo UI products with the Virtual Classroom free technical training, available to all active customers. Learn More.