Completed
Last Updated: 03 Jan 2024 17:53 by ADMIN
Jyothi
Created on: 24 Nov 2021 16:20
Category: Spreadsheet
Type: Bug Report
2
Importing a file containing custom data validation and the "@" symbol throws a js error

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]
0 comments