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:
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.
The list with items does not appear.
The items should be displayed.
Spreadsheet saveAsExcel split is not a function error (kendo.all.js:3436) after upgrade to Kendo 2019.2.514.
Reproducible in the demos. The attached video demonstrates the issue.
Recording49.zip
As shown in the video, the F column completely disappears. The column letter remains visible within the next column (G). F column's resize handle remains hidden, and it cannot be made visible.
There should be a minimum column width that should be respected on resizing. Its value should always allow the column to be resized. No column overlapping should occur.
When the INDEX formula is used in combination with LINEST the Spreadsheet displays an empty cell. In case such formula is imported from Excel file '#VALUE' is displayed.
behavior when importing:
The content of the formula cell that includes LINEST and INDEX is empty. When clicking on the cell the formula is displayed in the formula bar. When importing the content in some cases the content is '#VALUE'.
The LINEST should work as expected in combination with the INDEX formula.
When destroying a SpreadSheet and removing its corresponding DOM element, there are some DOM nodes added on SpreadSheet's initialization which are not removed after the execution of .destroy() and .remove().
Not all DOM elements added on SpreadSheet initialization are being removed when destroying it and removing its corresponding DOM element.
After destroying a SpreadSheet and removing its corresponding DOM element, no DOM nodes added on component's initialization should be presented in the DOM tree.
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.
Dear Concerned,
1. Launch https://demos.telerik.com/kendo-ui/spreadsheet/index
2. Try to select columns B to D using mouse
3. Click on column B, keeping mouse clicked, move your mouse towards C then D
4. It does not allow to select B,C,D where as it is possible in Excel.
It is serious issue for me as I could not proceed with Hide/Unhide columns and some other features depend on multiple columns selection
Note: if we add a blank row at first position then it works well, seems like first with merged columns is creating problem.
1. Open "Sample Kendo UI SpreadSheet Example.html" attached html file in the chrome browser.
2. Click on open button in the Toolbar of the spreadsheet.
3. Select "Sample Excel with Font Colors.xlsx" attached excel file. This excel file contains headers with background color and Rows with ForeColors.
4. Now when the file is loaded, you will observe that B2, B3 and B5 should come up in Red fore color but the fore color of these cell in the kendo spread sheet is Black.
5. Similarly C2 to C5 should come in Green color but the fore color in the spreadsheet is black.
Query: Kindly let me know how can we achieve the fore color present in the excel sheet show show up in the Kendo UI Spreadsheet?
To reproduce
Steps to reproduce the behavior:
step1: Make a cell become wrap text and text something
step2: Export to pdf file:
Expected behavior
Text display same as on safari
Please fix this problem asap!!!.
There is an issue with the Date type fields validation in the Spreadsheet.
Here are the reproduction steps:
1. Open https://demos.telerik.com/kendo-ui/spreadsheet/index
2. Import attached xlsx file.
3. There are two date cells (B1 & B2), B2 has a data validation (Date between B1 to ToDay)
4. Try to edit the date using the calendar icon from B2. An empty calendar appears
Note: If I change data validation (remove reference of B1 and put hardcoded date) as below then it works.
Dear Concerned,
1. Launch https://demos.telerik.com/kendo-ui/spreadsheet/index
2. Open Workbook(1).xlsx (attached)
3. Edit B2, D2, F2 with some new values
4. See the results in B4, D4, F4
Calculations are different in Excel.
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;
}
Cannot delete defined names in the name box of the Spreadsheet when clicking the delete button.
Regression introduced with 2022.1.119
The items cannot be deleted.
The following error appears in the browser console:
Uncaught TypeError: Cannot read properties of undefined (reading 'name')
The items in the name box should be deleted and an error should not appear.
When the Spreadsheet is bound to a DataSource upon making multiple selections in the Spreadsheet and deleting the selected ranges a JavaScript error is thrown: "Unsupported for multiple ranges." The selected cells are deleted on the UI, but the DataSource change event is not triggered.
A JavaScript error is thrown: "Unsupported for multiple ranges." The selected cells are deleted on the UI, but the DataSource change event is not triggered.
Upon an attempt to delete multiple selections a popup should be displayed with a warning that this operation is not supported, similar to trying Copy/Paste multiple selections.
After the 2022 R2 SP1 version. there is a bug in the spreadsheet data source. when dill down the cell, the data source will not be changed. only input text can trigger the change event.
Reproduction steps:
Expected:
Button is enabled
Actual:
Button not enabled
When you copy a formatted cell with value "0", pasting the content in the Spreadsheet results in an incorrect value in the formula input.
The value of the cells containing "-" are incorrectly changed to "-" in the formula bar.
The value of the cells containing "-" should remain "0" in the formula bar.
Spreadsheet throws error when opening a xlsx file containing diagonal borders.
Spreadsheet crashes and throws an error Uncaught TypeError: Cannot set property 'color' of undefined
The file should open.
Reported in ticket № 1429260
The date is pasted as string with value of hash tags.
The date is pasted as a date
The e.ClipboardContent.data contains the hash tag string as value, so the issue should be somewhere in the clipboard pasting logic