Unplanned
Last Updated: 11 Jul 2024 08:58 by ADMIN
Jeremy
Created on: 10 Jul 2024 15:21
Category: Spreadsheet
Type: Feature Request
1
ListDataValidation dropdown does not appear in control.

I'm having the same issue that was fixed in the Telerik UI for WinForms RadSpreadsheet. When loading the workbook into a Blazor UI TelerikSpreadsheet control, the validation dropdown shows fine when exported to Excel but the Telerik control doesn't show the dropdown. However, it only allows you to type values in the supplied validation list as expected.

RadSpreadsheet: ListDataValidation not working, dropdown does not appear in control (telerik.com)

ListDataValidationRuleContext context = new(worksheet, ri, ci)
{
  InputMessageTitle = "Restricted input",
  InputMessageContent = "The input is restricted to the week days.",
  ErrorStyle = ErrorStyle.Stop,
  ErrorAlertTitle = "Wrong value",
  ErrorAlertContent = "The entered value is not valid. Allowed values are the week days!",
  InCellDropdown = true,
  Argument1 = "Monday, Tuesday, Wednesday, Thursday, Friday, Saturday, Sunday"
};

cell.SetDataValidationRule(new ListDataValidationRule(context));
2 comments
ADMIN
Dimo
Posted on: 11 Jul 2024 08:58

Hi Jeremy,

OK, I converted your ticket to a public item and voted for it on your behalf. I must admit that currently the validation is partially supported and we are not aware of a workaround. I am sorry if this missing functionality is causing trouble for your users. 

Regards,
Dimo
Progress Telerik

Stay tuned by visiting our public roadmap and feedback portal pages! Or perhaps, if you are new to our Telerik family, check out our getting started resources!
Jeremy
Posted on: 10 Jul 2024 22:22
If possible, this ticket can be converted into a public bug report. I missed that option when creating the ticket.