Bug report
Reproduction of the problem
Reproducible in the demos.
- Use the HYPERLINK function in a cell:
=HYPERLINK("https://google.com")
Current behavior
The link does not work. It does if you specify a "friendly name":
=HYPERLINK("https://google.com", "google")
Expected/desired behavior
The link works with and without a "friendly name" specified, as in Excel.
Environment
- Kendo UI version: 2019.2.619
- 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
[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
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]
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
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
- Download the test-2.zip file and load the "test.xlsx" file in the Spreadsheet here.
- 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
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
- Run this dojo
- Select cell E1, press F2 to edit formula and press
Ctrl+Shift+Enterto enter as an array formula
Current behavior
- Enter a value in cell B1 - Array formula evaluates as TRUE, Non-array formula as FALSE
- 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
Dojo example.
- Click column "B"'s header to select the column.
- Use the "Wrap text" tool from the toolbar. The text in B2 is wrapped.
- 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
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
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
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
- Open the Dojo - https://dojo.telerik.com/@NeliKondova/ApAGUkET
- 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
In Firefox with Windows 11, the Spreadsheet cannot be scrolled using the scrollbars.
Reproduction of the problem
- Open the Overview demo in Firefox on a machine that uses Windows 11
- Try to scroll vertically or horizontally.
Current behavior
The Spreadsheet cannot be scrolled through the scrollbars
Expected/desired behavior
The Spreadsheet should be scrolled through the scrollbars
Environment
- Kendo UI version: 2023.1.314
- Browser: [Firefox + Windows 11]
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
When the select() method is used in the Spreadsheet changing event wrong cell is selected.
Reproduction of the problem
- Open the dojo example
- 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
Open this web site:
https://demos.telerik.com/kendo-ui/spreadsheet/datasource
And follow the steps provided here:
https://www.screencast.com/t/UdEKYqIve
Current behavior
The first added cell value (or row) is removed when the user deletes an empty row.
If the ID is entered, the result is even stranger:
https://www.screencast.com/t/osmVOiY7al
Expected/desired behavior
It should behave and function like Excel. I think with local/static binding there are no issues.
Bug report
In Spreadsheet, the cell format is lost when you change its value.
Reproduction of the problem
- Open this Dojo example - https://dojo.telerik.com/@martin.tabakov@progress.com/EWUdUDUp/2
- Change the value of cell C3 to 5.5678
Current behavior
The new value is not rounded as per the preset format.
Expected/desired behavior
The new value should respect the format set for the cell.
Environment
- Kendo UI version: 2021.2.616
- 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.
When there is formatting and decimals are rounded negative numbers that round to zero show a negative sign. In Excel those are shown without the negative sign.
Dojo example: https://dojo.telerik.com/@iankodj/azEMIRUv/21
Bug report
When the Sheetsbar is hidden the horizontal scrollbar is not adjusted to the bottom of the widget
Reproduction of the problem
- Run this dojo
- 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]
Describe the bug
To reproduce
Steps to reproduce the behavior:
- Go to https://dojo.telerik.com/avuXEJUV/2
- Scroll the Spreadsheet horizontally to the "J" column.
- Click the header of the "J" column to select it.
- Activate the "Freeze Panes" tool from the toolbar.
- The Spreadsheet re-renders. The scroll bar does not scroll the columns past "G". A browser scrollbar appears. Use it to scroll horizontally beyond the right border of the Spreadsheet. Some of the columns are displayed outside the Spreadsheet. Once they are visible, scroll horizontally to the far right using the Spreadsheet scrollbar. Column A is duplicated after column AX.
Expected behavior
The panes are frozen without breaking the layout of the Spreadsheet and without cells/column duplication.
Affected package (please remove the unneeded items)
- theme-default
- theme-bootstrap
- theme-material
Affected suites (please remove the unneeded items)
- Kendo UI for jQuery
Affected browsers (please remove the unneeded items)
- All
Build system information (please remove the unneeded items)
- Not Applicable
Additional context
Add any other context about the bug.