Bug report

The Spreadsheet doesn't' load correctly Excel files which definition of the tag is a single cell, instead of a cell range.

Test files: test-2.zip

Reproduction of the problem

1. Download the test-2.zip file and load the "test.xlsx" file in the Spreadsheet here.
2. The file has data in the “AZ” and “BA” columns and once it is imported in the Spreadsheet the data from the “BA” column is imported in the “AX” column and the values in the AZ column are missing.

• If the above file is saved in Excel it is correctly loading in the Spreadsheet. In the attached archive there is the “test-copy.xlsx” file which is the saved and correctly working one. Below is the structure of the two files. The one in red is from the "test.xlsx" file and the code in green is from the "test-copy.xlsx" file.

Current behavior

The The "test.xlsx" file is not loading correctly in the Spreadsheet and loses data

Expected/desired behavior

The "test.xlsx" file should load correctly in the Spreadsheet without losing data

Environment

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

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

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

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

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

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

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 ]

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

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]

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 ]

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

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]

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.

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/

Hello there,

I am developing a Web application using  Kendo UI Spreadsheet control, but I noticed that when I copy some numbers from a Excel sheet to the spreadsheet and then copy back to Excel, the decimal values are quite different, I mean, the decimal precision has been affected.

For example:

I have the following numbers on a Excel sheet:

Then, I copy them to the Kendo spreadsheet and I got the following:

But when I copy them back to Excel I got this:

Losing many decimals affecting the results of my computation and calculation.

Can you tell me why is this happening?

Thank you some much.

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