Skip to content

Spreadsheet validation on datatype=list, values in the dropdown are parsed to numbers #8141

@kendo-bot

Description

@kendo-bot

Bug report

Spreadsheet validation on datatype=list, values in the dropdown are parsed to numbers. Numeric strings are automatically formatted by removing the heading zero.

Reproduction of the problem

Dojo: https://dojo.telerik.com/eOOvKJxL

validation: {
     dataType: "list",
     showButton: true,
     comparerType: "list",
     from: "{ \"001\", \"002\", \"Baz item 3\" }",
     allowNulls: true,
     type: "reject"
 }

The bug is a regression, formatting is different with a 2017 version: https://dojo.telerik.com/sCvgBzBa/5

The regression is introduced in 2020.3.1118 version most probably with this fix #6019

Ticket ID: 1678676
Common package issue: https://github.com/telerik/kendo-spreadsheet-common/issues/110

Environment

**Kendo UI version: 2025.1.211
**Browser: [all]

Metadata

Metadata

Assignees

Labels

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions