In the Speadsheet, the items of the DropDownButton for the sheet tabs are hardcoded and cannot be translated
The DropDownButton's items are not translated
The DropDownButton's items are not translated
Bug report
Dropdown Not Visible in Frozen Pane in Kendo jQuery Spreadsheet
Reproduction of the problem
Dojo example - https://dojo.telerik.com/mLetbVPM
Environment
jQuery: 3.7.0
Kendo UI version: [all]
Browser: [all]
Hi Team,
I would like to request to include the PMT function for the Kendo UI Spreadsheet.
Thank you!
Using a datasource on a sheet
Selecting entire sheet and clicking the filter in the data toolbar tab.
The buttons for the columns do not respect the size of rowHeight or headerHeight
Set rowHeight to 20 and i get this
In the Spreadsheet, if you attempt to delete a row that contains a disabled cell, the operation is pushed in the undo stack. Pressing the undo button inserts a copy of the row with empty disabled cell.
A new row is inserted above the selected row, as the unsuccessful delete operation is pushed in the undo stack
The unsuccessful delete operation shouldn't pushed in the undo stack
When you add a filter to a column on the spreadsheet component, only the down arrow icon part of the filter button is clickable, not the entire button.
The filter menu is not opened unless we click on the icon.
The filter menu should open when the button is clicked.
When cell with border is cut in the Spreadsheet, the border is also removed from the next cells.
The cell A2 should have a right border, cell C2 should have a left border, etc...
The next cells borders are cut as well
Bug report
Data validation should not require DATEVALUE("") in Start and End inputs when `Date` is selected
Reproduction of the problem
https://demos.telerik.com/kendo-ui/spreadsheet/index
1. Select an empty cell
2. Click Data validation
3. Set Start: DATEVALUE("1/1/2024") and End: DATEVALUE("2/2/2025")
4. Automatic Hint message looks like: between DATEVALUE("1/1/2024") and End: DATEVALUE("2/2/2025")
Expected
Generated hint message shall not contain DATEVALUE("")
Environment
**Kendo UI version: [all]
**Browser: [all]
Bug report
Spreadsheet cellContextMenu() throws an error
Regression with 2024.4.1112
Reproduction of the problem
Run the Dojo: https://dojo.telerik.com/SlDUjkTQ
Check console
`Uncaught TypeError: spreadsheet.cellContextMenu is not a function`
Environment
jQuery: 3.4.1
Kendo UI version: 2024.4.1112 or newer
Browser: [all]
Hi Team,
We are using the Kendo Spreadsheet and would like to request a feature to display a character limit indicator while the user is entering data in the cell. This is to prevent users from exceeding the character limit of a cell.
Thank you!
Bug report
Spreadsheet validation on datatype=list, values in the dropdown are parsed to numbers. Numeric strings are automatically formatted by removing the heading zero.
Reproduction of the problem
Dojo: https://dojo.telerik.com/eOOvKJxL
validation: {
dataType: "list",
showButton: true,
comparerType: "list",
from: "{ \"001\", \"002\", \"Baz item 3\" }",
allowNulls: true,
type: "reject"
} The bug is a regression, formatting is different with a 2017 version: https://dojo.telerik.com/sCvgBzBa/5
Environment
**Kendo UI version: 2025.1.211
**Browser: [all]
Hi Team,
I would like to request emf image support for the Kendo UI Spreadsheet. If that is not possible, I would like to request a way to handle if the image is in a non-supported image type - such as a console error.
Thank you!
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]
Hi Team,
I would like to request a built-in way to set a reject type validation when a value is programmatically set in the Kendo UI Spreadsheet. Currently, it only sets a warning type as shown in this Kendo UI Dojo.
Thanks!
When a cell is copied to another cell by using the 'auto-fill' option, the format and validation from the initial cell is applied to the target as well, as described in the documentation.
- https://docs.telerik.com/kendo-ui/controls/spreadsheet/end-user/user-guide#other
I would like the possibility to persist the format and validation of the targeted cell and if for example non-valid data is dragged and dropped in a cell, the content to be rejected based on the targeted cell validation.
Hi Team,
I would like to request to include the Embed function for the Kendo UI Spreadsheet to include objects such as PDF files into the Spreadsheet.
Thank you!
Hi Team,
I would like to request the open button for the Kendo UI Spreadsheet's toolbar to fully utilize a Kendo UI Button rather than a native input button. One benefit would be to help provide a localization message with ease.
Thank you!
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