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
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.
When cells of the Spreadsheet that contain data are merged data loss occurs.
To prevent inappropriate merges we need to be able to handle an Merge/Unmerge event of the Component that should be preventable.
Thank you.
When the select() method is used in the Spreadsheet changing event wrong cell is selected.
Changing event is fired, but the 'B3' cell is selected instead of the 'B2'
The correct cell should be selected when using the select method inside the Spreadsheet event handlers.
Hi Support Team,
Would like to have a feature below:
Hi Support Team,
When select multiple cells continuously and right click, it will have more options. But when select multiple cells without continuously and right click, there is only 1 option
Would like to have a feature to have more options when select multiple cells without continuously and right click and also to able to detect which cells are selected if multiple cells are selected without continuously.
Select multiple cells continuously: Select multiple cells without continuously:
Hi Team,
I'd like to request the functionality to allow cell configurations to be populated by database values by default. For example, I'd like to have a value from the database populate the specific link configuration.
Thank you!
The Kendo UI Spreadsheet's RANK function appears to be ignoring the 3rd optional parameter for ordering the numeric values.
Please take a look at this Progress Kendo UI Dojo which demonstrates the third parameter being ignored, and it remains with the default order.
If the third parameter is set to 1 or a nonzero value, the order should be set to an ascending order.
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.
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.
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
Currently, when a custom button is configured in the Spreadsheet toolbar a separator is added before the button. I would like to have an option to configure whether such a separator is to be rendered or not.
I would like to avoid adding custom styles for hiding unneeded separators, which is needed with the current implementation (Dojo).
When a border is applied and there are frozen rows/columns the border appears splitted with a white lin in the middle.
The bottom border and the right border are split with a white line in the middle.
The border should appear entirely filled with the selected color.
Hyperlinks in a Spreadsheet cell do not work mobile devices.
The link in the cell does not work.
The link should work
Spreadsheet doеs not allow selecting of multiple cells when opened on Microsoft Surface. It is also not possible to resize columns.
Issue 1
Issue 2
In the Spreadsheet Index demo select a column. Try to place the mouse in between columns for the icon to be changed and to will be able to resize the column.
Currently, the selection in the Spreadsheet could not be expanded to multiple cells and the columns could not be resized when the Spreadsheet is used on a Microsoft Surface device.
The Spreadsheet should allow selecting multiple cells and resizing columns when opened on a Microsoft Surface device.
Open this web site:
https://demos.telerik.com/kendo-ui/spreadsheet/datasource
And follow the steps provided here:
https://www.screencast.com/t/UdEKYqIve
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
It should behave and function like Excel. I think with local/static binding there are no issues.
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.
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.
The font configured by using the defaultCellStyle option should be applied to all cells in the Spreadsheet, even if inserted after initialization.
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.
No data is pasted in the selected cell and the below error appears in the console:
The user should be able to paste content in a Spreadsheet cell in all component scenarios - with one or multiple columns.
Hi Admin,
I made the DIV where I had the Spreadsheet widget in full screen mode by: document.fullscreenElement. I have some validations configured in the spreadsheet. Apparently, in full screen mode, the prompt opens behind it. Is there a way I can do an "appendTo" to the validation prompt?
Please advise.
Thank you very much.
Best Regards,
Jenny
Hello
When we have filtered rows in a spreadsheet (some rows are hidden) and we copy a single cell and paste into a range containing the hidden rows....
The spreadsheet copies the value into all cells in the range including those that are hidden. This is not the same functionality as Excel.
That said, is the any way to skip hidden cells in the paste range?
Is there a way to override the Kendo past function to do this? Can you provide an example?
Thank you
Jeffrey Suffet