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
- Open this Dojo example - https://dojo.telerik.com/AZateGoC/6
- Copy the Spreadsheet content
- Paste in to an Excel file
- Change the date cell value
- 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
- Open the Dojo - https://dojo.telerik.com/@NeliK/IHaRIvoy
- 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
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]
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
- Open the Kendo UI Spreadsheet Overview
- Copy Data C7:D8 from Kendo Spreadsheet
- Paste data to MS Excel (used: Microsoft 365 MSO version 2309)
- Edit values in MS Excel.
- Copy from MS Excel
- 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 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
- Open the Dojo - https://dojo.telerik.com/@NeliKondova/oNODiSuj
- Scroll horizontally to the last column and click on the cell.
- 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 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
- Open the Dojo - https://dojo.telerik.com/@NeliKondova/eWeVASOK
- 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:
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
- Open the Dojo example - https://dojo.telerik.com/UcARaSok
- Expand the name box with the defined names.
- 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]
[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
- Open the Kendo UI Spreadsheet Overview
- Copy Data C7:D8 from Kendo Spreadsheet
- Paste data to MS Excel (used: Microsoft 365 MSO version 2309)
- Edit values in MS Excel.
- Copy from MS Excel
- 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 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.
Reproduction of the problem
- Open the Dojo
- Observe the content of the cell with the pink background.
behavior when importing:
- Import the file in the Spreadsheet demos
LINEST_INDEX.xlsx
Current behavior
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'.
Expected/desired behavior
The LINEST should work as expected in combination with the INDEX formula.
Environment
- Kendo UI version: 2023.1.314
- Browser: [all]
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:
- Open the demo
- Drag down the fill handle of a UnitPrice cell
Expected:
Button is enabled
Actual:
Button not enabled
Bug report
The Kendo UI Spreadsheet's RANK function appears to be ignoring the 3rd optional parameter for ordering the numeric values.
Reproduction of the problem
Please take a look at this Progress Kendo UI Dojo which demonstrates the third parameter being ignored, and it remains with the default order.
Expected/desired behavior
If the third parameter is set to 1 or a nonzero value, the order should be set to an ascending order.
Environment
- Kendo UI version: 2022.2.802
- jQuery version: All Supported
- Browser: all
Bug report
Dates and times entered (or pasted) in the spreadsheet are incorrectly parsed and do not respect the specified format. For example, dd.MM.yyyy HH:mm becomes MM.dd.yyyy HH:mm. The issue is replicated even if a culture is set.
Reproduction of the problem
- Open the Dojo
- Add the following date in Excel file and paste it in the Spreadsheet - 10.01.2022 09:00
Current behavior
The Spreadsheet does not parse the dates correctly.
10.01.2022 09:00 (january 10th) becomes 01.10.2022 09:00 (october 1st)
13.01.2022 09:00 is not affected by this issue.
10.01.2022 (january 10th, without time) is not affected by this issue.
Expected/desired behavior
Spreadsheet should parse the dates as they are. Copy dates such as 10.01.2022 09:00 should remain 10.01.2022 09:00 without switching the month and date values
Environment
- Kendo UI version: 2022.2.621
- jQuery version: x.y
- Browser: [all ]
Bug report
When defaultCellStyle is used the configured font is applied to the cells in the Spreadsheet. However, the font is not applied when adding new rows.
Reproduction of the problem
- Open the Dojo.
- Enter some text in the cells
- Insert a new row
- Enter text in the newly inserted row.
Current behavior
The configured font in the defaultCellStyle is not taken into account. The font in the newly inserted row is Arial 12, while in the example it should be 'Courier New' 18.
Expected/desired behavior
The font configured by using the defaultCellStyle option should be applied to all cells in the Spreadsheet, even if inserted after initialization.
Environment
- Kendo UI version: 2022.1.412
- Browser: [all ]
Bug report
When pasting content to a Spreadsheet that has only one column(columns: 1), the data is not pasted in the targeted cell and a JS error appears in the browser's console.
The issue appears only in scenarios where the columns configuration is set to 1.
- The reported behavior is a regression bug introduced in 2021 R1 SP1 - version 2021.1.224
Here is a Dojo example with 2021 R1 in which the described above issue is not replicable.
Reproduction of the problem
- Open this project and run it
- Copy random text
- Select a random cell(do not double click the cell) and press Ctrl + V to paste the copied content
Current behavior
No data is pasted in the selected cell and the below error appears in the console:
Expected/desired behavior
The user should be able to paste content in a Spreadsheet cell in all component scenarios - with one or multiple columns.
Environment
- Kendo UI version: 2022.1.301
- jQuery version: x.y
- Browser: [all]
Bug report
Cell value is not displayed after setting a formula for a range and creating a merged cell in the Spreadsheet.
Reproduction of the problem
- Open this Dojo example - https://dojo.telerik.com/UwexICot/4
Current behavior
The value of the B1:B2 merged cell is not displayed.
Expected/desired behavior
The value of the B1:B2 merged cell should be displayed.
Environment
- Kendo UI version: 2022.1.119
- Browser: [all]
Bug report
When trying to select multiple cells in Spreadsheet, an error "n._ref.height is not a function" occurs.
Regression introduced with R3 2021.
Reproduction of the problem
- Open this demo - https://demos.telerik.com/kendo-ui/spreadsheet/index
- Try to select multiple cells using CTRL.
Current behavior
An error "n._ref.height is not a function" occurs and cells are not selected.
Expected/desired behavior
No error should occur and cells should be selected.
Environment
- Kendo UI version: 2022.1.119
- Browser: [all]
In Excel I can create a merged cell. For this example, I will merge A1:B1 and name the range MyCell. Next I name the single cell D5, and call it MyAnswer. I can enter the following formula into MyAnswer, =MyCell and Excel will return the result.
Using Telerik if I create the same layout I get a #Value or #Spill error because Telerik requires MyAnswer to be the same merge configuration as MyCell which creates a significant disadvantage in usability.
Can you please advise when this issue will be fixed in Telerik.
I have attached a screen recording of this not working in your Dojo named "Telerik merge cell reference not working when not same col.mov".
Thank you so much.
Hello,
When spreadsheet cells are merged and have comment, it's shown only when hovering over first cell and not shown when hovering over other cells of the merged group of cells
Example to reproduce on dojo - https://dojo.telerik.com/@Andrii/uHINuvIh
On the cell A1 there is a comment, merged cells are A1:G1, comment is shown only when hover over cell A1.
Hi
We have noticed that spreadsheet filter box (click on filter down arrow) didnt appear when clicked on certain environment (win10, surface pro 7), but works on others.
What happens is you click the down arrow, a scroll bar appears on rhs, which i think is suggesting the popup has positioned soemwhere off visible area.
This happens in each browser - edge (94.0.992.50 ), chrome (95.0.4638.54 ) and firefox (93.0). Plug ins disabled. Windows 10.0.19043
Wondered if about high res screens or display settings?
Recreated with kendo demo
https://dojo.telerik.com/aruPOzEx
then tried each kendo version going back in time, and basically version 2020 R2 SP1 it worked (see attached working.. shot), and anything since it fails.
In the shots i am clicking on company filter arrow. the failversion-before is before i click, failversion-after is after click - where you can see extra vertical scrollbar
Regards
Chris
Bug report
When you enter a value with leading zeros and then use the drag handle at the bottom right corner to change the value of the cells below, the leading zeros are being removed.
Reproduction of the problem
- Go to the Basic Usage example - https://demos.telerik.com/kendo-ui/spreadsheet/index
- Enter "SS0012" as value in a random cell.
- Grab the handle at the bottom right of the cell and drag down.
Current behavior
The value entered for the cells below is SS13, SS14 etc.
Expected/desired behavior
The value entered for the cells should be SS0012, SS0013 etc.
Environment
- Kendo UI version: 2021.3.914
- Browser: [all]