Reproduction of the problem

Open this web site:
https://demos.telerik.com/kendo-ui/spreadsheet/datasource

And follow the steps provided here:
https://www.screencast.com/t/UdEKYqIve

Current behavior

The first added cell value (or row) is removed when the user deletes an empty row.
If the ID is entered, the result is even stranger:
https://www.screencast.com/t/osmVOiY7al

Expected/desired behavior

It should behave and function like Excel. I think with local/static binding there are no issues.

In Firefox on 4K screens, the Spreadsheet vertical and horizontal scrollbars cannot be revealed or dragged with the mouse. Scrolling works only with the mouse wheel. The issue is not reproducible in Chrome or on 2K screens. The same behavior is observed in the Kendo UI for jQuery, KendoReact and Kendo UI for Angular Spreadsheet.

Steps to reproduce

1. Open the Spreadsheet overview demo in Firefox on a 4K screen (Windows with overlay scrollbars).
2. Move the mouse to the right or bottom edge of the Spreadsheet and try to reveal or drag the scrollbar.

Actual behavior

The scrollbar is not shown, or it is very hard to reveal (it appears only occasionally in the top right corner), and it cannot be used.

Expected behavior

The scrollbar is revealed on hover and can be dragged.

Cause

Firefox uses overlay scrollbars, which hide automatically, and the scrollbar width is measured as 0. The Spreadsheet's internal fixed container then covers the whole scrollable area, including the scrollbar, so the mouse never reaches it. The mouse wheel keeps working because it is handled separately.

Environment

Windows 11, Firefox, 4K display, Kendo UI for jQuery 2026.3

Hi Team,

I have getting warning message when open down loaded excel file . This warning is coming if we apply conditional formatting in kendo spreadsheet .Please 

check the URL

https://dojo.telerik.com/

Dear Concerned,

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

2. Select column B and drag mouse towards C, both columns will be selected which is correct behavior

3. Now just scroll down 2-3 rows using vertical scroll bar

4. Repeat step 2, this time it does not select B &  C, instead it selects B,C,D,E.

5. Seems a bug, not an expected behavior.

Observation that might help you in fixing it:

1. if you move scroll bar in such a way so that no merged cell is visible it works well, e.g. scroll down till 20th row becomes first visible row on screen and now repeat step 2, it will work

2. if scroll position is on top then behavior is correct as well

3. Same issue exists in case of multiple row selection with merged column and scroll position.

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]

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

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.

Hi Team,

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

Thank you!

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

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!

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

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!