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

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.

Bug report

Hyperlinks in a Spreadsheet cell do not work mobile devices.

Reproduction of the problem

1. Open this example on a mobile device - https://dojo.telerik.com/ahixOKep
2. Try to click on the links in the Product column.

Current behavior

The link in the cell does not work.

Expected/desired behavior

The link should work

Environment

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

Bug report

When a border is applied and there are frozen rows/columns the border appears splitted with a white lin in the middle.

Reproduction of the problem

1. Open the Dojo example.

Current behavior

The bottom border and the right border are split with a white line in the middle.

Expected/desired behavior

The border should appear entirely filled with the selected color.

Environment

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

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

When the Sheetsbar is hidden the horizontal scrollbar is not adjusted to the bottom of the widget

Reproduction of the problem

1. Run this dojo
2. Note the space below the horizontal scrollbar:
   

Expected/desired behavior

The horizontal scrollbar should be adjusted to the bottom of the widget.

As a possible workaround, when hiding the Sheetsbar add the following styling:

<style>
    .k-spreadsheet-sheets-bar {
      padding: 0;
      border-style: none;
    }
</style>

Environment

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

When values in the sheet are updated using the batch method the DataSource does not update according to changes.

Dojo: https://dojo.telerik.com/@iankodj/IRUdufOx

1. Run the example

2. Check the console showing "no data" and an empty array.

Expected: https://dojo.telerik.com/@iankodj/EKoziCic 

Bug report

Reproduction of the problem

Reproducible in this demo: https://demos.telerik.com/kendo-ui/spreadsheet/datasource

1. Scroll down to row 78
2. Focus A78 and drag to E78. Copy the data
3. Paste over the empty 79 row's first cell
4. Press Ctrl + Z to undo the changes.
5. Open the browser's dev tools network tab and press the "Save" button above the Spreadsheet.

Current behavior

The data cleared by the "undo" shortcut is saved and sent to the server

A different behavior is exhibited if the data is pasted over the row header instead of the row's first cell. Follow the same steps, but on step 3. instead of pasting over the first cell, paste the data over the row 79 header. After undo and then clicking "Save", the fields have null values.

Expected/desired behavior

No data is sent with the request

Environment

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

Bug report

Spreadsheet: Improper copy paste to Excel when merged cells are present and one column in the merged cells range is hidden. If the column containing the first merged cell is hidden all the rows on that row will be shifted to the left.

Reproduction of the problem

• Run the following Dojo;
• Select Range A1:D3 (note that column B is hidden)
• Press Ctrl + C;
• In Excel workbook press Ctrl + P;

Current behaviour

After pasting, the merged cell consists of 4 cells, as expected, but the cell data is shifted to the left and the hidden column contains the cell data of the next column

Expected/desired behavior

The cells after the merged cell should not be shifted.

Environment

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

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

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

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 ]