When you copy a formatted cell with value "0", pasting the content in the Spreadsheet results in an incorrect value in the formula input.
The value of the cells containing "-" are incorrectly changed to "-" in the formula bar.
The value of the cells containing "-" should remain "0" in the formula bar.
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:
Spreadsheet throws error when opening a xlsx file containing diagonal borders.
Spreadsheet crashes and throws an error Uncaught TypeError: Cannot set property 'color' of undefined
The file should open.
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:
Reported in ticket № 1429260
The date is pasted as string with value of hash tags.
The date is pasted as a date
The e.ClipboardContent.data contains the hash tag string as value, so the issue should be somewhere in the clipboard pasting logic
If an Excel file that contains Shapes is imported in the Spreadsheet, the imported content cannot be exported back to '.xlsx' file. Saving the imported content to Excel throws an error in the console.
Exporting the Spreadsheet content throws an error in the console:
The Spreadsheet content should be exported to Excel file that doesn't contain the shapes from the imported file
when the color of the borderBottom is commented
"borderBottom": {
//"color": "black",
js error when color is not applied a cell of the Spreadsheet
kendo.all.js:61278 Uncaught TypeError: e.transform is not a function
https://dojo.telerik.com/@zdravkov/iVoJuxAZ
export to pdf
js error
the data is exported correctly
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
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.
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!
Hi,
When editing a workbook with the Spreadsheet component, if a user switches from a worksheet to another, then moves the scrollbars, when switching back, although the active cell is adequately recovered, the scrollbars are not (the user experience is that they do not react to worksheet switching).
Is this behavior planned to be changed? Is there a workaround?
Best
Currently, when the "Custom format" button in the Spreadsheet is clicked, the available predefined formats that can be applied to a cell appear as demonstrated in the below screenshot. These predefined options don't change if you set a specific Kendo UI culture.
It will be a very useful feature to be able to change the predefined custom formats. Also, it will be nice if the custom formats in the Spreadsheet can be set based on the selected Kendo UI culture.
It would be great if you could put images to cells using html. E.g.: <img src="..."> would result in an image in the cell.
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).
add search functionality to the Spreadsheet.
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.