Modified date value from Excel is not correctly updated when pasting in the Spreadsheet.
Regression introduced with 2023 R1
The updated date cell is not pasted in the Spreadsheet
The updated cell's value should be pasted in the Spreadsheet
Bug report
Some date formats are lost when pasting from Excel and parsed as strings
Reproduction of the problem
Excel provided in Ticket ID: 1658266
copy and paste that into any Kendo Spreadsheet component.
Expected/desired behavior
Dates shall be parsed to dates
Environment
Kendo UI version: [all]
Browser: [all]
When attempting to validate a cell value against a predefined finite list, the validation process fails to recognize valid entries that are present in the list. Instead, it incorrectly flags them as invalid. The issue occur when there is an empty space before the first value in the 'from' option.
On the first row, the 'YES' in the B1 cell is marked as invalid although it is present in the list with the valid values. the difference between row 1 and row 4 is the empty space in the validation from configuration:
"from": "{ \"YES\", \"NO\"}", //row 1
"from": "{\"YES\", \"NO\"}" //row 4
The empty space added in the from
configuration option should not affect the validation. If the cell value is present in the list, it should be marked as valid.
When the Spreadsheet height is greater than the page height and the user scrolls and than enters a value in a cell, the Spreadsheet scrolls to the top.
The Spreadsheet is scrolled to the top. screencast - https://go.screenpal.com/watch/cZj220V9U6j
The Spreadsheet should persist the position.
As demonstrated here: https://dojo.telerik.com/oFiJOciY
I have the spreadsheet's first row and first column frozen.
I have also made the editor background red, so it is easier to visualize.
Double click any cell below the frozen parts to enter editor mode, and you will see the editor drift out of its desired rectangle by 2 pixels,
This is likely caused by the 2px border applied on the k-spreadsheet-pane
When the formula PRODUCT is used and the content of the cell based on which the formula is calculated is deleted, the result is incorrect.
The result in B1 is 1, while it should be 0
When the content of the cell used for calculation is deleted, the product formula should result to 0 (as it is in Excel).
The following Toolbar localization settings are not applying for the Kendo UI Spreadsheet when it is configured with a localization/messages file and/or using JavaScript:
The toolbar messages should be translated.
Hi Team,
I would like to request the open button for the Kendo UI Spreadsheet's toolbar to fully utilize a Kendo UI Button rather than a native input button. One benefit would be to help provide a localization message with ease.
Thank you!
Hi Team,
I would like to request to include the Embed function for the Kendo UI Spreadsheet to include objects such as PDF files into the Spreadsheet.
Thank you!
When a cell is copied to another cell by using the 'auto-fill' option, the format and validation from the initial cell is applied to the target as well, as described in the documentation.
- https://docs.telerik.com/kendo-ui/controls/spreadsheet/end-user/user-guide#other
I would like the possibility to persist the format and validation of the targeted cell and if for example non-valid data is dragged and dropped in a cell, the content to be rejected based on the targeted cell validation.
Hi Team,
I would like to request a built-in way to set a reject type validation when a value is programmatically set in the Kendo UI Spreadsheet. Currently, it only sets a warning type as shown in this Kendo UI Dojo.
Thanks!
Hi Team,
I would like to request emf image support for the Kendo UI Spreadsheet. If that is not possible, I would like to request a way to handle if the image is in a non-supported image type - such as a console error.
Thank you!
Describe the bug
When a custom editor is defined and next to it there is a frozen column, the custom editor cannot be opened.
To reproduce
Steps to reproduce the behavior:
Expected behavior
The calendar should be opened
Workaround
.k-spreadsheet .k-selection-wrapper .k-spreadsheet-editor-button.k-spreadsheet-last-column {
transform: translateX(-100%);
}
The issue is a regression starting with themes version 6.3.0
Affected package (please remove the unneeded items)
Affected suites (please remove the unneeded items)
Affected browsers (please remove the unneeded items)
Spreadsheet fromFile() method does not return reject promise when an error occurs while loading file. An error is thrown on the browser console instead.
The issue has been tracked to the following implementation in the source:
the 'No file to be loaded!' should be alerted;
An error will be thrown on the console
Hi Team,
We are using the Kendo Spreadsheet and would like to request a feature to display a character limit indicator while the user is entering data in the cell. This is to prevent users from exceeding the character limit of a cell.
Thank you!
Set Fixed Cols/Rows etc. or setOptions( {filter: { ref: "A3:G49", columns:[]}});
Bug in js\spreadsheet\numformat.js makeDateFormat
You appear to be using the wrong indices inside a nested loop.
if (/^(?:date|time|ampm)$/.test(section.body[i].type)) {
Should be (switch i to j)
if (/^(?:date|time|ampm)$/.test(section.body[j].type)) {
Getting error
Uncaught TypeError: Cannot read property 'type' of undefined
at Object.<anonymous> (numformat.js:630)
Note: Version is actually 2018.3.1114 from npm