Inconistent behavior of the Spreadsheet list validation when the from option contains empty space #7913
Description
Bug report
When attempting to validate a cell value against a predefined finite list, the validation process fails to recognize valid entries that are present in the list. Instead, it incorrectly flags them as invalid. The issue occur when there is an empty space before the first value in the 'from' option.
Reproduction of the problem
- Run the Dojo - https://dojo.telerik.com/@NeliK/icizisEF
Current behavior
On the first row, the 'YES' in the B1 cell is marked as invalid although it is present in the list with the valid values. the difference between row 1 and row 4 is the empty space in the validation from configuration:
"from": "{ \"YES\", \"NO\"}", //row 1
"from": "{\"YES\", \"NO\"}" //row 4
Expected/desired behavior
The empty space added in the from configuration option should not affect the validation. If the cell value is present in the list, it should be marked as valid.
The issue is a regression starting with 2020.3.1118
Environment
- Kendo UI version: 2024.2.514
- Browser: [all]