Implement Telerik.Web.Spreadsheet for .Net Core

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]

### Bug report

Starting with version 2024.4.1112, the built-in PDF export of the Spreadsheet throws a client-side error when the sheet contains an image.

### Reproduction of the problem

1) Open the Images demo: https://demos.telerik.com/aspnet-core/spreadsheet/images

2) Export the sheet to PDF.

3) An error is logged in the browser console: "Uncaught TypeError: n.Image is not a constructor".

The last working version is 2024.3.1015.

### Expected/desired behavior

PDF export must work as expected.

### Environment

* **Kendo UI version: 2024.4.1112
* **jQuery version: 3.7.1
* **Browser: [all]

Bug report

Reproduction of the problem

1. Download the excel file attached in Ticket ID: 1469596
2. Open it in the Spreadsheet.
3. Filter a column, for example the "Anatomy" column, deselect all and leave only "Abdo".
4. Filter another column, for example Timepoint Name. Deselect all and select only V31. Note that this value does not match any "Abdo" row. Because of that, in Excel "V31" is not even available in the filter, once the "Anatomy" column is filtered by "Abdo". In the Spreadsheet the second column can be filtered by "V31".

Current behavior

No data is displayed after filtering the second column (expected), but the header is duplicated.

Additional notes: the file has been tested against the Open XML SDK tool and it reports 4 issues related to Fonts, however, the duplication occurs even after modifying the original file and applying an arbitrary font and font-size to the whole document, so that it passes the tool's verification successfully.

Expected/desired behavior

No data is displayed and there is no header duplication.

Environment

• Kendo UI version: 2020.2.607
• jQuery version: x.y
• Browser: [all]

when I copy cell from other spreadsheet or current spreadsheet or excel and paste to the spreadsheet. the datasource of the speadsheet not changed!