Bug report

Reproduction of the problem

Dojo example: https://dojo.telerik.com/UWicoqeJ

1. Focus an empty cell and paste the following formula: =IF(AND(H4-I4>=B4, H4+I4<=C4), "OK", "NO OK")

Current behavior

The cell will display: "NO OK"

Expected/desired behavior

The cell should display: "OK" as it does in Excel.

Environment

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

Bug report

When dragging a cell to edit other cells in the Spreadsheet, the Change event of the DataSource is not fired.
The issue is a regression starting with Kendo - 2022.2.621

Reproduction of the problem

1. Open the following dojo:
   https://dojo.telerik.com/OyAmimaH/2

Try to edit multiple cells by dragging a cell.

Current behavior

The Change event is not triggered.

Expected/desired behavior

The Change event should be fired.

Environment

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

Bug report

Reported in Ticket ID: 1529288

Reproduction of the problem

Create an MVC application:

View:

@{
	ViewBag.Title = "Home Page";
	string sfile = System.IO.Path.Combine(Server.MapPath("~"), "File1.xlsx");
}

@Html.Kendo().Spreadsheet().Name("spreadsheet"))

<br />	
<br />	
<button class="k-button k-primary" id="export" onclick="ExportExcel()">Export Spreadsheet content</button>
<script>
    function ExportExcel() {
        var spread = $('#spreadsheet').getKendoSpreadsheet();
        var data = JSON.stringify(spread.toJSON());

        var fd = new FormData();
        fd.append('wbook', data);
        fd.append('sfile', "File1.xlsx");

        $.ajax({
            url: "@Url.Action("SaveFileExcel", "Home")",
            data: fd,
            contentType: "application/x-www-form-urlencoded",
            processData: false,
            contentType: false,
            type: "POST",
            statusCode: {
                200: function (xhr, status, err) {
                    console.log('File exported!');
                },
                500: function (xhr, status, err) {
                    console.log('Internal Server Error!');
                }
            }
        });
    }
</script>

Controller:

[HttpPost]
public ActionResult SaveFileExcel(string wbook, string sFile)
{
    var workbook = Telerik.Web.Spreadsheet.Workbook.FromJson(wbook);
    string physicalPath = Path.Combine(Server.MapPath("~/"), sFile);
    //workbook.Save("C:/inetpub/wwwroot/" + sFile
    workbook.Save(physicalPath);
    return new EmptyResult();
}

1. Add the application to a Docker container.
2. Place a breakpoint in the SaveFileExcel action.
3. Run the app and click the button below the Spreadsheet.

Current behavior

The Save method throws System.ExecutionEngineException

Expected/desired behavior

The file is saved.

Environment

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

Bug report

Reproduction of the problem

Dojo example.

1. Open Company filter menu.
2. Uncheck All and check only "Excella". Click Apply.
3. Open the same filter menu and check "Complete Tech". Click Apply.
4. Click the "Undo" button

Current behavior

All filters are cleared.

Expected/desired behavior

The Spreadsheet shows Company filtered by value "Excella". This is the behavior when different columns are filtered consecutively and then "Undo" is clicked.

Environment

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

Bug report

Reproduction of the problem

Reproducible in the demos:

