Data Validation List Rule didn't work.

[özer]

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);

 

 

 

[Martin]

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

[özer]

[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

[/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.

[Nadya | Tech Support Engineer]

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