Currently, there is a KB that demonstrates how only values can be pasted into the Spreadsheet. However, to achieve pasting values the cells are modified programmatically, which leads to an improper undoRedo stack. In the knowledge base article if the user presses 'Undo' then a single cell will be undone.
We can add the editing of the cell using commands as demonstrated below, but this will require the user to undo the changes cell by cell and not the entire range at once:
spread._workbook.execute({ command: "EditCommand", options: { value: value, operatingRange: range, editRange: range}});
I think that it will be a good improvement if the Spreadsheet can be configured or if it provides a method that will allow paste-only values that will be properly added to the undoRedo stack and without additional customizations.
Regards
When values are pasted in the Spreadsheet if the cell is not empty the previous format is taken into account
The number column is formatted as date - screencast(https://somup.com/cZeoodChyH)
The current format should be applied to the pasted data.
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
Scrolling to a column that is not visible initially and using the Freeze Panes tool, makes the scrollbar of the Spreadsheet unusable. This valid for both horizontal and vertical scrolling. It is observable in the demos: https://demos.telerik.com/kendo-ui/spreadsheet/index
Scroll right to the "R" column. Select it and click on the the "Freeze panes" tool in the toolbar.
Alternatively, scroll down to row 30. Select a cell and click on the the "Freeze panes" tool.
As a result, scrolling the columns (respectively the rows) becomes impossible.
Consider a way to enhance the Freeze panes functionality, so that is is usable in these scenarios.
Hi again :)
I see that in the configuration I can specify the max number of rows/column. However, I can do it per component basis, and I would like to have that on a per-sheet basis. Any way I can implement this?
Thanks!
Describe the bug
To reproduce
Steps to reproduce the behavior:
Expected behavior
The panes are frozen without breaking the layout of the Spreadsheet and without cells/column duplication.
Affected package (please remove the unneeded items)
Affected suites (please remove the unneeded items)
Affected browsers (please remove the unneeded items)
Build system information (please remove the unneeded items)
Additional context
Add any other context about the bug.
In Firefox with Windows 11, the Spreadsheet cannot be scrolled using the scrollbars.
The Spreadsheet cannot be scrolled through the scrollbars
The Spreadsheet should be scrolled through the scrollbars
Hi Team,
When I add comments to enabled columns(product)it is allowing me to add and after reopening the comments it is retained. But when I add comments to disabled columns(ID) it is not adding to it and no messages are added like it is disabled and comments are not allowed.
demo: https://dojo.telerik.com/ISIvATiN
thanks.
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 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.
Bug report
Round Function from empty cell shows #VALUE! but in Excel, this shows 0
Reproduction of the problem
Open Dojo: https://dojo.telerik.com/aBOMoCOF
Paste in cell B1 the following formula: =ROUND(A1, 2)
The shown result is #VALUE!
In Excel the same formula returns 0
Expected/desired behavior
The shown value must be 0
Environment
Kendo UI version: [all]
Browser: [all ]
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).
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.
Currently, Kendo UI for jQuery Spreadsheet does not support many events such as style change, merge, unmerge, image insert, font change, alignment change, decimal change, filters and more.
But these events need to be captured in many cases.
Please support events for all the actions.
Currently, when an invalid validation formula is used, the Spreadsheet throws a js exception.
For example: https://dojo.telerik.com/AWEyIHoW
Open the Data/Data Validation dialogue on cell A3 and modify the Value of the Formula into an Invalid formula (e.g. : “>3”)
A parse error is thrown.
It would be a nice improvement, if instead of throwing a js exception, the user is notified about the invalid formula through a dialog showing a relevant message.
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 there is formatting and decimals are rounded negative numbers that round to zero show a negative sign. In Excel those are shown without the negative sign.
Dojo example: https://dojo.telerik.com/@iankodj/azEMIRUv/21