Bug report

When the select() method is used in the Spreadsheet changing event wrong cell is selected.

Reproduction of the problem

1. Open the dojo example
2. Select a different cell, change its value, and press Enter

Current behavior

Changing event is fired, but the 'B3' cell is selected instead of the 'B2'

Expected/desired behavior

The correct cell should be selected when using the select method inside the Spreadsheet event handlers.

Environment

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

Bug report

The wrap text tool hides some of the cell's text if it is too long.

Reproduction of the problem

Go to this Dojo. Select cell A1 and toggle the wrap text tool. The beginning of the text is not displayed.

Current behavior

Part of the cell's content is hidden.

Expected/desired behavior

All the text should be visible.

Environment

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

Bug report

Steps to reproduce

1. Open the Spreadsheet demo.
2. Import TestExcel.xlsx.
3. Compare the formula cell results with the same file opened in Microsoft Excel.

Current behavior

After import, some formula cells produce different results than Excel when the intermediate result is very close to zero.

Observed example from the attached file:

• In Excel:

  • E1 = 0
  • E2 = 0
  • F1 = 55110.305475240835

• In Spreadsheet after import:

  • E1 = 0.00000000004366
  • E2 = 0.000000000043660000000000000000
  • F1 = 0

Expected behavior

Spreadsheet should match Excel results for the imported workbook, including cases where formulas evaluate to values extremely close to zero.

Notes

The issue appears related to formula recalculation after import and handling of floating-point precision near zero.

In the attached file:

• The imported numeric inputs are:

  • A1 = 79590.518373344006
  • B1 = 0.16372664029103301
  • C1 = 4
  • D1 = 82665.458212861093

• The formula in E1 is:

  • A1*(1+B1)^(1/C1)-D1

Excel stores the result as 0, but Spreadsheet recalculates it to a very small positive number, which then changes the dependent IF result in F1.

Environment

• Spreadsheet core demo: local reproduction confirmed
• File used: TestExcel.xlsx

Workaround

  <script>
    const CANCELLATION_EPSILON = Number.EPSILON * 4;

    function collapseCancellationError(result, left, right) {
        const scale = Math.max(Math.abs(left), Math.abs(right));

        if (!scale || result === 0) {
            return result;
        }

        return Math.abs(result) <= CANCELLATION_EPSILON * scale ? 0 : result;
    }
    const { defineFunction } = KendoSpreadsheetCommon;
    defineFunction('binary+', function(a, b) {
        return collapseCancellationError(a + b, a, b);
    }).args([
        ['*a', ['or', 'number', ['null', 0]]],
        ['*b', ['or', 'number', ['null', 0]]]
    ]);

    defineFunction('binary-', function(a, b) {
        return collapseCancellationError(a - b, a, b);
    }).args([
        ['*a', ['or', 'number', ['null', 0]]],
        ['*b', ['or', 'number', ['null', 0]]]
    ]);
  </script>

TestExcel.xlsx

Describe the bug
When the Spreadsheet has locked columns and columnWidth is set, but the width of the locked exceed the width of the Spreadsheet, the widget is not rendered correctly.

To reproduce
Steps to reproduce the behavior:

1. Run the Dojo - https://dojo.telerik.com/@NeliKondova/aXUvAKeB

The columns of the Spreadsheet are visible even outside of the component.

Expected behavior
The columns should be limited to the Spreadsheet width

Affected package (please remove the unneeded items)

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

Affected suites (please remove the unneeded items)

• Kendo UI for jQuery

Affected browsers (please remove the unneeded items)

• 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]

Bug report

Dropdown Not Visible in Frozen Pane in Kendo jQuery Spreadsheet

Reproduction of the problem

Dojo example - https://dojo.telerik.com/mLetbVPM

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

Bug report

NORM.S.INV, NORM.INV, and NORM.DIST are officially listed as supported formulas, but they are not functioning properly

Regression bug since 2024.4.1112

Reproduction of the problem

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

Paste: =NORM.S.INV(0.908789)

Result must be 1.3333347

Environment
Kendo UI version: 2024.4.1112
Browser: [all ]

Bug report

In the Spreadsheet, when users scroll horizontally to columns that are not initially visible, then activate Freeze Panes, the Spreadsheet scrollbar behave incorrectly

Reproduction of the problem

1. Open the Dojo - https://dojo.telerik.com/zYbZtYDR.
2. In the Spreadsheet, scroll horizontally to columns that are not initially visible.
3. Activate Freeze Panes.
4. Attempt to continue horizontal scrolling.

Current behavior

When Freeze Panes is activated after horizontal scrolling:

• The Spreadsheet snaps back to the first (leftmost) column, Column A.
• Horizontal scrolling becomes unusable.
• Users cannot navigate to the right-hand columns until Unfreeze Panes is selected.

Expected/desired behavior

• Activating Freeze Panes should retain the current horizontal scroll position.
• Horizontal navigation should remain fully available across all unfrozen columns.
• Freezing should not disable the internal Spreadsheet scrollbar or shift the viewport.

Environment

• Kendo UI version: 2026.1.212
• Browser: [al]

Bug report

Reproduction of the problem

Run this dojo - https://dojo.telerik.com/MkKhDjxX

The results are different when using the same values in Excel.

Current behavior

Result comparison for cells with numeric values

Result comparison for cells with text values

TicketID:

1715542

Environment

• Kendo/Telerik version: 2026.2.520

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]

We're using the kendo spreadsheet with validation.

There's a cell that validates against a list of values.

The list of values can be up to 50 values or so.

It would be beneficial if there is a scrollbar for the dropdown, similar to the Excel behavior.

Using a datasource on a sheet

Selecting entire sheet and clicking the filter in the data toolbar tab.

The buttons for the columns do not respect the size of rowHeight or headerHeight

Set rowHeight to 20 and i get this 

Bug report

In the Speadsheet, the items of the DropDownButton for the sheet tabs are hardcoded and cannot be translated

Reproduction of the problem

1. Open this Dojo example - https://dojo.telerik.com/EtdKrzwo/2
2. Click the DropDownButton for the Food Order sheet

Current Behavior

The DropDownButton's items are not translated

Expected/desired behavior

The DropDownButton's items are not translated

Environment

• Kendo UI version: 2025.3.1002
• Browser: all

Hi team,

In kendo spreadsheet if you disable any row by adding enable property to false and apply sort from data tab, then the disable row is changing based on the sort. instead of applying to particular row  it is applying to perticular range and while sorting the row items are changing. The cell properties are not applying there while sorting.

link for example: https://dojo.telerik.com/IkoJeMIz

please let me know if I am doing anything wrong here.

thanks.

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]