Hello,

I have some problems with setting up correct Cell Validation for my use-case. I want to create a list validation which is going to have a numeric options instead of typical string values.

So in order to achieve that I created a following cell validation:

{
    dataType: "list",
    showButton: true,
    comparerType: "list",
    from: '{1,2,3,4,5}',
    allowNulls: true,
    type: "reject"
}

Everything works fine in the widget, but the problems starts when I want to Export the following spreadsheet to Excel format. I'm getting the following message when trying to open such file:

In the past I had a similar problem with the list validation (but for string values) (https://www.telerik.com/account/support-tickets/view-ticket/1381434)

There you suggested to create a validation using different format for "from" property. So I decided to change it from:

from: '{1,2,3,4,5}',

to

from: '"1,2,3,4,5"',

After that I can freely export the spreadsheet without any problems, but then my list is inserting string values instead of numeric ones, therefore this solution is not suitable for my use-case.


And my question is: Is there a possibility to create a Cell validation where I can put numeric values as a possible options without breaking the export process? 

Here's a example spreadsheet, which I used to reproduce this behavior: https://dojo.telerik.com/IfuMIbic

Best regards,