Bug report

When we want to add a formula in a given cell in the Spreadsheet, we double-click it and enter the "=" in it as an identifier that a formula definition will follow. If we want to include in the formula a cell that is not inside the visible range of the Spreadsheet, we scroll to that cell and select it. In Internet Explorer, if we scroll to a given cell using the arrows of the Spreadsheet's scrollbar the "double-clicked" cell becomes just a selected one and the "=" sign is converted to a string value.

Reproduction of the problem

1. Open this Dojo example in Internet Explorer 11
2. Select the A1 cell and enter "=" in it.
3. Press the "down" direction arrow of the Spreadsheet trying to reach cell A50.
4. With the first click on the arrow, the A1 cell is no more "double-clicked" and the "=" inside it is converted to a string

Current behavior

When building a formula in a given cell and trying to navigate to a cell using the scrollbar, this usage stops the formula building and converts the "=" into a string.

Expected/desired behavior

When a user creates a formula for a given cell, they should be able to navigate through the Spreadsheet using its scrollbars.

Environment

• Kendo UI version: 2019.2.619
• jQuery version: x.y
• Browser: IE 11.950.17134.0

Hello,

I am looking at possibility to convert Spreadsheet tables to html . I am creating an HTML report with header and footer and would like to merge the spreadsheet table as html between header and footer.

Is there a way to convert the spread content to html tables

Thanks

Anamika 

Hello,

we have a hard time controlling the cells "Enable" attribute in a data binding scenario, because it really depends on the data, e.g. the complete Row must be read only (Enable = false) when Cell "Completed" is marked with true.

I mark this as "Feature request" because I think there is no such functionality, but I'd need some dynamic expression here, you could reuse the validation expressions, e.g.:

enable: "NOT(ISERROR(FIND(\"true\", B3)))"

As an alternative/workaround, maybe we can reuse validation / reject, so instead of making the cell non-editable, leave it editable but reject any kind of change, this is just a thought and I feel like there is no easy way to do it like this either.

You might wonder how we apply validation or enabled/disabled cells in data binding scenario; We basically run post processes after data binding, so because I think there is no other way doing it.

Best regards

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

Bug report

Reproduction of the problem

1. Open the Dojo
2. In the first column enter "01/01/0001"

Current behavior

The Date is displayed as "12/31/0"

Expected/desired behavior

The Date should be displayed correctly.

Environment

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

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

When the Scheduler control is bound a datasource that includes a Boolean value/column in the database the Spreadsheet column presents this as "true" or "false" strings.

Allow alternate strings such as  "Yes" or "No" to represent a Boolean. Would of course need to update the datasource appropriately on Edit of a cell that uses this presentation.

Tested on demo-page. The export of an Excel-file containing defined names with a period such as "test.name" will result in an error.

Steps to reproduce:

1. Create an Excel-file that has a defined name like "test.name"
2. Open the file on the demo page
3. Click on any of the "Save as..." buttons
4. An error page is shown

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

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

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: https://dojo.telerik.com/iMuMedOd

1. Focus a cell and use one of the following shortcuts: Ctrl + B (Bold), Ctrl + I (Italic)

Current behavior

A js exception is thrown:
Uncaught TypeError: Cannot read property 'click' of undefined
kendo.all.js:168073

Expected/desired behavior

With the toolbar disabled the shortcuts should do nothing. There should be no exceptions.

Environment

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