kendo-ui-core icon indicating copy to clipboard operation
kendo-ui-core copied to clipboard

Importing a file containing custom data validation and the "@" symbol throws a js error

Open aleksandarevangelatov opened this issue 4 years ago • 1 comments

Bug report

When importing a xlsx file containing custom data validation and the "@" symbol a JavaScript error is thrown.

Reproduction of the problem

Import the this sample file that contains the custom validation formula =ISNUMBER(MATCH("*@*",A1,0)) in the Server Import/Export Demo. The following error is thrown and logged on the developer's console: Can't handle character with code: 64 (input: \"ISNUMBER(MATCH(\"*@*\",A1,0))\")"

Opening the file with the built-in open command works as expected as well as hardcoding the formula - REPL

Expected/desired behavior

Importing a xlsx file containing custom data validation and the "@" symbol should not throw a JavaScript error.

Environment

  • Kendo UI version: 2021.3.1109
  • Browser: [all]

aleksandarevangelatov avatar Nov 24 '21 16:11 aleksandarevangelatov

Not related to the wrappers, can be reproduced in jQuery demos.

gyankov avatar Sep 29 '22 12:09 gyankov

Also reported in 1547431 and 1599082

StoyanGoranov avatar Mar 07 '23 14:03 StoyanGoranov

I am closing this issue as no longer reproducible in jQuery demos with Kendo UI 2023.3.1114. No error is thrown.

sspasova avatar Jan 03 '24 17:01 sspasova