Bug report

In a Spreadsheet that has a scrollable Sheetbar, clicking the arrow icons to scroll the sheets refreshes the page.

Regression introduced with 2024.4.1112

Workaround - https://dojo.telerik.com/IVcuYtjD/5

Reproduction of the problem

1. Open this Dojo example - https://dojo.telerik.com/ZXBKGnNe
2. Click on the arrow buttons to scroll the sheets

Current behavior

The page refreshes

Expected behavior

The page shouldn't refresh

Environment

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

Bug report

When there is a filter applied in Excel file and the file is imported in the Spreadsheet only the first row is visible. The issue occur when the filtered column is a numeric column.

Reproduction of the problem

1. Open the Demos - https://demos.telerik.com/kendo-ui/spreadsheet/index
2. Import the file

Book1.xlsx

Current behavior

Only the filter row is visible. The filter result data rows are hidden:

Expected/desired behavior

All rows with filtered results should be visible. Example:

The issue is a regression starting with 2024.4.1112 release

Environment

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

Bug report

Data validation should not require DATEVALUE("") in Start and End inputs when `Date` is selected

Reproduction of the problem

https://demos.telerik.com/kendo-ui/spreadsheet/index

1. Select an empty cell
2. Click Data validation
3. Set Start: DATEVALUE("1/1/2024") and End: DATEVALUE("2/2/2025")
4. Automatic Hint message looks like: between DATEVALUE("1/1/2024") and End: DATEVALUE("2/2/2025")

Expected
Generated hint message shall not contain DATEVALUE("")


Environment
**Kendo UI version: [all]
**Browser: [all]

Bug report

Spreadsheet cellContextMenu() throws an error

Regression with 2024.4.1112

Reproduction of the problem
Run the Dojo: https://dojo.telerik.com/SlDUjkTQ

Check console

`Uncaught TypeError: spreadsheet.cellContextMenu is not a function`

Environment

jQuery: 3.4.1

Kendo UI version: 2024.4.1112 or newer
Browser: [all]

Hi Team,

We are using the Kendo Spreadsheet and would like to request a feature to display a character limit indicator while the user is entering data in the cell. This is to prevent users from exceeding the character limit of a cell.

Requirement:

• When the user starts typing in a cell, it should display a live character count e.g. "10/100" if the user has entered 10 characters and limit is 100.
• Once the user reaches the maximum limit (e.g. 100/100), further input in the cell should be restricted.

Thank you!

Bug report

Spreadsheet validation on datatype=list, values in the dropdown are parsed to numbers. Numeric strings are automatically formatted by removing the heading zero.

Reproduction of the problem

Dojo: https://dojo.telerik.com/eOOvKJxL

                  validation: {
                      dataType: "list",
                      showButton: true,
                      comparerType: "list",
                      from: "{ \"001\", \"002\", \"Baz item 3\" }",
                      allowNulls: true,
                      type: "reject"
                    } 

The bug is a regression, formatting is different with a 2017 version: https://dojo.telerik.com/sCvgBzBa/5

Environment
**Kendo UI version: 2025.1.211
**Browser: [all]

Bug report

Spreadsheet fromFile() method does not return reject promise when an error occurs while loading file. An error is thrown on the browser console instead.

The issue has been tracked to the following implementation in the source:

• In the spreadsheet/workbook.js, the method fromFile() rejects the promise only when no file has been passed to the method code
• In the spreadsheet/excel-reader.js the method readWorkbook() should receive the deferred object as its last argument, but is renamed to progress and never used in the method;

Reproduction of the problem

• On the following Dojo select invalid file in the file input (.png, .pdf, .jpg or other);

Expected:

the 'No file to be loaded!' should be alerted;

Actual:

An error will be thrown on the console

Kendo version: 2023.3.1010

Bug Report

Calling the saveAsExcel method of the Spreadsheet throws an error, and the component is not exported

Regression introduced with 2024.4.1112

Workaround: https://dojo.telerik.com/fDhKflqE/2

Steps to Reproduce

