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

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

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.

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]

Reproduction of the problem

1. Run this sample
2. Select first row
3. Delete the row
4. Select range A1:C3
5. Apply borders
6. Select row 3
7. Delete the row

Current behavior

Top border of cell B1 disappears

Expected/desired behavior

Borders are persisted

TicketID:

1708030

Environment

* **Kendo UI version:** 2025.4.1217

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

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

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

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]

Hi Team,

I would like to request to include the PMT function for the Kendo UI Spreadsheet.

Thank you!

We are using a sheet with a datasource

if the user only selects one column and then sorts it only sorts the data in that column and mixes the rows data. 

Suggestion: the filter button should act like the Excel filter button where it auto selects the entire sheet before applying the filter.

Maybe only when using a datasource?

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 Spreadsheet, if you attempt to delete a row that contains a disabled cell, the operation is pushed in the undo stack. Pressing the undo button inserts a copy of the row with empty disabled cell.

Reproduction of the problem

1. Open the Disabled Cells demo - https://demos.telerik.com/kendo-ui/spreadsheet/disabled-cells
2. Select a row
3. Right-click on the row and press Delete from the ContextMenu
4. Click the undo button

Current behavior

A new row is inserted above the selected row, as the unsuccessful delete operation is pushed in the undo stack

Expected/desired behavior

The unsuccessful delete operation shouldn't pushed in the undo stack

Environment

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

Bug Description

When you add a filter to a column on the spreadsheet component, only the down arrow icon part of the filter button is clickable, not the entire button.

Steps to Reproduce

1. Open the Dojo - https://dojo.telerik.com/dmrXJIdC
2. Try to click on the filter buttons (.k-spreadsheet-filter)

Expected Behavior

The filter menu is not opened unless we click on the icon.

Actual Behavior

The filter menu should open when the button is clicked.

Bug Description

When cell with border is cut in the Spreadsheet, the border is also removed from the next cells.

Steps to Reproduce

1. Open the Dojo - https://dojo.telerik.com/miEJlUWH
2. Cut cell B2 using Ctrl +X

Expected Behavior

The cell A2 should have a right border, cell C2 should have a left border, etc...

Actual Behavior

The next cells borders are cut as well

Environment

• Kendo UI version: 2025.1.227

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]