Unplanned
Last Updated: 15 Sep 2020 09:09 by ADMIN
n/a
Created on: 14 Sep 2020 14:57
Category: Spreadsheet
Type: Bug Report
1
Cell Validation DataType list: insert numbers instead of text values

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,

1 comment
ADMIN
Ianko
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. 

Regards,
Ianko
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/.