1. Open the saveAsExcel API reference - https://docs.telerik.com/kendo-ui/api/javascript/ui/spreadsheet/methods/saveasexcel
2. In the example, click the Export button, and check the browser console.

Current Behaviour

An error is thrown, and the file is not exported

Expected behaviour

No errors, and the file should be exported

Describe the bug
When a custom editor is defined and next to it there is a frozen column, the custom editor cannot be opened.

To reproduce
Steps to reproduce the behavior:

1. Go to 'Dojo'
2. Click in cell B1
3. Try to open the calendar

Expected behavior
The calendar should be opened

Workaround

.k-spreadsheet .k-selection-wrapper .k-spreadsheet-editor-button.k-spreadsheet-last-column {
        transform: translateX(-100%);
}

The issue is a regression starting with themes version 6.3.0

Affected package (please remove the unneeded items)

• theme-default
• theme-bootstrap
• theme-material
• theme-tasks

Affected suites (please remove the unneeded items)

• Kendo UI for jQuery

Affected browsers (please remove the unneeded items)

• All

Hi Team,

I would like to request emf image support for the Kendo UI Spreadsheet.  If that is not possible, I would like to request a way to handle if the image is in a non-supported image type - such as a console error.  

Thank you!

Bug report

When the change event is bound after initialization it is not fired when changing a cell value.

Reproduction of the problem

1. Open the Dojo - https://dojo.telerik.com/XeTgsxKc
2. Change a value in a cell

Current behavior

The change event is not fired.

Expected/desired behavior

The change event should be triggered when a value of a cell has been changed.

Environment

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

Bug report
Subtotal Function in Spread returns wrong calculation on hidden columns. In Excel hidden columns does not reflect the result

Reproduction of the problem

Expected

Same result as in Excel

Environment

jQuery: 3.4.1

Kendo UI version: 2024.4.1112
Browser: [all]

Bug report

When exporting a Spreadsheet with a set background to a PDF file, some of its borders are not displayed.

Reproduction of the problem

1. Open the following Dojo example - https://dojo.telerik.com/IZUhIDeV
2. Export the Spreadsheet to PDF

Current behavior

Some borders of the Spreadsheet are missing in the exported PDF file.

Expected/desired behavior

All borders of the Spreadsheet should be displayed in the PDF file.

Environment

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

Bug report
SpreadSheet does not apply borderBottom correctly for last row

Reproduction of the problem

Dojo - https://dojo.telerik.com/UGABAnoR

Current behavior
Border is applied at the first row for the next column

Expected/desired behavior

The border shall be applied at the bottom at A2000

Environment
Kendo UI version: [all]
Browser: [all ]

Hi Team,

I would like to request a built-in way to set a reject type validation when a value is programmatically set in the Kendo UI Spreadsheet.  Currently, it only sets a warning type as shown in this Kendo UI Dojo.  

Thanks!

When a cell is copied to another cell by using the 'auto-fill' option, the format and validation from the initial cell is applied to the target as well, as described in the documentation.

- https://docs.telerik.com/kendo-ui/controls/spreadsheet/end-user/user-guide#other

I would like the possibility to persist the format and validation of the targeted cell and if for example non-valid data is dragged and dropped in a cell, the content to be rejected based on the targeted cell validation. 

Hi Team,

I would like to request to include the Embed function for the Kendo UI Spreadsheet to include objects such as PDF files into the Spreadsheet. 

Thank you!

[Edited]

Bug report

After pasting values from the Kendo UI Spreadsheet to Excel, making a change in Excel, and pasting the value back to a Kendo UI Spreadsheet, it pastes old information.

Reproduction of the problem

1. Open the Kendo UI Spreadsheet Overview
2. Copy Data C7:D8 from Kendo Spreadsheet
3. Paste data to MS Excel (used: Microsoft 365 MSO version 2309)
4. Edit values in MS Excel.
5. Copy from MS Excel
6. Paste new values to a Kendo UI Spreadsheet.

Expected/desired behavior

The new values are not pasted back to the Kendo UI Spreadsheet.

Environment

• Kendo UI version: 2023.3.1114
• jQuery version: All Supported Versions
• Browser: all