1. Create a second sheet.
2. Select the new sheet ("Sheet1") and scroll the horizontally to column U. Add a value to the U1 cell.
3. Select the first sheet ("Food Order").
4. Select A17 and enter the following value: =SUM(C5,
5. Select "Sheet1" and try to navigate to U1 either through the keyboard or through scrolling the sheet.

Current behavior

A popup with an error message appears.

Expected/desired behavior

The user should be able to navigate to the desired cell, in order to add it as a reference to the formula.

Environment

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

Bug report

Calling insertRow multiple times over many sheet data causes a slower performance since 2020.1.219.

Reproduction of the problem

http://dojo.telerik.com/EBEtaFOj (2020.1.114)

1. Click the Add Rows button and wait for the alert.

Current behavior

http://dojo.telerik.com/UJAGUgAl

The Workbook.FromDocument() method freezes the panes based on the coordinates of the TopLeftCellIndex of the pane instead of the XSplit and YSplit properties of the pane. Reproduced with the attached Excel file

• https://github.com/telerik/kendo/blob/master/dpl/Telerik.Web.Spreadsheet/Models/Workbook.FromDocument.cs#L50

var pane = documentWorksheet.ViewState.Pane;
if (pane != null && pane.State == PaneState.Frozen)
{
    sheet.FrozenRows = pane.TopLeftCellIndex.RowIndex;
    sheet.FrozenColumns = pane.TopLeftCellIndex.ColumnIndex;
}

Solution:

var pane = documentWorksheet.ViewState.Pane;
if (pane != null && pane.State == PaneState.Frozen)
{
    sheet.FrozenRows = pane.YSplit;
    sheet.FrozenColumns = pane.XSplit;
}

WORKAROUND: Loading the Excel file with DocumentProcessingLibrary API and change the pane

var fileName = <YourFilePathHere...>;
if (!File.Exists(fileName))
{
    throw new FileNotFoundException(String.Format("File {0} was not found!", fileName));
}

Telerik.Windows.Documents.Spreadsheet.Model.Workbook workbook;
IWorkbookFormatProvider formatProvider = new Telerik.Windows.Documents.Spreadsheet.FormatProviders.OpenXml.Xlsx.XlsxFormatProvider();

using (Stream input = new FileStream(fileName, FileMode.Open))
{
    workbook = formatProvider.Import(input);
    foreach (var sheet in workbook.Worksheets)
    {
        if (sheet.ViewState.Pane != null && sheet.ViewState.Pane.State == Telerik.Windows.Documents.Spreadsheet.Model.PaneState.Frozen)
        {

            var originalPane = sheet.ViewState.Pane;
            var pane = new Pane(new CellIndex(originalPane.YSplit, originalPane.XSplit), originalPane.XSplit, originalPane.YSplit, originalPane.ActivePane);
            sheet.ViewState.Pane = pane;
        }
    }
}
var sheets = Telerik.Web.Spreadsheet.Workbook.FromDocument(workbook).Sheets;

Bug report

This is a regression introduced in R2 2019.
Textboxes and charts currently are not supported in the Spreadsheet, however, if the loaded excel file contains such, saving the file should not throw a js exception.

Reproduction of the problem

1. In Excel add a textbox and/or a chart to a workbook. Save the workbook. Alternatively, use the attached file:
   sample-new-chart-textbox.zip
2. Load the .xlsx file in the Spreadsheet
3. Save the file

Current behavior

On saving the file the following exception is thrown:
kendo.all.js:12938 Uncaught TypeError: Cannot read property 'target' of undefined

Expected/desired behavior

No js exceptions on saving the file.

Environment

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

Bug Report

When importing a XLSX file with a frozen pane using server implementation(using the Document Processing Library), the dimensions of the frozen pane are missed.  

Reproduction of the problem

1. Visit the Spreadsheet Server Import/Export live demo.
2. Import the attached example(FrozenPaneExample.zip).

Current Behavior

The imported xlsx file appears to overflow the Kendo UI Spreadsheet component.  See screencast(SpreadhsheetOverflowFrozenPane.zip)

Expected Behavior

When importing a file using server implementation, the file should be contained within the Kendo UI Spreadsheet component's view.

Workaround

Reduce the amount of frozen rows/columns to fit into the widget.  

Environment

• Kendo UI version: 2020.1.114
• Browser: all

Bug report

Regression introduced in R3 2019.

Reproduction of the problem

Open this Spreadsheet demo. Even though the Toolbar configuration is set to false, it is not hidden. This applies only for ASP.Net Core and ASP.Net MVC.

Current behavior

The Toolbar is visible when set to false.

Expected/desired behavior

The Toolbar should be hidden.

Environment

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