This is a migrated thread and some comments may be shown as answers.

Data Validation List Rule didn't work.

3 Answers 83 Views
Spreadsheet
This is a migrated thread and some comments may be shown as answers.
özer
Top achievements
Rank 2
Veteran
Iron
özer asked on 25 Dec 2020, 11:46 AM

Hi. 

I tried to do the same for the example in this article, but there was no drop-down list. It also did not accept the values on the list.

CellIndex dataValidationRuleCellIndex = new CellIndex(0, 0);
  
ListDataValidationRuleContext context = new ListDataValidationRuleContext(worksheet, dataValidationRuleCellIndex);
context.InputMessageTitle = "Restricted input";
context.InputMessageContent = "The input is restricted to the week days.";
context.ErrorStyle = ErrorStyle.Stop;
context.ErrorAlertTitle = "Wrong value";
context.ErrorAlertContent = "The entered value is not valid. Allowed values are the week days!";
context.InCellDropdown = true;
context.Argument1 = "Monday, Tuesday, Wednesday, Thursday, Friday, Saturday, Sunday";
  
ListDataValidationRule rule = new ListDataValidationRule(context);
  
worksheet.Cells[dataValidationRuleCellIndex].SetDataValidationRule(rule);

 

 

 

3 Answers, 1 is accepted

Sort by
0
Accepted
Martin
Telerik team
answered on 28 Dec 2020, 02:33 PM

Hello özer,

Thank you for the feedback.

I am sorry to hear you are experiencing issues due to currently not supported functionality. We have an item logged in our backlog to provide it: RadSpreadsheet: ListDataValidation not working, dropdown does not appear in control. You can cast your vote for the implementation as well as subscribe to the task by clicking the Follow button so you can receive updates when its status changes.

I hope you find this information helpful. Do not hesitate to contact us if any additional questions arise.

Regards,
Martin
Progress Telerik

Virtual Classroom, the free self-paced technical training that gets you up to speed with Telerik and Kendo UI products quickly just got a fresh new look + new and improved content including a brand new Blazor course! Check it out at https://learn.telerik.com/.

0
özer
Top achievements
Rank 2
Veteran
Iron
answered on 29 Dec 2020, 12:38 AM
[quote]Martin said:

Hello özer,

Thank you for the feedback.

I am sorry to hear you are experiencing issues due to currently not supported functionality. We have an item logged in our backlog to provide it: RadSpreadsheet: ListDataValidation not working, dropdown does not appear in control. You can cast your vote for the implementation as well as subscribe to the task by clicking the Follow button so you can receive updates when its status changes.

I hope you find this information helpful. Do not hesitate to contact us if any additional questions arise.

Regards,
Martin
Progress Telerik

Virtual Classroom, the free self-paced technical training that gets you up to speed with Telerik and Kendo UI products quickly just got a fresh new look + new and improved content including a brand new Blazor course! Check it out at https://learn.telerik.com/.

[/quote]

Hi Martin.

Thanks for the answer. I subscribed to the feedback item. But I guess no improvement has been made, although more than a year has passed.

0
Accepted
Nadya | Tech Support Engineer
Telerik team
answered on 29 Dec 2020, 01:57 PM

Hello, özer,

Currently, this feature is not implemented yet. I would like to note that we understand the importance of this feature request. However, have in mind that we strive to consider our customers' demand when planning the new features for the upcoming releases. In other words, the more votes an item gathers, the higher its priority becomes. Make sure that you vote for the item.

Let me know if there is anything else I can help with.

Regards,
Nadya
Progress Telerik

Virtual Classroom, the free self-paced technical training that gets you up to speed with Telerik and Kendo UI products quickly just got a fresh new look + new and improved content including a brand new Blazor course! Check it out at https://learn.telerik.com/.

Tags
Spreadsheet
Asked by
özer
Top achievements
Rank 2
Veteran
Iron
Answers by
Martin
Telerik team
özer
Top achievements
Rank 2
Veteran
Iron
Nadya | Tech Support Engineer
Telerik team
Share this question
or