Spreadsheet fromFile() method does not return reject promise when an error occurs while loading file. An error is thrown on the browser console instead.
The issue has been tracked to the following implementation in the source:
the 'No file to be loaded!' should be alerted;
An error will be thrown on the console
Calling the saveAsExcel method of the Spreadsheet throws an error, and the component is not exported
Regression introduced with 2024.4.1112
Workaround: https://dojo.telerik.com/fDhKflqE/2
An error is thrown, and the file is not exported
No errors, and the file should be exported
Describe the bug
When a custom editor is defined and next to it there is a frozen column, the custom editor cannot be opened.
To reproduce
Steps to reproduce the behavior:
Expected behavior
The calendar should be opened
Workaround
.k-spreadsheet .k-selection-wrapper .k-spreadsheet-editor-button.k-spreadsheet-last-column {
transform: translateX(-100%);
}
The issue is a regression starting with themes version 6.3.0
Affected package (please remove the unneeded items)
Affected suites (please remove the unneeded items)
Affected browsers (please remove the unneeded items)
When the change event is bound after initialization it is not fired when changing a cell value.
The change event is not fired.
The change event should be triggered when a value of a cell has been changed.
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]
When exporting a Spreadsheet with a set background to a PDF file, some of its borders are not displayed.
Some borders of the Spreadsheet are missing in the exported PDF file.
All borders of the Spreadsheet should be displayed in the PDF file.
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 ]
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.
The new values are not pasted back to the Kendo UI Spreadsheet.
The following Toolbar localization settings are not applying for the Kendo UI Spreadsheet when it is configured with a localization/messages file and/or using JavaScript:
The toolbar messages should be translated.
When a cell that contains letters and numbers is dragged and dropped, the new content has an incorrect value. The issue appears when the first character is a letter and when the number contains zero.
The result should be the same value in case of text content (C0) or an incremented value in case the content ends with a number. Ex: A101 should result in A102, A103, A104 etc.
When trying to import an Excel document into the Kendo UI Spreadsheet with a missing/corrupt image reference, the file will not show.
The Kendo UI Spreadsheet fails to load the document.
The Kendo UI Spreadsheet should handle the error and load the Spreadsheet data without the image.
As demonstrated here: https://dojo.telerik.com/oFiJOciY
I have the spreadsheet's first row and first column frozen.
I have also made the editor background red, so it is easier to visualize.
Double click any cell below the frozen parts to enter editor mode, and you will see the editor drift out of its desired rectangle by 2 pixels,
This is likely caused by the 2px border applied on the k-spreadsheet-pane
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.
The result in B1 is 1, while it should be 0
When the content of the cell used for calculation is deleted, the product formula should result to 0 (as it is in Excel).
When the Spreadsheet height is greater than the page height and the user scrolls and than enters a value in a cell, the Spreadsheet scrolls to the top.
The Spreadsheet is scrolled to the top. screencast - https://go.screenpal.com/watch/cZj220V9U6j
The Spreadsheet should persist the position.
When attempting to validate a cell value against a predefined finite list, the validation process fails to recognize valid entries that are present in the list. Instead, it incorrectly flags them as invalid. The issue occur when there is an empty space before the first value in the 'from' option.
On the first row, the 'YES' in the B1 cell is marked as invalid although it is present in the list with the valid values. the difference between row 1 and row 4 is the empty space in the validation from configuration:
"from": "{ \"YES\", \"NO\"}", //row 1
"from": "{\"YES\", \"NO\"}" //row 4
The empty space added in the from
configuration option should not affect the validation. If the cell value is present in the list, it should be marked as valid.
Modified date value from Excel is not correctly updated when pasting in the Spreadsheet.
Regression introduced with 2023 R1
The updated date cell is not pasted in the Spreadsheet
The updated cell's value should be pasted in the Spreadsheet
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.
An error e[this._property] is not a function
is thrown and the background color is not changed.
There should be no error in the console and the color should be changed accordingly.
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
The hyperlink cannot be clicked.
The hyperlink should be clickable.
Workaround
As a workaround, you can add the following style:
.k-spreadsheet-data{
z-index: 100;
}
Bug report
The computed range when pasting data into the spreadsheet is incorrect.
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]
When the reference to a cell in a specific Sheet is added in the defineName function, using the name leads to invalid result.
The returned result is '#NAME?'
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: