Bug report

Modified date value from Excel is not correctly updated when pasting in the Spreadsheet.

Regression introduced with 2023 R1

Reproduction of the problem

1. Open this Dojo example - https://dojo.telerik.com/AZateGoC/6
2. Copy the Spreadsheet content
3. Paste in to an Excel file
4. Change the date cell value
5. Copy and paste back in the Spreadsheet

Current behavior

The updated date cell is not pasted in the Spreadsheet

Expected/desired behavior

The updated cell's value should be pasted in the Spreadsheet

Environment

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

Bug report

When the background tool is displayed in the overflow menu of the toolbar and the user tries to change the background color or text color an error: e[this._property] is not a function is thrown.

Reproduction of the problem

1. Open the Dojo - https://dojo.telerik.com/@NeliK/IHaRIvoy
2. Select a cell and try to change its background color or text color

Current behavior

An error e[this._property] is not a function is thrown and the background color is not changed.

Expected/desired behavior

There should be no error in the console and the color should be changed accordingly.

The issue is a regression starting with 2023.1.117 version

Environment

• Kendo UI version: 2024.1.319
• jQuery version: x.y
• Browser: [all | Chrome XX | Firefox XX | IE XX | Safari XX | Mobile Chrome XX | Android X.X Web Browser | iOS XX Safari | iOS XX UIWebView | iOS XX WKWebView ]

Bug report
SpreadSheet does not apply borderBottom correctly for last row

Reproduction of the problem

Dojo - https://dojo.telerik.com/UGABAnoR

Current behavior
Border is applied at the first row for the next column

Expected/desired behavior

The border shall be applied at the bottom at A2000

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

Bug report

When values are pasted in the Spreadsheet if the cell is not empty the previous format is taken into account

Reproduction of the problem

1. Open the Dojo - https://dojo.telerik.com/@NeliK/IniJunuZ
2. Paste content that contains different formats such as dates and numbers (sample file attached)
   test_format.xlsx
3. Paste the content two times as the second time the number column should be pasted over the column that has dates

Current behavior

