When the scale and layout setting of the machine is different than 100% the keyboard navigation does not work properly. The issue occurs with different scales on each machine. For example, on some machines, it could work with all scales, but on others, it may not work with a scale of 125% or 175%, even if this is the recommended value.
Note, that you may need to test with different scales to manage to replicate the issue.
The navigation does not work. The cell selection does not work or goes to a wrong cell.
The Spreadsheet navigation should work with all screen scales.
Bug report
Dropdownlist editor remains visible on scroll of the Scheduler
Reproduction of the problem
Dojo: https://dojo.telerik.com/iLusiHAm
Open the DropsDownList editor in B2 cell
Scroll down the sceduler
Expected/desired behavior
DropsDownList editor shall close
Environment
Kendo UI version: [all]
Browser: [all]
Hi Team,
I would like to request the functionality to be able support multiple languages for the Excel file. It would be great if there was a way to make the file content automatically change to a specific language.
For example, if we could use a collection of <English key, French strings> of a selected language e.g. French, and all Excel text strings matching with the English key would convert to the French text.
Thank you!
Hi Team,
I would like to request a way to include commas for the sheets.rows.cells.validation.from values.
For example:
Instead of:
Additionally, it would be nice to be able to use another delimiter instead of commas.
Thank you!
If you copy a cell whose text contains multiple spaces from one Spreadsheet and try to paste it in another, the multiple spaces are lost
The pasted content contains only one spaces instead of three, as in the original cell content
All the spaces should be preserved when pasting in another Spreadsheet.
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]
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
In the Spreadsheet, if you freeze too many columns and then try to export to Excel, the file is corrupted.
If you reduce the number of columns in the example below, the issue does not occur.
The exported file is corrupted and cannot be opened
The file should not be corrupted
Related to this ticket View Ticket | Your Account (telerik.com) (id: 1605513)
Basically, when all the rows fit in the viewport, the horizontal scrollbar should be entirely hidden instead of always visible.
In Firefox with Windows 11, the Spreadsheet cannot be scrolled using the scrollbars.
The Spreadsheet cannot be scrolled through the scrollbars
The Spreadsheet should be scrolled through the scrollbars
I have a column of a string type, but I would like to have a validation list such as ['1', '2', '3', '4', '5']. However, even after setting the format to '@' and the schema column to type: "string", after saving the values, the cells are marked as invalid, as the column is of type string and the values in the validation.from the list are numbers. Thus, the validation marks the values as invalid. Here is a Dojo that demonstrates the issue - in the Dojo after selecting a value in column C and saving the changes the value is marked as invalid
I would like the validation.from option to be improved, to have the possibility to set the type of values in the validation.from a list and have digits in a string column to be considered a valid value. Such improvement could be also helpful in scenarios where boolean true/false values should be considered as strings.
To whom it may concern,
I am having a problem with the AGGREGATE function in the spreadsheet control. Cell H7 does not give me a value.
I have attached a dojo saved file, the tutorial documentation I was following (please see pages 4 & 5), a screenshot of the function in dojo and an excel file with the aggregate function working.
Thank you advance.
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.
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
The cells after the merged cell should not be shifted.
Hi Team,
I would like to request the Kendo UI Spreadsheet to have CSP support.
Thank you for the consideration!
Ability for spreadsheet row height to be auto set from the row contents. This is to support wrapped text.
This is observed also in online demos:
Steps:
Has anyone at Kendo ever thought of putting an OnBlur event on a Spreadsheet Cell. The purpose of the event (at least in my case) would be to cancel navigation to another cell. The Change and Changing events are close, but from what I can tell there is no way to cancel the navigation when either of these events fire. If you navigate to another cell and the data has changed, the Changing event fires before the Select event, but there is no way to stop the select event from firing once the Changing even is complete. I tried using Select from with the Changing event to set navigate back to the same cell, but there is currently an open bug in respect to that, as it does not navigate properly.
To hopefully state it more clearly, It would be nice if the Spreadsheet cell had an OnBlur Event that allows you to cancel navigation and remain in the same cell. Ideally it would word for all forms of navigation. Mouse Click on new cell or Scroll with Arrows.