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.
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.
Hyperlinks in a Spreadsheet cell do not work mobile devices.
The link in the cell does not work.
The link should work
Hi, I'm using the spreadsheet control and i'm having an issue with date columns.
When I enter a valid date, it works fine.
but when I enter an empty date (clicking delete on date column, or emptying out the contents)
the date gets stored as "new Date(0,0,-1)" ["Sat Dec 30 1899 00:00:00 GMT+1130 (New Zealand Daylight Time)" in my local time]
obviously, this is incorrect, and it should store the value as NULL.
it happens regardless of whether the schema/model has nullable=true.
If I manually modify the dataItem via JS, it stores it correctly as null.
I have a dojo demo set up which replicates the issue.
https://dojo.telerik.com/oFowivUN
Steps:
Doing some investigation into the kendo code, it seems to be caused by the serialToDate method of the spreadsheet.
Thanks