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
Cell value is not displayed after setting a formula for a range and creating a merged cell in the Spreadsheet.
The value of the B1:B2 merged cell is not displayed.
The value of the B1:B2 merged cell should be displayed.
When trying to select multiple cells in Spreadsheet, an error "n._ref.height is not a function" occurs.
Regression introduced with R3 2021.
An error "n._ref.height is not a function" occurs and cells are not selected.
No error should occur and cells should be selected.
Hi there,
I'd love the ability to specify regex validation for the spreadsheet component. I saw a forum post (https://www.telerik.com/forums/spreadsheet-regex-validation) someone else had made relating to this, but couldn't find a feature request made based off of it.
(taken from the post) Ideally it'd look something like this:
var columnSens = spreadsheet.activeSheet().range("A2:A10");
columnSens.validation({
dataType: "custom",
from: 'REGEX("^(()|((?=.*[a-z])(?=.*[A-Z])(?=.*\d)(?=.*[^\da-zA-Z]).{8,60}))$")',
type: "warning",
allowNulls: true,
titleTemplate: "Invalid Password",
messageTemplate: "Passwords must be between 8 - 60 characters long and contain the following: 1 number, 1 uppercase letter, 1 lowercase letter, and 1 special (non letter or number) character."
});
Hi Team,
I'd like to request the functionality to be able to filter null and whitespace items more easily with the built-in API for the Kendo UI Spreadsheet.
Thank you!
Describe the bug
When the Spreadsheet has locked columns and columnWidth is set, but the width of the locked exceed the width of the Spreadsheet, the widget is not rendered correctly.
To reproduce
Steps to reproduce the behavior:
The columns of the Spreadsheet are visible even outside of the component.
Expected behavior
The columns should be limited to the Spreadsheet width
Affected package (please remove the unneeded items)
Affected suites (please remove the unneeded items)
Affected browsers (please remove the unneeded items)
Currently, the Spreadsheet does not appear and does not function properly when the 'k-rtl' class is applied.
Please provide Right-To-Left support for the Spreadsheet widget.
Hi Team,
I would like to request the Kendo UI Grid to improve performance when evaluating multiple formulas. At this point, if I use a formula on multiple rows(over 1500 rows), the page slows and eventually crashes. This happens when I use the fromFile method too.
Thank you for the consideration!