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]

The Speadsheet Component doesn't support importing of Charts which are part of the imported Excel files.

Please implement this feature to allow the use of Excel files which contain Charts in the Spreadsheet.

I raised a support ticket for the spreadsheet control regarding performance and was asked to make a feature request. I'm running a Monte Carlo simulation in a relatively simple spreadsheet. I need to recalculate a cell value (which references other cells including a random function in a formula) and enter that in a new cell. The process is repeated 500 times so I have 500 new numbers. This is nearly instant in Excel desktop and online. In the telerik control each time I get the value of the cell and set it to the new cell it takes 1-2 seconds. Setting the new cell refreshes the one referencing the random number. The routine can take over 10 minutes to run. If I run in a batch job the cell with the random number is not recalculated so I have the same number 500 times. I need to be able to recalculate the cell without the overhead of updating the layout.  

Introduction to Monte Carlo simulation in Excel
https://support.microsoft.com/en-us/office/introduction-to-monte-carlo-simulation-in-excel-64c0ba99-752a-4fa8-bbd3-4450d8db16f1

Expose a "bind-to" TagHelper attribute. Similar to the HTML Helper Spreadsheet counterpart.

Bug report

When applying data validation to all cells of a xlsx file and trying to import the file via Telerik.Web.Spreadsheet as demonstrated in the Server Import/Export demo the application will crash.

Reproduction of the problem

1. Check ticket 1661158 for a sample xlsx file.
   N.B. The sample file has an AnyValidation rule applied to all cells and a title set for the cells. In addition two columns have predefined styling rules - font, fontSize, etc.
2. Try to load the file using Telerik.Web.Spreadsheet, as demonstrated in the Demo.

Current behavior

Loading will fail.

Expected/desired behavior

File should be loaded

Possibly related to #4017
In the reported scenario there are 1048576 rows, with 16384 columns, resulting in 17179869184 cells all with applied non-default validation value, and we iterate them all to set the validation value, so it can be serialized.

Environment

• Kendo UI version: 2024.3.806

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]

Bug report

The current TagHelper implementation of the Spreadsheet doesn't allow a definition of a custom toolbar. What the user can define in the toolbar configuratio is to show selected pre-defined tools using a configuration like the following:

    <toolbar>
        <home >
            <tool name="open"></tool>
        </home>
    </toolbar>

In the Kendo UI for jQuery suite, we can define a custom toolbar as follows:

      $("#spreadsheet").kendoSpreadsheet({
        toolbar: {
          home:[
            {
              type: "button",
              text: "PDF",
              showText: "both",
              icon: "k-icon k-i-download",
              click: exportPdf
            }]
        }
      });

Reproduction of the problem

Here is a sample project in which the "Open file" tool is defined.

Current behavior

We cannot define a custom toolbar using the Spreadsheet tag helper.

Expected/desired behavior

The user should be able to define a custom toolbar using the Spreadsheet tag helper as it is possible in the Kendo UI for jQuery suite - https://dojo.telerik.com/alobigUQ

Environment

• Kendo UI version: 2020.3.1118
• 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!