Spreadsheet doеs not allow selecting of multiple cells when opened on Microsoft Surface. It is also not possible to resize columns.
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.
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.
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?
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.
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).
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.
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.
Doing some investigation into the kendo code, it seems to be caused by the serialToDate method of the spreadsheet.
When you enter a value with leading zeros and then use the drag handle at the bottom right corner to change the value of the cells below, the leading zeros are being removed.
The value entered for the cells below is SS13, SS14 etc.
The value entered for the cells should be SS0012, SS0013 etc.
Use case: My app doesn't know how many rows of data the excel spreadsheet will be prior to upload. I've defaulted to my maximum amount of 10,000 which will be normal for some, but overkill for others. The ability to change the number of rows/columns to accommodate the size of the sheet after loading, would be a nice addition. As a workaround, I'm destroying and reloading the widget instance after the initial load.
Open this web site:
And follow the steps provided here:
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:
It should behave and function like Excel. I think with local/static binding there are no issues.