Last Updated: 06 Nov 2020 15:19 by ADMIN
Created on: 14 Sep 2020 14:57
Category: Spreadsheet
Type: Bug Report
Cell Validation DataType list: insert numbers instead of text values



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

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}',


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:


Best regards,

1 comment
Posted on: 15 Sep 2020 09:09

Hello Gerd,

Thank you for the report. I am converting this to a bug report as currently the value "1,2,3,4,5" cannot be evaluated as numeric type in the Kendo Spreadsheet. 

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