The number column is formatted as date - screencast(https://somup.com/cZeoodChyH)

Expected/desired behavior

The current format should be applied to the pasted data.

Environment

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

Bug report

Reproduction of the problem

Dojo: https://dojo.telerik.com/eToXOQOL/9

1. Open a Notepad, and create the following structure:

a
b[tab]c[tab]d
e[tab]f[tab]g

Between each element on rows 2 and 3, there is a [tab] character. This will make sure that the data pasted into Spreadsheet will land on different columns.

 2. Copy the entire content of the Notepad document and paste it in cell A1. After the paste operation, you will notice under the Spreadsheet component an output with the range that was passed to the change event.

Problem:
The computed range is A1:A3 while the expected value is A1:C3

Expected behaviour

The expected value is A1:C3

Environment
Kendo UI version: 2021.1.224 or newer
Browser: [all]

Bug report

Round Function from empty cell shows #VALUE! but in Excel, this shows 0

Reproduction of the problem

Open Dojo: https://dojo.telerik.com/aBOMoCOF

Paste in cell B1 the following formula: =ROUND(A1, 2)

The shown result is #VALUE!

In Excel the same formula returns 0

Expected/desired behavior

The shown value must be 0

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

Bug report

In a Spreadsheet with date cell editor, the fr-CA culture does not work.

Reproduction of the problem

1. Open this Dojo example - https://dojo.telerik.com/ogEvuTEf/6
2. Open the editor for the date cell

Current behavior

The Calendar is empty

Expected/desired behavior

The Calendar should display the dates defined in the validation

Environment

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

Bug report

After pasting values from the Kendo UI Spreadsheet to Excel, making a change in Excel, and pasting the value back to a Kendo UI Spreadsheet, it pastes old information.

Reproduction of the problem

1. Open the Kendo UI Spreadsheet Overview
2. Copy Data C7:D8 from Kendo Spreadsheet
3. Paste data to MS Excel (used: Microsoft 365 MSO version 2309)
4. Edit values in MS Excel.
5. Copy from MS Excel
6. Paste new values to a Kendo UI Spreadsheet.

Expected/desired behavior

The new values are not pasted back to the Kendo UI Spreadsheet.

Environment

• Kendo UI version: 2023.3.1114
• jQuery version: All Supported Versions
• Browser: all

Bug report

When the sheets.filter property of the Spreadsheet is configured and there is a hyperlink in a cell, the hyperlink is not clickable and cannot be accessed.

Regression introduced with 2022.1.119

Reproduction of the problem

1. Open the following Dojo example - https://dojo.telerik.com/@Zornitsa/aWugOqiw
2. Try to click on the hyperlink in the 'Terry Lawson' cell.

Current behavior

The hyperlink cannot be clicked.

Expected/desired behavior

The hyperlink should be clickable.

Workaround

As a workaround, you can add the following style:

 .k-spreadsheet-data{
   z-index: 100;
}

Environment

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

Bug report

When an Excel File that contains VLOOKUP and calculated columns is imported in Excel, this results to CIRCULAR value for the cells, although ther are no circular formulas in the file.

Reproduction of the problem

1. Open the Dojo - https://dojo.telerik.com/@NeliKondova/ApAGUkET
2. Import the file - Demo.xlsx

Current behavior

The values in the Spreadsheet are imported as '#CIRCULAR' although there are no circular formulas.

When the VLOOKUP in cell L2 is deleted the values are imported as '#VALUE'

Expected/desired behavior

The values in the Excel file should be imported correctly.

Environment

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

Bug report

When the scale and layout setting of the machine is different than 100% the keyboard navigation does not work properly. The issue occurs with different scales on each machine. For example, on some machines, it could work with all scales, but on others, it may not work with a scale of 125% or 175%, even if this is the recommended value.

Reproduction of the problem

1. Open the demos - https://demos.telerik.com/kendo-ui/spreadsheet/keyboard-navigation
2. Set a scale different than 100% to the computer
   

Note, that you may need to test with different scales to manage to replicate the issue.

3. Using the arrow keys navigate to the last column of the Spreadsheet (AX)
4. Go to the previous column (AW)
5. Try to move up/down/left/right

Current behavior

The navigation does not work. The cell selection does not work or goes to a wrong cell.

https://somup.com/c06nQJBFmV

Expected/desired behavior

The Spreadsheet navigation should work with all screen scales.

Environment

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

Bug report

Dropdownlist editor remains visible on scroll of the Scheduler

Reproduction of the problem

Dojo: https://dojo.telerik.com/iLusiHAm

Open the DropsDownList editor in B2 cell 

Scroll down the sceduler

Expected/desired behavior
DropsDownList editor shall close

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

Bug report

When validation type list or a custom editor is defined for the last column of the Spreadsheet, the popup for displaying the items does not open.

Reproduction of the problem

1. Open the Dojo - https://dojo.telerik.com/@NeliKondova/oNODiSuj
2. Scroll horizontally to the last column and click on the cell.
3. Try to open the popup.

Current behavior

The list with items does not appear.

Expected/desired behavior

The items should be displayed.

The issue is a regression starting with the 2023 R1 SP2 (2023.1.425) release.

Environment

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

Bug report

When exporting a Spreadsheet with a set background to a PDF file, some of its borders are not displayed.

Reproduction of the problem

1. Open the following Dojo example - https://dojo.telerik.com/IZUhIDeV
2. Export the Spreadsheet to PDF

Current behavior

Some borders of the Spreadsheet are missing in the exported PDF file.

Expected/desired behavior

All borders of the Spreadsheet should be displayed in the PDF file.

Environment

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

Bug report

When the reference to a cell in a specific Sheet is added in the defineName function, using the name leads to invalid result.

Reproduction of the problem

1. Open the Dojo - https://dojo.telerik.com/@NeliKondova/eWeVASOK
2. Select a cell and type '=Foo'

Current behavior

The returned result is '#NAME?'

Expected/desired behavior

The returned result should depend on the referenced cell value. In the example above B2 have a value 5, thus the value in the selected cell should be also 5.

The issue also appears when importing an Excel file with defined names in the Spreadsheet. The names in the attached Excel file are created as in the image below:

test.xlsx

The issue is a regression starting with the 2022 R2 SP1 (2022.2.621) release

Environment

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

Bug report

Cannot delete defined names in the name box of the Spreadsheet when clicking the delete button.

Regression introduced with 2022.1.119

Reproduction of the problem

1. Open the Dojo example - https://dojo.telerik.com/UcARaSok
2. Expand the name box with the defined names.
3. Try to delete an item from the name box by clicking the delete button.

Current behavior

The items cannot be deleted.
The following error appears in the browser console:
Uncaught TypeError: Cannot read properties of undefined (reading 'name')

Expected/desired behavior

The items in the name box should be deleted and an error should not appear.

Environment

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

Bug report

YEAR, MONTH and DATE functions do not return the same value on a black cell as in MS Excel

Reproduction of the problem

Apply the Year, Month or Date functions on any blank cell, it returns #VALUE!, where as Excel returns the respective value. 

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

[Edited]

Bug report

After pasting values from the Kendo UI Spreadsheet to Excel, making a change in Excel, and pasting the value back to a Kendo UI Spreadsheet, it pastes old information.

Reproduction of the problem

1. Open the Kendo UI Spreadsheet Overview
2. Copy Data C7:D8 from Kendo Spreadsheet
3. Paste data to MS Excel (used: Microsoft 365 MSO version 2309)
4. Edit values in MS Excel.
5. Copy from MS Excel
6. Paste new values to a Kendo UI Spreadsheet.

Expected/desired behavior

The new values are not pasted back to the Kendo UI Spreadsheet.

Environment

• Kendo UI version: 2023.3.1114
• jQuery version: All Supported Versions
• Browser: all

Bug report

In the Spreadsheet, if you freeze too many columns and then try to export to Excel, the file is corrupted.

If you reduce the number of columns in the example below, the issue does not occur.

Reproduction of the problem

1. Open this example
2. Click the frozen rows button
3. Click the Export to Excel button

Current behavior

The exported file is corrupted and cannot be opened

Expected/desired behavior

The file should not be corrupted

Environment

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