Bug report

Reproduction of the problem

Dojo example.

1. Click column "B"'s header to select the column.
2. Use the "Wrap text" tool from the toolbar. The text in B2 is wrapped.
3. While the column is still selected, use the "Wrap text" tool again.

Current behavior

The text in B2 is not unwrapped.

The merged cell prevents the unwrap. If there is no merged cell, or if the tool is used over the cell itself, wrapping/unwrapping works as expected.

Expected/desired behavior

The text in B2 is unwrapped.

Environment

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

Bug report

Memory usage is increased if the DevTools is open. Navigation between sheets is also slower.

Reproduction of the problem

1. Open our Spreadsheet demo in Chrome.
2. Import the attached Spreadsheet.
3. Open the Task Manager to check Chrome memory usage, and switch sheets to see the navigation speed.
4. Open DevTools and check memory usage again. Note that switching sheets is also significantly slower.

Current behavior

Memory usage increased and slower sheet change.

Expected/desired behavior

Memory usage should not be increased and sheet navigation should not be slow.

Environment

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

Bug report

The AND formula, when used as part of an array formula, does not evaluate the whole array.

{=AND(A1:D1="")} would return TRUE if a value is entered in the range B1:D1 and FALSE only if value is entered in A1
=IF(AND(A1="",B1="",C1="",D1=""),TRUE,FALSE) would return FALSE if value is entered in any cell in range A1:D1

Reproduction of the problem

1. Run this dojo
2. Select cell E1, press F2 to edit formula and press Ctrl+Shift+Enter to enter as an array formula

Current behavior

1. Enter a value in cell B1 - Array formula evaluates as TRUE, Non-array formula as FALSE
2. Only if a value is entered in A1 the Array formula will evaluate as FALSE

Expected/desired behavior

Array formula should be evaluated correctly and return FALSE when a value is entered in any cell in range A1:D1.

Environment

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

Bug report

Reproduction of the problem

Dojo example.

Current behavior

The first row is duplicated.

Expected/desired behavior

The first row is not duplicated

Environment

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

Bug report

If you set a data validation for a number typed cell in the Spreadsheet, the message will be improperly formatted.

Regression introduced with 2024.4.1112

Reproduction of the problem

1. Open the Spreadsheet Overview demo - https://demos.telerik.com/kendo-ui/spreadsheet/index
2. Select an empty cell, and click Data Tab -> Data Validation
3. Select Number from the dropdown
4. Enter Min value
5. Check the Show hint box, and click apply
6. In the cell, type a value lower than the min

Current behavior

The validation message is improperly formatted - "Please enter a valid any value greater than 10,,10,,number,reject,greaterThan."

Expected/desired behavior

Message should be "Please enter a valid any value greater than 10."

Environment

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

When the formula PRODUCT is used and the content of the cell based on which the formula is calculated is deleted, the result is incorrect.

Reproduction of the problem

1. Open the Dojo - https://dojo.telerik.com/@NeliK/OKAQaGOv
2. Delete the content of the A1 cell

Current behavior

The result in B1 is 1, while it should be 0

Expected/desired behavior

When the content of the cell used for calculation is deleted, the product formula should result to 0 (as it is in Excel).

Environment

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

Reproduction of the problem

Reproducible in the demos.

1. Use the HYPERLINK function in a cell:

=HYPERLINK("https://google.com")

Current behavior

The link does not work. It does if you specify a "friendly name":
=HYPERLINK("https://google.com", "google")

Expected/desired behavior

The link works with and without a "friendly name" specified, as in Excel.

Environment

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

Bug report

In a Spreadsheet with date cell editor, the fr-CA culture does not work.

Reproduction of the problem

1. Open this Dojo example - https://dojo.telerik.com/ogEvuTEf/6
2. Open the editor for the date cell

Current behavior

The Calendar is empty

Expected/desired behavior

The Calendar should display the dates defined in the validation

Environment

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

Bug report

Office 365 Comment are shown with a warning:
"[Threaded comment]

Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924

Reproduction of the problem

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

Current behavior

import a file from ticket - 1447268

A warning is displayed

Expected/desired behavior

No warning is displayed

Environment

• **Kendo UI version: 2019.3.1023

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

Bug report

Spreadsheet  render event does not fire since 2025.2.520

Reproduction of the problem
https://demos.telerik.com/kendo-ui/spreadsheet/events

Expected/desired behavior
Render event must fire initially.

The issue is a regression starting with 2025.2.520 version.

Environment
Kendo UI version: 2025.2.520
Browser: [all ]

Bug report

The following Toolbar localization settings are not applying for the Kendo UI Spreadsheet when it is configured with a localization/messages file and/or using JavaScript:

• kendo.spreadsheet.messages.toolbar.formatTypes
• kendo.spreadsheet.messages.toolbar.alignmentButtons
• kendo.spreadsheet.messages.toolbar.freezeButtons
• kendo.spreadsheet.messages.toolbar.mergeButtons

Reproduction of the problem

1. Go to this Progress Kendo UI Dojo. It uses the es-ES messages file.
2. Open the alignment buttons dialog.
3. Open the format types dialog.
4. Open the merge buttons dialog - not in overflow menu.
5. Open the freeze panes buttons dialog - not in overflow menu.

Expected/desired behavior

The toolbar messages should be translated.

Environment

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

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

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 attempting to validate a cell value against a predefined finite list, the validation process fails to recognize valid entries that are present in the list. Instead, it incorrectly flags them as invalid. The issue occur when there is an empty space before the first value in the 'from' option.

Reproduction of the problem

1. Run the Dojo - https://dojo.telerik.com/@NeliK/icizisEF

Current behavior

On the first row, the 'YES' in the B1 cell is marked as invalid although it is present in the list with the valid values. the difference between row 1 and row 4 is the empty space in the validation from configuration:

"from": "{ \"YES\", \"NO\"}", //row 1
"from": "{\"YES\", \"NO\"}" //row 4

Expected/desired behavior

The empty space added in the from configuration option should not affect the validation. If the cell value is present in the list, it should be marked as valid.

The issue is a regression starting with 2020.3.1118

Environment

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

Bug report

When a cell that contains letters and numbers is dragged and dropped, the new content has an incorrect value. The issue appears when the first character is a letter and when the number contains zero.

Reproduction of the problem

1. Open the Dojo - https://dojo.telerik.com/@NeliK/OfalaBuc
2. Drag the B0 and C0 cells

Current behavior

The result is:

Expected/desired behavior

The result should be the same value in case of text content (C0) or an incremented value in case the content ends with a number. Ex: A101 should result in A102, A103, A104 etc.

The issue is a regression starting with 2022.2.621

Environment

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

Bug report

When the Spreadsheet height is greater than the page height and the user scrolls and than enters a value in a cell, the Spreadsheet scrolls to the top.

Reproduction of the problem

1. Open the Dojo - https://dojo.telerik.com/@NeliK/EcUYewiH
2. Scroll down the scroller of the page and enter a value.

Current behavior

The Spreadsheet is scrolled to the top. screencast - https://go.screenpal.com/watch/cZj220V9U6j

Expected/desired behavior

The Spreadsheet should persist the position.

The issue is a regression starting with 2022.1.119 version.

Environment

• Kendo UI version: 2024.3.806
• jQuery version: x.y
• Browser: [all | Chrome XX | Firefox XX | IE XX | Safari XX | Mobile Chrome XX | Android X.X Web Browser | iOS XX Safari | iOS XX UIWebView | iOS XX WKWebView ]